# Baserow

> Create, read, update, and delete rows in your Baserow tables.

App · Databases · 5 actions. Web page: https://docs.lodol.com/docs/integrations/baserow

## Actions

### Create a row

Add a new row to a Baserow table.

**Inputs**

- Table ID (`table_id`, text, required): The ID of your Baserow table. Open the table in Baserow and copy the number that appears right after `/table/` in the page's web address.
- Column values (`fields`, object, required): The values for the new row, given as column-name and value pairs (for example, Name: 'Acme Inc.', Status: 'Active').
- Use column names (`user_field_names`, true/false): Leave on to use your table's column names (like 'Name' or 'Status'). Turn off to use Baserow's internal field codes (like 'field_123') instead. Default: `true`.

**Outputs**

- `id` (number): The ID of the newly created row (use it as the Row ID in other actions).

**Example output**

```json
{
  "Name": "Acme Inc.",
  "Status": "Active",
  "id": 1,
  "order": "1.00"
}
```

### Delete a row

Permanently remove a row from a Baserow table.

**Inputs**

- Table ID (`table_id`, text, required): The ID of your Baserow table. Open the table in Baserow and copy the number that appears right after `/table/` in the page's web address.
- Row ID (`row_id`, number, required): The ID of the row to delete. You can find it with the List rows action.

**Outputs**

- `deleted` (true/false): Whether the row was deleted.

**Example output**

```json
{
  "deleted": true
}
```

### Get a row

Get a single row from a Baserow table by its row ID.

**Inputs**

- Table ID (`table_id`, text, required): The ID of your Baserow table. Open the table in Baserow and copy the number that appears right after `/table/` in the page's web address.
- Row ID (`row_id`, number, required): The ID of the row to get. You can find it with the List rows action or from a Create row result.
- Use column names (`user_field_names`, true/false): Leave on to use your table's column names (like 'Name' or 'Status'). Turn off to use Baserow's internal field codes (like 'field_123') instead. Default: `true`.

**Outputs**

- `id` (number): The row's ID.

**Example output**

```json
{
  "Name": "Acme Inc.",
  "Status": "Active",
  "id": 1,
  "order": "1.00"
}
```

### List rows

Get the rows from one of your Baserow tables.

**Inputs**

- Table ID (`table_id`, text, required): The ID of your Baserow table. Open the table in Baserow and copy the number that appears right after `/table/` in the page's web address.
- Maximum rows (`limit`, number): The most rows to return, up to 200. Leave blank to return the first page of rows.
- Use column names (`user_field_names`, true/false): Leave on to use your table's column names (like 'Name' or 'Status'). Turn off to use Baserow's internal field codes (like 'field_123') instead. Default: `true`.

**Outputs**

- `count` (number): Total number of rows in the table.
- `results` (list): The rows on this page. Each row includes its 'id' and its column values.

**Example output**

```json
{
  "count": 1,
  "next": null,
  "previous": null,
  "results": [
    {
      "Name": "Acme Inc.",
      "Status": "Active",
      "id": 1,
      "order": "1.00"
    }
  ]
}
```

### Update a row

Change the values of an existing row in a Baserow table.

**Inputs**

- Table ID (`table_id`, text, required): The ID of your Baserow table. Open the table in Baserow and copy the number that appears right after `/table/` in the page's web address.
- Row ID (`row_id`, number, required): The ID of the row to update. You can find it with the List rows action or from a Create row result.
- Column values (`fields`, object, required): The columns to change and their new values, given as column-name and value pairs (for example, Status: 'Closed'). Columns you leave out keep their current values.
- Use column names (`user_field_names`, true/false): Leave on to use your table's column names (like 'Name' or 'Status'). Turn off to use Baserow's internal field codes (like 'field_123') instead. Default: `true`.

**Outputs**

- `id` (number): The row's ID.

**Example output**

```json
{
  "Name": "Acme Inc.",
  "Status": "Closed",
  "id": 1,
  "order": "1.00"
}
```