Lodol Docs

Baserow

API actions for the Baserow integration.

Baserow

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


Create a row

Add a new row to a Baserow table.

Parameters

ParameterTypeRequiredDescription
fieldsobjectYesThe values for the new row, given as column-name and value pairs (for example, Name: 'Acme Inc.', Status: 'Active').

Response

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

Delete a row

Permanently remove a row from a Baserow table.

Parameters

ParameterTypeRequiredDescription
row_idnumberYesThe ID of the row to delete. You can find it with the List rows action.

Response

{
  "deleted": true
}

Get a row

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

Parameters

ParameterTypeRequiredDescription
row_idnumberYesThe ID of the row to get. You can find it with the List rows action or from a Create row result.

Response

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

List rows

Get the rows from one of your Baserow tables.

Parameters

ParameterTypeRequiredDescription
limitnumberNoThe most rows to return, up to 200. Leave blank to return the first page of rows.

Response

{
  "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.

Parameters

ParameterTypeRequiredDescription
row_idnumberYesThe ID of the row to update. You can find it with the List rows action or from a Create row result.
fieldsobjectYesThe 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.

Response

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

On this page