Data Tables
Tools for managing data tables — structured row/column data that can be used in templates and playlists. Includes row CRUD operations, batch operations, CSV export, and row version history with rollback.
Table Management
list_datatables
List data tables in the account. Supports cursor-based pagination.
| Parameter | Type | Required | Description |
|---|---|---|---|
groupId |
string | No | Filter by group ID |
pageSize |
number | No | Results per page (default: 50) |
continuationToken |
string | No | Continuation token for pagination |
get_datatable
Get a data table definition by ID. Returns the table’s name, column schema, and metadata.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
create_datatable
Create a new data table. Define the table name and column schema.
| Parameter | Type | Required | Description |
|---|---|---|---|
name |
string | Yes | Name for the new data table |
Additional properties can be passed to define the column schema.
update_datatable
Update a data table definition — rename or modify column schema.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
Additional properties can be passed for the fields to update.
delete_datatable
Permanently delete a data table and all its rows. This action cannot be undone.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
Row Operations
list_datatable_rows
List rows in a data table. Supports filtering, sorting, field selection, and cursor-based pagination.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
filter |
string | No | Filter expression |
sort |
string | No | Column name to sort by |
sortDir |
string | No | Sort direction: asc or desc (default: asc) |
pageSize |
number | No | Results per page (default: 50) |
continuationToken |
string | No | Continuation token for pagination |
fields |
string | No | Comma-separated column names to include |
get_datatable_row
Get a single row by ID. Returns all column values.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
create_datatable_row
Create a new row. Put the column values in the data object, keyed by column key (the stable machine key, not the display name). Omit data (or pass {}) for an empty row.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
data |
object | No | Column values keyed by column key, e.g. {"title":"Hello","link":"https://example.com"}. Values are raw JSON scalars/objects |
update_datatable_row
Partial update of a row. Put the columns you want to change in data, keyed by column key — only those keys are modified; omitted columns are left intact.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
data |
object | Yes | Column values to change, keyed by column key |
eTag |
string | No | Optimistic-concurrency token from a prior read. Sent as the If-Match request header. Omit for last-write-wins; a stale token is rejected with a 409 conflict |
delete_datatable_row
Delete a single row. This action cannot be undone.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
Batch Operations
batch_create_datatable_rows
Create multiple rows in a single request. More efficient than creating rows one at a time.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rows |
array | Yes | Array of row objects, each a map of column values keyed by column key, e.g. [{"title":"A"},{"title":"B"}] |
batch_delete_datatable_rows
Delete multiple rows in a single request. Maximum 100 row IDs per call.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowIds |
string[] | Yes | Array of row IDs to delete (max 100) |
reorder_datatable_rows
Reorder rows in a data table. Provide the row IDs in the desired order.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
Additional properties specify the new row order.
Export & Import
export_datatable_rows
Export all rows as CSV.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
import_datatable_rows
Import rows from CSV content. GraphQL-backed — REST’s batch tools take row objects, not CSV. With replace: true, all existing rows are overwritten; with replace: false, rows are appended.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
csvContent |
string | Yes | CSV content; the header row must match the table’s column keys |
replace |
boolean | Yes | true replaces all rows (destructive); false appends |
Version History
list_datatable_row_versions
List version history for a row (newest first). Each version captures the row’s state at a point in time.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
pageSize |
number | No | Results per page (default: 25) |
continuationToken |
string | No | Continuation token for pagination |
get_datatable_row_version
Get a specific version snapshot of a row.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
version |
number | Yes | The version number |
rollback_datatable_row
Roll back a row to a specific previous version. The row’s current state will be replaced with the values from the specified version.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
Additional properties specify the target version.