Insert/upsert rows

开发环境

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

POST

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

Inserts rows into a table, optionally updating existing rows if any upsert key columns are provided. This endpoint will always return a 202, so long as the doc and table exist and are accessible (and the update is structurally valid). Row inserts/upserts are generally processed within several seconds. Note: this endpoint only works for base tables, not views.
When upserting, if multiple rows match the specified key column(s), they will all be updated with the specified value.

请求示例

Shell

JavaScript

Java

Swift

curl -s -H 'Authorization: Bearer <your API token>' -X POST -H "Content-Type: application/json" \
  -d '{"rows": [{"cells": [{"column": "<column ID>", "value": "Feed Baker"}]}]}' \
  'https://coda.io/apis/v1/docs/<doc ID>/tables/<table ID>/rows' |
  jq 'if .statusMessage? == null then "Inserted 1 row" else . end'
# => "Inserted 1 row"

响应示例

202 - 示例 1

{
    "requestId": "abc-123-def-456",
    "addedRowIds": [
        "i-bCdeFgh",
        "i-CdEfgHi"
    ]
}

请求参数

Path 参数

Query 参数

Body 参数application/json

示例

返回响应

🟢202A result indicating that the upsert was queued for processing.

application/json

Body

🟠400400

🟠401401

🟠403403

🟠404404

🟠429429

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

List table rows

Delete multiple rows