Get a column

Returns details about a column in a table.

{ "format": { "type": "text", "isArray": true, "label": "Click me", "disableIf": "False()", "action": "OpenUrl(\"www.google.com\")" }, "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": "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" }

请求参数

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

columnIdOrName

string

必需

ID or name of the column. 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.

示例值:

c-tuVwxYz

返回响应

🟢200Info about a column.

application/json

Body

Info about a column.

format

ColumnFormat

必需

Format of a column.

Format of a button column.

type

enum<string>

ColumnFormatType

必需

Format type of the column

枚举值:

textpersonlookupnumberpercentcurrencydatedateTimetimedurationemaillinksliderscaleimageimageReferenceattachmentsbuttoncheckboxselectpackObjectreactioncanvasother

isArray

boolean

必需

Whether or not this column is an array.

示例值:

true

label

string

可选

Label formula for the button.

示例值:

Click me

disableIf

string

可选

DisableIf formula for the button.

示例值:

False()

action

string

可选

Action formula for the button.

示例值:

OpenUrl("www.google.com")

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 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

🟠401401

🟠403403

🟠404404

🟠429429