Get a table

开发环境

http://dev-cn.your-api-server.com

GET

/docs/{docId}/tables/{tableIdOrName}

Returns details about a specific table or view.

请求示例

Shell

JavaScript

Java

Swift

curl -s -H 'Authorization: Bearer <your API token>' \
  'https://coda.io/apis/v1/docs/<doc ID>/tables/<table ID>' |
  jq '"Table " + .name + " has " + (.rowCount | tostring) + " rows"'
# => "Table To-do List has 2 rows"

响应示例

200 - 示例 1

{
    "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"
    },
    "parentTable": {
        "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"
    },
    "displayColumn": {
        "id": "c-tuVwxYz",
        "href": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns/c-tuVwxYz",
        "type": "column"
    },
    "layout": "default",
    "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",
    "rowCount": 130,
    "sorts": [
        {
            "column": {
                "id": "c-tuVwxYz",
                "href": "https://coda.io/apis/v1/docs/AbCDeFGH/tables/grid-pqRst-U/columns/c-tuVwxYz",
                "type": "column"
            },
            "direction": "ascending"
        }
    ],
    "createdAt": "2018-04-11T00:18:57.946Z",
    "updatedAt": "2018-04-11T00:18:57.946Z",
    "type": "table",
    "filter": {
        "valid": true,
        "isVolatile": false,
        "hasUserFormula": false,
        "hasTodayFormula": false,
        "hasNowFormula": false
    }
}

请求参数

Path 参数

Query 参数

返回响应

🟢200Info about a table.

application/json

Body

🟠401401

🟠403403

🟠404404

🟠429429

修改于 2024-03-20 08:13:15

List tables

List columns