# Retable

> Work with your Retable tables: list workspaces, projects and tables, add and remove columns, and list, search, insert, update and delete rows.

App · 14 actions. Web page: https://docs.lodol.com/docs/integrations/retable

## Actions

### Add column

Add a column to the end of a table.

**Inputs**

- Table (`table_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Title (`title`, text, required): The column's title.
- Type (`column_type`, text): What the column holds. Defaults to text. One of: `text` (Text (default)), `number`, `checkbox`, `calendar` (Date), `email`, `phonenumber` (Phone number), `percent`, `color`, `image`.

**Outputs**

- `column` (object): A column of a table.
- `columns` (list): Every column of the table

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Column (`column_id`, text, required): The column. Pick one from the table, or give its title or id.

**Outputs**

- `column_id` (text): The column deleted
- `columns` (list): The columns left in the table
- `deleted` (true/false): Always true once deleted

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Row numbers (`row_ids`, text, required): The rows to delete: a list of numbers, or numbers separated by commas.

**Outputs**

- `deleted_row_count` (number): How many rows Retable deleted
- `row_ids` (list): The numbers asked for

**Example output**

```json
{
  "deleted_row_count": 1,
  "row_ids": [
    1
  ]
}
```

### Get project

Get one project with its tables.

**Inputs**

- Project (`project_id`, text, required): The project. Pick one, or give its id from an earlier step.

**Outputs**

- `project` (object): A project: a folder of tables in a workspace.
- `tables` (list): Its tables

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Row number (`row_id`, number, required): The row's number, from 'List rows', 'Search rows' or 'Insert row'. At least 1.

**Outputs**

- `row` (object): A row of a table.

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.

**Outputs**

- `table` (object): A table, which Retable calls a retable.

**Example output**

```json
{
  "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_id`, text, required): The workspace. Pick one, or give its id from an earlier step.

**Outputs**

- `projects` (list): Its projects
- `workspace` (object): A workspace.

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Cells (`values`, object, required): A value for each column to fill in. Columns left out stay empty.

**Outputs**

- `row` (object): A row of a table.

**Example output**

```json
{
  "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_id`, text, required): The workspace. Pick one, or give its id from an earlier step.

**Outputs**

- `count` (number): How many
- `projects` (list): The projects

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.

**Outputs**

- `count` (number): How many
- `rows` (list): The rows

**Example output**

```json
{
  "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_id`, text, required): The project. Pick one, or give its id from an earlier step.

**Outputs**

- `count` (number): How many
- `tables` (list): The tables

**Example output**

```json
{
  "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**

- `count` (number): How many
- `workspaces` (list): The workspaces

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Column (`column_id`, text, required): The column. Pick one from the table, or give its title or id.
- Search for (`term`, text, required): The text to look for, in full: Retable matches a cell's whole value, not part of it.
- Page size (`limit`, number): How many rows to return, 1 to 100. From 1 to 100.
- Skip (`offset`, number): How many matching rows to skip, to get a later page. At least 0.

**Outputs**

- `count` (number): How many
- `rows` (list): The rows

**Example output**

```json
{
  "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_id`, text, required): The table. Pick one, give its id from an earlier step, or paste its web address from Retable.
- Row number (`row_id`, number, required): The row's number, from 'List rows', 'Search rows' or 'Insert row'. At least 1.
- Cells (`values`, object, required): The new value for each column to change. Columns left out keep their current value.

**Outputs**

- `row` (object): A row of a table.

**Example output**

```json
{
  "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"
    }
  }
}
```
