Automation Data Table Rows
Query, write, batch, import and export the rows of a data table, and upsert them by external ID.
Query rows
Query rows. Filters are ANDed; each is `column:OPERATOR:value` with OPERATOR one of EQ, NEQ, IN, CONTAINS, STARTS_WITH, GT, GTE, LT, LTE, BETWEEN. IN and BETWEEN take comma-separated values. `id` and `externalId` may be filtered and sorted like any column. The `where` parameter is reserved for a future expression filter and must not be sent.
Insert a row
Insert one row.
Delete rows
Delete rows by id. `ids` is required; to empty a table use the clear operation.
Get a row
Update a row
Merge values into a row. Omitted columns are untouched; a null value clears a column. `externalId` may be set or cleared.
Delete a row
Get a row by external id
Delete a row by external id
Upsert a row by external id
Upsert: insert the row under this external id, or merge the values into the row that already carries it. Idempotent.
Batch insert or upsert rows
Insert or upsert up to 1000 rows in one transaction; one failure rolls back all of them. Under UPSERT every row must carry an externalId.
Clear a table
Delete every row. Irreversible.
Import rows from CSV
Insert rows from CSV. The header names existing columns; an optional `external_id` column sets each row's external id. Empty fields are null.
Export rows as CSV
Export every row as CSV. `external_id` is the first column; `id` is not included.
How is this guide?