> ## Documentation Index
> Fetch the complete documentation index at: https://composio-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Retable

> Retable is a collaborative spreadsheet and database platform for organizing workspaces, projects, tables, columns, rows, and files.

![Retable logo](https://mintcdn.com/composio-preview/YYC5iurbUCUzEs77/images/toolkits/retable.svg?fit=max\&auto=format\&n=YYC5iurbUCUzEs77\&q=85\&s=100c5a58a513279372572c698b98a3ee)

* **Category:** spreadsheets
* **Auth:** API\_KEY
* **Composio-managed OAuth available?** N/A
* **Tools:** 11
* **Triggers:** 0
* **Slug:** `RETABLE`
* **Version:** 20261101\_00

## Tools

> [accordion] Add Columns
>
> **Slug:** `RETABLE_ADD_COLUMNS`
>
> Append one or more typed columns to a table and return the complete resulting column list.
>
> #### Input Parameters
>
> **columns** `array` *required*
>
> Columns to append in one batch.
>
> **table\_id** `string` *required*
>
> Table ID that will receive the new columns.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Delete Columns
>
> **Slug:** `RETABLE_DELETE_COLUMNS`
>
> Permanently delete one or more columns and their cell data, then return the complete remaining column list.
>
> #### Input Parameters
>
> **table\_id** `string` *required*
>
> Table ID containing the columns to delete.
>
> **column\_ids** `array` *required*
>
> Column IDs to permanently delete in one batch; deleting a column also removes its cell data.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Delete Rows
>
> **Slug:** `RETABLE_DELETE_ROWS`
>
> Permanently delete one or more rows from a table; missing row IDs are ignored and count as zero deletions.
>
> #### Input Parameters
>
> **row\_ids** `array` *required*
>
> Row IDs to permanently delete in one batch.
>
> **table\_id** `string` *required*
>
> Table ID containing the rows to delete.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Rows
>
> **Slug:** `RETABLE_GET_ROWS`
>
> Retrieve 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
>
> **format** `string ("column_ids" | "column_titles")`
>
> Row shape: column\_ids returns stable column objects; column\_titles returns a fields object keyed by mutable column titles.
>
> **row\_ids** `array`
>
> Optional non-empty list of row IDs to select, up to 50. Omit to return every row because this endpoint has no pagination.
>
> **table\_id** `string` *required*
>
> Table ID whose rows to return.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Get Table
>
> **Slug:** `RETABLE_GET_TABLE`
>
> Get one table's metadata, column IDs and types, and views before reading or changing its data.
>
> #### Input Parameters
>
> **table\_id** `string` *required*
>
> Table ID returned by LIST\_PROJECT\_TABLES.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Insert Rows
>
> **Slug:** `RETABLE_INSERT_ROWS`
>
> Insert one or more rows into a table in one request and return the created rows with their IDs.
>
> #### Input Parameters
>
> **rows** `array` *required*
>
> Rows to insert in one batch.
>
> **table\_id** `string` *required*
>
> Table ID that will receive the new rows.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] List Project Tables
>
> **Slug:** `RETABLE_LIST_PROJECT_TABLES`
>
> List tables in one Retable project with their IDs, columns, and parent workspace and project IDs.
>
> #### Input Parameters
>
> **project\_id** `string` *required*
>
> Project ID returned by List Workspace Projects.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] List Workspace Projects
>
> **Slug:** `RETABLE_LIST_WORKSPACE_PROJECTS`
>
> List projects accessible in one workspace, including project IDs needed to discover tables.
>
> #### Input Parameters
>
> **workspace\_id** `string` *required*
>
> Workspace ID returned by LIST\_WORKSPACES.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] List Workspaces
>
> **Slug:** `RETABLE_LIST_WORKSPACES`
>
> List workspaces visible to the connected Retable account, including each workspace ID needed to discover projects.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Search Rows
>
> **Slug:** `RETABLE_SEARCH_ROWS`
>
> Search 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
>
> **term** `string` *required*
>
> Value to match in the primary column. Text-column searches require the full cell value; partial text does not match.
>
> **offset** `integer`
>
> Number of matching rows to skip before returning all remaining matches.
>
> **table\_id** `string` *required*
>
> Table ID to search.
>
> **column\_id** `string` *required*
>
> Primary column ID to search, available from GET\_TABLE.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not

> [accordion] Update Rows
>
> **Slug:** `RETABLE_UPDATE_ROWS`
>
> Update cells in one or more existing rows in one request and return the updated row IDs.
>
> #### Input Parameters
>
> **rows** `array` *required*
>
> Existing rows and cell changes to apply in one batch.
>
> **table\_id** `string` *required*
>
> Table ID containing the rows to update.
>
> #### Output
>
> **data** `string` *required*
>
> Data from the action execution
>
> **error** `string`
>
> Error if any occurred during the execution of the action
>
> **successful** `boolean` *required*
>
> Whether or not the action execution was successful or not
