Append rows to a table
Append one or more rows to a table. Append-only: existing rows are never modified or deleted. Each row is an object of column name to scalar value, validated and type-coerced against the table’s schema. Every row in a batch must carry the same column names.
The target must be a promoted (ACTIVE) Summation data table — one backed by a physical row store. Draft or unpromoted tables, calculation tables, and imported tables (e.g. file/CSV imports) have no row store and are rejected with 409; a table appearing with a SUMMATION source in the table list is not sufficient on its own.
Each row must include a value for the table’s primary key column(s) — primary keys are caller-supplied, not auto-generated. A row missing its primary key is rejected with 400.
Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. Requires the tables:append scope.
Authorizations
The access token received from the authorization server in the OAuth 2.0 flow.
Path Parameters
Body
Rows to append, 1 to 500 per request. Each row is an object of column_name to scalar value; values are coerced to their column type by the table's schema. Every row must carry the same column names, and each must include the table's primary key column(s) — primary keys are caller-supplied, not auto-generated. Append-only — existing rows are never modified.
1 - 500 elementsResponse
Successful Response