Get a row - Coda

Returns details about a row in a table.

{ "parent": { "tableType": "table", "parent": { "id": "canvas-IjkLmnO", "href": "https://coda.io/apis/v1/docs/AbCDeFGH/pages/canvas-IjkLmnO", "browserLink": "https://coda.io/d/_dAbCDeFGH/Launch-Status_sumnO", "name": "Launch Status", "type": "page" }, "id": "grid-pqRst-U", "href": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U", "browserLink": "https://coda.io/d/_dAbCDeFGH/#Teams-and-Tasks_tpqRst-U", "name": "Tasks", "type": "table" }, "id": "i-tuVwxYz", "href": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/rows/i-RstUv-W", "name": "Apple", "index": 7, "browserLink": "https://coda.io/d/_dAbCDeFGH#Teams-and-Tasks_tpqRst-U/_rui-tuVwxYz", "createdAt": "2018-04-11T00:18:57.946Z", "updatedAt": "2018-04-11T00:18:57.946Z", "type": "row", "values": { "c-tuVwxYz": "Apple", "c-bCdeFgh": [ "$12.34", "$56.78" ] } }

请求参数

Path 参数

docId

string

必需

ID of the doc.

示例值:

AbCDeFGH

tableIdOrName

string

必需

ID or name of the table. Names are discouraged because they're easily prone to being changed by users. If you're using a name, be sure to URI-encode it.

示例值:

grid-pqRst-U

rowIdOrName

string

必需

ID or name of the row. Names are discouraged because they're easily prone to being changed by users. If you're using a name, be sure to URI-encode it. If there are multiple rows with the same value in the identifying column, an arbitrary one will be selected.

示例值:

i-tuVwxYz

Query 参数

useColumnNames

boolean

可选

Use column names instead of column IDs in the returned output. This is generally discouraged as it is fragile. If columns are renamed, code using original names may throw errors.

示例值:

true

valueFormat

enum<string>

可选

The format that cell values are returned as.

枚举值:

simplesimpleWithArraysrich

返回响应

🟢200Info about a row. If this row was retrieved by name, only one matching row will be returned, with no guarantees as to which one it is.

application/json

Body

Details about a row.

parent

object (TableReference)

必需

Reference to a table or view.

tableType

enum<string>

必需

枚举值:

tableview

parent

object (PageReference)

可选

Reference to a page.

string

必需

ID of the table.

示例值:

grid-pqRst-U

href

string <url>

必需

API link to the table.

示例值:

https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U

browserLink

string <url>

必需

Browser-friendly link to the table.

示例值:

https://coda.io/d/_dAbCDeFGH/#Teams-and-Tasks_tpqRst-U

name

string

必需

Name of the table.

示例值:

Tasks

type

enum<string>

必需

The type of this resource.

枚举值:

table

string

必需

ID of the row.

示例值:

i-tuVwxYz

href

string <url>

必需

API link to the row.

示例值:

https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/rows/i-RstUv-W

name

string

必需

The display name of the row, based on its identifying column.

示例值:

Apple

index

integer

必需

Index of the row within the table.

示例值:

browserLink

string <url>

必需

Browser-friendly link to the row.

示例值:

https://coda.io/d/_dAbCDeFGH#Teams-and-Tasks_tpqRst-U/_rui-tuVwxYz

createdAt

string <date-time>

必需

Timestamp for when the row was created.

示例值:

2018-04-11T00:18:57.946Z

updatedAt

string <date-time>

必需

Timestamp for when the row was last modified.

示例值:

2018-04-11T00:18:57.946Z

type

enum<string>

必需

The type of this resource.

枚举值:

row

values

object

必需

Values for a specific row, represented as a hash of column IDs (or names with useColumnNames) to values.

示例值:

{"c-tuVwxYz":"Apple","c-bCdeFgh":["$12.34","$56.78"]}

额外字段

CellValue

可选

All values that a row cell can contain.

🟠401401

🟠403403

🟠404404

🟠429429