ChatGPT ↗
Claude ↗This page documents the canonical HTTP contract. Switch to the CLI example when you want the operator workflow.
The successful response contains updated and eventReprocess; empty updates return only updated: 0. Writes are synchronous. The route rejects over 500 updates or 100 distinct rows with 413, requires every referenced row to belong to this table, and blocks semantic, calculated, or source-managed columns. A conflicting mutation returns 409.
Path parameters
table_idrequiredstring
Target table ID.
| Name | Type | Description |
|---|---|---|
| table_idrequired | string | Target table ID. |
Query parameters
detect_types· optionalboolean
When true, infer data types for newly created columns; default false.
| Name | Type | Description |
|---|---|---|
| detect_types | boolean | When true, infer data types for newly created columns; default false. |
Body parameters
updatesrequiredarray
Required list of cell writes. Each item includes rowId, key, and optional value. Maximum 500 updates and 100 distinct rows.
updates[].rowIdrequiredstring
Row ID.
updates[].keyrequiredstring
Column key. Missing keys create new manual/API columns.
updates[].value· optionalany|null
Arbitrary JSON cell value; null or blank string clears the corresponding source value.
| Name | Type | Description |
|---|---|---|
| updatesrequired | array | Required list of cell writes. Each item includes rowId, key, and optional value. Maximum 500 updates and 100 distinct rows. |
| updates[].rowIdrequired | string | Row ID. |
| updates[].keyrequired | string | Column key. Missing keys create new manual/API columns. |
| updates[].value | any|null | Arbitrary JSON cell value; null or blank string clears the corresponding source value. |
Errors
| Status | Meaning |
|---|---|
| 400 | Invalid payload or protected column. |
| 401 | Invalid API key or missing auth. |
| 403 | Access denied or missing tables:write scope. |
| 404 | One or more rows not found in this table. |
| 409 | Table is inactive or another row mutation is already active. |
| 413 | More than 500 updates or 100 distinct rows. |