Retable
App · 14 actions
Work with your Retable tables: list workspaces, projects and tables, add and remove columns, and list, search, insert, update and delete rows.
Actions
| Action | What it does |
|---|---|
| Add column | Add a column to the end of a table. |
| Delete column | Delete a column, and every cell in it, from a table. |
| Delete rows | Delete rows by their row numbers, up to 50 at a time, such as 1, 2, 3. |
| Get project | Get one project with its tables. |
| Get row | Get one row of a table by its row number. |
| Get table | Get one table with its columns and their ids and types. |
| Get workspace | Get one workspace with its projects. |
| Insert row | Add a row to a table, giving a value for each column by its title. |
| List projects | List the projects in a workspace. |
| List rows | List every row of a table. |
| List tables | List the tables in a project, with their columns. |
| List workspaces | List the workspaces the API key's user belongs to. |
| Search rows | Find the rows of a table whose chosen column holds exactly this text. |
| Update row | Change cells of one row, by column title. |
Add column
Add a column to the end of a table.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Title
titletextRequired - The column's title.
- Type
column_typetext - What the column holds. Defaults to text.One of:
text(Text (default)),number,checkbox,calendar(Date),email,phonenumber(Phone number),percent,color,image.
Outputs
columnobject- A column of a table.
columnslist- Every column of the table
Example output
{
"column": {
"column_id": "Wlks9I8iZy1wj2KV",
"created_at": "2026-10-01 09:00:00.000000",
"title": "Name",
"type": "text"
},
"columns": [
{
"column_id": "Wlks9I8iZy1wj2KV",
"created_at": "2026-10-01 09:00:00.000000",
"title": "Name",
"type": "text"
}
]
}Delete column
Delete a column, and every cell in it, from a table.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Column
column_idtextRequired - The column. Pick one from the table, or give its title or id.
Outputs
column_idtext- The column deleted
columnslist- The columns left in the table
deletedtrue/false- Always true once deleted
Example output
{
"column_id": "Wlks9I8iZy1wj2KV",
"columns": [],
"deleted": true
}Delete rows
Delete rows by their row numbers, up to 50 at a time, such as 1, 2, 3. A number with no row is skipped. Needs the owner role on the table.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Row numbers
row_idstextRequired - The rows to delete: a list of numbers, or numbers separated by commas.
Outputs
deleted_row_countnumber- How many rows Retable deleted
row_idslist- The numbers asked for
Example output
{
"deleted_row_count": 1,
"row_ids": [
1
]
}Get project
Get one project with its tables.
Inputs
- Project
project_idtextRequired - The project. Pick one, or give its id from an earlier step.
Outputs
projectobject- A project: a folder of tables in a workspace.
tableslist- Its tables
Example output
{
"project": {
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "prj_01HX",
"is_deleted": false,
"name": "Customers",
"updated_at": null
},
"tables": [
{
"columns": [
{
"column_id": "Wlks9I8iZy1wj2KV",
"created_at": "2026-10-01 09:00:00.000000",
"title": "Name",
"type": "text"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "tbl_01HX",
"title": "Retable 1",
"updated_at": null
}
]
}Get row
Get one row of a table by its row number.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Row number
row_idnumberRequired - The row's number, from 'List rows', 'Search rows' or 'Insert row'.At least 1.
Outputs
rowobject- A row of a table.
Example output
{
"row": {
"columns": [
{
"cell_value": "Acme",
"column_id": "Wlks9I8iZy1wj2KV",
"title": "Name"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"row_id": 1,
"updated_at": null,
"updated_by": null,
"values": {
"Name": "Acme"
}
}
}Get table
Get one table with its columns and their ids and types.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Outputs
tableobject- A table, which Retable calls a retable.
Example output
{
"table": {
"columns": [
{
"column_id": "Wlks9I8iZy1wj2KV",
"created_at": "2026-10-01 09:00:00.000000",
"title": "Name",
"type": "text"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "tbl_01HX",
"title": "Retable 1",
"updated_at": null
}
}Get workspace
Get one workspace with its projects.
Inputs
- Workspace
workspace_idtextRequired - The workspace. Pick one, or give its id from an earlier step.
Outputs
projectslist- Its projects
workspaceobject- A workspace.
Example output
{
"projects": [
{
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "prj_01HX",
"is_deleted": false,
"name": "Customers",
"updated_at": null
}
],
"workspace": {
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "wrk_01HX",
"name": "Acme",
"updated_at": null,
"updated_by": null
}
}Insert row
Add a row to a table, giving a value for each column by its title. Needs the owner or editor role on the table.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Cells
valuesobjectRequired - A value for each column to fill in. Columns left out stay empty.
Outputs
rowobject- A row of a table.
Example output
{
"row": {
"columns": [
{
"cell_value": "Acme",
"column_id": "Wlks9I8iZy1wj2KV",
"title": "Name"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"row_id": 1,
"updated_at": null,
"updated_by": null,
"values": {
"Name": "Acme"
}
}
}List projects
List the projects in a workspace.
Inputs
- Workspace
workspace_idtextRequired - The workspace. Pick one, or give its id from an earlier step.
Outputs
countnumber- How many
projectslist- The projects
Example output
{
"count": 1,
"projects": [
{
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "prj_01HX",
"is_deleted": false,
"name": "Customers",
"updated_at": null
}
]
}List rows
List every row of a table. Each row's cells are under 'values', keyed by column title.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Outputs
countnumber- How many
rowslist- The rows
Example output
{
"count": 1,
"rows": [
{
"columns": [
{
"cell_value": "Acme",
"column_id": "Wlks9I8iZy1wj2KV",
"title": "Name"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"row_id": 1,
"updated_at": null,
"updated_by": null,
"values": {
"Name": "Acme"
}
}
]
}List tables
List the tables in a project, with their columns.
Inputs
- Project
project_idtextRequired - The project. Pick one, or give its id from an earlier step.
Outputs
countnumber- How many
tableslist- The tables
Example output
{
"count": 1,
"tables": [
{
"columns": [
{
"column_id": "Wlks9I8iZy1wj2KV",
"created_at": "2026-10-01 09:00:00.000000",
"title": "Name",
"type": "text"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "tbl_01HX",
"title": "Retable 1",
"updated_at": null
}
]
}List workspaces
List the workspaces the API key's user belongs to.
Inputs
None.
Outputs
countnumber- How many
workspaceslist- The workspaces
Example output
{
"count": 1,
"workspaces": [
{
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"description": "",
"id": "wrk_01HX",
"name": "Acme",
"updated_at": null,
"updated_by": null
}
]
}Search rows
Find the rows of a table whose chosen column holds exactly this text. Retable matches the whole cell, not part of it.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Column
column_idtextRequired - The column. Pick one from the table, or give its title or id.
- Search for
termtextRequired - The text to look for, in full: Retable matches a cell's whole value, not part of it.
- Page size
limitnumber - How many rows to return, 1 to 100.From 1 to 100.
- Skip
offsetnumber - How many matching rows to skip, to get a later page.At least 0.
Outputs
countnumber- How many
rowslist- The rows
Example output
{
"count": 1,
"rows": [
{
"columns": [
{
"cell_value": "Acme",
"column_id": "Wlks9I8iZy1wj2KV",
"title": "Name"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"row_id": 1,
"updated_at": null,
"updated_by": null,
"values": {
"Name": "Acme"
}
}
]
}Update row
Change cells of one row, by column title. Only the columns given change. Needs the owner or editor role on the table.
Inputs
- Table
table_idtextRequired - The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Row number
row_idnumberRequired - The row's number, from 'List rows', 'Search rows' or 'Insert row'.At least 1.
- Cells
valuesobjectRequired - The new value for each column to change. Columns left out keep their current value.
Outputs
rowobject- A row of a table.
Example output
{
"row": {
"columns": [
{
"cell_value": "Acme",
"column_id": "Wlks9I8iZy1wj2KV",
"title": "Name"
}
],
"created_at": "2026-10-01 09:00:00",
"created_by": {
"email": "jo@example.com",
"id": "usr_01HX",
"name": "Jo",
"surname": "Bloggs"
},
"row_id": 1,
"updated_at": null,
"updated_by": null,
"values": {
"Name": "Acme Ltd"
}
}
}