List columns

Returns a list of columns in a table.

{ "nextPageToken": "eyJsaW1pd", "items": [ { "format": { "type": "text", "isArray": true, "label": "Click me", "disableIf": "False()", "action": "OpenUrl(\"www.google.com\")" }, "id": "c-tuVwxYz", "href": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns/c-tuVwxYz", "name": "Completed", "display": true, "calculated": true, "formula": "thisRow.Created()", "defaultValue": "Test", "type": "column" } ], "href": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns?limit=20", "nextPageLink": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns?pageToken=eyJsaW1pd" }

请求参数

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

Query 参数

limit

integer

可选

Maximum number of results to return in this query.

>= 1

默认值:

示例值:

pageToken

string

可选

An opaque token used to fetch the next page of results.

示例值:

eyJsaW1pd

visibleOnly

boolean

可选

If true, returns only visible columns for the table. This parameter only applies to base tables, and not views.

示例值:

true

返回响应

🟢200List of columns in the table.

application/json

Body

List of columns.

nextPageToken

string

可选

If specified, an opaque token used to fetch the next page of results.

示例值:

eyJsaW1pd

items

array[object (Column) {9}]

必需

format

ColumnFormat

必需

Format of a column.

string

必需

ID of the column.

示例值:

c-tuVwxYz

href

string <url>

必需

API link to the column.

示例值:

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

name

string

必需

Name of the column.

示例值:

Completed

display

boolean

可选

Whether the column is the display column.

示例值:

true

calculated

boolean

可选

Whether the column has a formula set on it.

示例值:

true

formula

string

可选

Formula on the column.

示例值:

thisRow.Created()

defaultValue

string

可选

Default value formula for the column.

示例值:

Test

type

enum<string>

必需

The type of this resource.

枚举值:

column

href

string <url>

可选

API link to these results

示例值:

https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns?limit=20

nextPageLink

string <url>

可选

If specified, a link that can be used to fetch the next page of results.

示例值:

https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns?pageToken=eyJsaW1pd

🟠401401

🟠403403

🟠404404

🟠429429