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. Provide column values matching the table’s schema.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
Additional properties are passed as column values.
update_datatable_row
Partial update of a row. Only include the columns you want to change.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
rowId |
string | Yes | The row ID |
Additional properties are passed as column values to update.
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 with column values |
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
export_datatable_rows
Export all rows as CSV.
| Parameter | Type | Required | Description |
|---|---|---|---|
tableId |
string | Yes | The data table ID |
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.