Docs
Open Lodol
DocumentationIntegrationsAPI

Supabase

App · Databases · 4 actions

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

Actions

ActionWhat it does
Delete rows from a tableDelete rows in a Supabase table that match your conditions.
Insert row into a tableInsert a new row into a Supabase table.
List rows from a tableGet rows from a Supabase table, with optional filters to narrow the results.
Update rows in a tableUpdate rows in a Supabase table that match your conditions.

Delete rows from a table

Delete rows in a Supabase table that match your conditions.

Inputs

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

Outputs

rowslist
The rows that were deleted.
Example output
{
  "rows": [
    {
      "id": 4
    }
  ]
}

Insert row into a table

Insert a new row into a Supabase table.

Inputs

Table nametabletextRequired
The name of the table to add the row to.
New rowrowobjectRequired
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

rowobject
Inserted row data.
Example output
{
  "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 nametabletextRequired
The name of the table to read from.
Columns to returncolumnslist
The columns to return. Pick from the table's columns; leave empty to return every column.
Match conditionsmatchobject
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 rowslimitnumber
The most rows to return. Leave blank to return all matching rows.

Outputs

rowslist
Example output
{
  "rows": [
    {
      "id": 1,
      "name": "Sample"
    }
  ]
}

Update rows in a table

Update rows in a Supabase table that match your conditions.

Inputs

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

Outputs

rowslist
The rows that were updated, with their new values.
Example output
{
  "rows": [
    {
      "id": 3,
      "status": "done"
    }
  ]
}

Sunrise Sunset

Previous Page

Supadata

Next Page

On this page

ActionsDelete rows from a tableInsert row into a tableList rows from a tableUpdate rows in a table