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

ActionWhat it does
Add columnAdd a column to the end of a table.
Delete columnDelete a column, and every cell in it, from a table.
Delete rowsDelete rows by their row numbers, up to 50 at a time, such as 1, 2, 3.
Get projectGet one project with its tables.
Get rowGet one row of a table by its row number.
Get tableGet one table with its columns and their ids and types.
Get workspaceGet one workspace with its projects.
Insert rowAdd a row to a table, giving a value for each column by its title.
List projectsList the projects in a workspace.
List rowsList every row of a table.
List tablesList the tables in a project, with their columns.
List workspacesList the workspaces the API key's user belongs to.
Search rowsFind the rows of a table whose chosen column holds exactly this text.
Update rowChange cells of one row, by column title.

Add column

Add a column to the end of a table.

Inputs

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
TitletitletextRequired
The column's title.
Typecolumn_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

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Columncolumn_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

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Row numbersrow_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

Projectproject_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

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Row numberrow_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

Tabletable_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

Workspaceworkspace_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

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
CellsvaluesobjectRequired
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

Workspaceworkspace_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

Tabletable_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

Projectproject_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

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Columncolumn_idtextRequired
The column. Pick one from the table, or give its title or id.
Search fortermtextRequired
The text to look for, in full: Retable matches a cell's whole value, not part of it.
Page sizelimitnumber
How many rows to return, 1 to 100.From 1 to 100.
Skipoffsetnumber
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

Tabletable_idtextRequired
The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
Row numberrow_idnumberRequired
The row's number, from 'List rows', 'Search rows' or 'Insert row'.At least 1.
CellsvaluesobjectRequired
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"
    }
  }
}

On this page