# Supabase

> List, insert, update, and delete rows in your Supabase tables.

App · Databases · 4 actions. Web page: https://docs.lodol.com/docs/integrations/supabase

## Actions

### Delete rows from a table

Delete rows in a Supabase table that match your conditions.

**Inputs**

- Table name (`table`, text, required): The name of the table to delete rows from.
- Match conditions (`match`, object, required): Only delete rows where these columns exactly equal these values, given as column-and-value pairs (for example, {"id": 42}).

**Outputs**

- `rows` (list): The rows that were deleted.

**Example output**

```json
{
  "rows": [
    {
      "id": 4
    }
  ]
}
```

### Insert row into a table

Insert a new row into a Supabase table.

**Inputs**

- Table name (`table`, text, required): The name of the table to add the row to.
- New row (`row`, object, required): The new row's columns and values. Pick a table and its columns appear as fields to fill in; if the table comes from an earlier step, enter column-and-value pairs yourself (for example, {"name": "Ada", "email": "ada@example.com"}).

**Outputs**

- `row` (object): Inserted row data.

**Example output**

```json
{
  "row": {
    "id": 2,
    "name": "Inserted row"
  }
}
```

### List rows from a table

Get rows from a Supabase table, with optional filters to narrow the results.

**Inputs**

- Table name (`table`, text, required): The name of the table to read from.
- Columns to return (`columns`, list): The columns to return. Pick from the table's columns; leave empty to return every column.
- Match conditions (`match`, object): Only return rows where these columns exactly equal these values, given as column-and-value pairs (for example, {"status": "active"}). Leave blank to return every row.
- Maximum rows (`limit`, number): The most rows to return. Leave blank to return all matching rows.

**Outputs**

- `rows` (list)

**Example output**

```json
{
  "rows": [
    {
      "id": 1,
      "name": "Sample"
    }
  ]
}
```

### Update rows in a table

Update rows in a Supabase table that match your conditions.

**Inputs**

- Table name (`table`, text, required): The name of the table to update.
- Match conditions (`match`, object, required): Only update rows where these columns exactly equal these values, given as column-and-value pairs (for example, {"id": 42}).
- New values (`updates`, object, required): The columns to change and their new values, given as column-and-value pairs (for example, {"status": "done"}).

**Outputs**

- `rows` (list): The rows that were updated, with their new values.

**Example output**

```json
{
  "rows": [
    {
      "id": 3,
      "status": "done"
    }
  ]
}
```