Skip to main content
Retable logo
  • Category: spreadsheets
  • Auth: API_KEY
  • Composio-managed OAuth available? N/A
  • Tools: 11
  • Triggers: 0
  • Slug: RETABLE
  • Version: 20261101_00

Tools

Slug: RETABLE_ADD_COLUMNSAppend one or more typed columns to a table and return the complete resulting column list.

Input Parameters

array
required
Columns to append in one batch.
string
required
Table ID that will receive the new columns.

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: RETABLE_DELETE_COLUMNSPermanently delete one or more columns and their cell data, then return the complete remaining column list.

Input Parameters

string
required
Table ID containing the columns to delete.
array
required
Column IDs to permanently delete in one batch; deleting a column also removes its cell data.

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: RETABLE_DELETE_ROWSPermanently delete one or more rows from a table; missing row IDs are ignored and count as zero deletions.

Input Parameters

array
required
Row IDs to permanently delete in one batch.
string
required
Table ID containing the rows to delete.

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: RETABLE_GET_ROWSRetrieve all rows or up to 50 selected rows from a Retable. Choose a representation using stable column IDs or fields keyed by column titles.

Input Parameters

string ("column_ids" | "column_titles")
Row shape: column_ids returns stable column objects; column_titles returns a fields object keyed by mutable column titles.
array
Optional non-empty list of row IDs to select, up to 50. Omit to return every row because this endpoint has no pagination.
string
required
Table ID whose rows to return.

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: RETABLE_GET_TABLEGet one table’s metadata, column IDs and types, and views before reading or changing its data.

Input Parameters

string
required
Table ID returned by LIST_PROJECT_TABLES.

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: RETABLE_INSERT_ROWSInsert one or more rows into a table in one request and return the created rows with their IDs.

Input Parameters

array
required
Rows to insert in one batch.
string
required
Table ID that will receive the new 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: RETABLE_LIST_PROJECT_TABLESList tables in one Retable project with their IDs, columns, and parent workspace and project IDs.

Input Parameters

string
required
Project ID returned by List Workspace Projects.

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: RETABLE_LIST_WORKSPACE_PROJECTSList projects accessible in one workspace, including project IDs needed to discover tables.

Input Parameters

string
required
Workspace ID returned by LIST_WORKSPACES.

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: RETABLE_LIST_WORKSPACESList workspaces visible to the connected Retable account, including each workspace ID needed to discover projects.

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: RETABLE_SEARCH_ROWSSearch a table for a value in a primary column and return matching rows from an optional starting offset. For text columns, Retable matches the full cell value rather than partial text.

Input Parameters

string
required
Value to match in the primary column. Text-column searches require the full cell value; partial text does not match.
integer
Number of matching rows to skip before returning all remaining matches.
string
required
Table ID to search.
string
required
Primary column ID to search, available from GET_TABLE.

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: RETABLE_UPDATE_ROWSUpdate cells in one or more existing rows in one request and return the updated row IDs.

Input Parameters

array
required
Existing rows and cell changes to apply in one batch.
string
required
Table ID containing the rows to update.

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