Skip to main content
SeaTable logo
  • Category: databases
  • Auth: API_KEY
  • Composio-managed OAuth available? N/A
  • Tools: 8
  • Triggers: 0
  • Slug: SEATABLE
  • Version: 20261101_00

Tools

Slug: SEATABLE_APPEND_ROWSAppend one or more rows to a table in the connected SeaTable base using exact human-readable column names. Requires a read-write per-base API token.

Input Parameters

array
required
One or more row objects keyed by exact human-readable column names. Every name is validated against the table schema before insertion.
string
required
Exact destination table name. Use Get Base Schema to discover it.
boolean
Whether to apply configured column defaults to omitted fields.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SEATABLE_DELETE_ROWSPermanently delete one or more rows by row ID from a named table in the connected SeaTable base.

Input Parameters

array
required
One or more SeaTable row _id values to permanently delete.
string
required
Exact table name containing the rows.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SEATABLE_GET_BASE_SCHEMAReturn the connected base identity and table metadata, including columns and views, without returning authentication tokens.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SEATABLE_GET_ROWGet one row by its SeaTable _id from a named table in the connected base. Returns human-readable column names by default and preserves all dynamic row fields.

Input Parameters

string
required
SeaTable row identifier from the row’s _id field.
string
required
Exact name of the table containing the row.
boolean
Return human-readable column names instead of internal column keys.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SEATABLE_LIST_ROWSList one page of rows from a table or view in the connected SeaTable base, returning human-readable column names by default.

Input Parameters

integer
Maximum number of rows to return in this page (1-1000).
integer
Zero-based row offset for this page.
string
Optional exact view name. When set, return the rows visible in that view.
string
required
Exact table name from Get Base Schema.
boolean
Return human-readable column names instead of internal column keys.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SEATABLE_QUERY_ROWS_WITH_SQLRun one strictly read-only SELECT query against the connected SeaTable base for filtering, sorting, grouping, aggregation, or implicit linked-record traversal. Explicit JOIN, subqueries, and UNION are unsupported.

Input Parameters

string
required
A single read-only SELECT statement. Quote table names containing spaces with backticks, use ? placeholders for values, and include LIMIT (maximum documented SELECT result is 10000).
array
String or integer values replacing ? placeholders in order. Use these instead of interpolating untrusted values into SQL.
boolean
Query only normal server storage and exclude Big Data storage.
boolean
Return human-readable column names instead of internal column keys.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: SEATABLE_UPDATE_ROWSUpdate one or more existing SeaTable rows by row ID. Use exact table and column names from Get Base Schema; every column name is validated before the update, and only supplied columns are changed.

Input Parameters

array
required
One or more row updates. Each entry identifies a row and its changed columns.
string
required
Exact table name containing the rows.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not