Baserow
App · Databases · 5 actions
Create, read, update, and delete rows in your Baserow tables.
Actions
| Action | What it does |
|---|---|
| Create a row | Add a new row to a Baserow table. |
| Delete a row | Permanently remove a row from a Baserow table. |
| Get a row | Get a single row from a Baserow table by its row ID. |
| List rows | Get the rows from one of your Baserow tables. |
| Update a row | Change the values of an existing row in a Baserow table. |
Create a row
Add a new row to a Baserow table.
Inputs
- Table ID
table_idtextRequired - 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
fieldsobjectRequired - 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_namestrue/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
idnumber- The ID of the newly created row (use it as the Row ID in other actions).
Example output
{
"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_idtextRequired - 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_idnumberRequired - The ID of the row to delete. You can find it with the List rows action.
Outputs
deletedtrue/false- Whether the row was deleted.
Example output
{
"deleted": true
}Get a row
Get a single row from a Baserow table by its row ID.
Inputs
- Table ID
table_idtextRequired - 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_idnumberRequired - 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_namestrue/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
idnumber- The row's ID.
Example output
{
"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_idtextRequired - 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
limitnumber - The most rows to return, up to 200. Leave blank to return the first page of rows.
- Use column names
user_field_namestrue/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
countnumber- Total number of rows in the table.
resultslist- The rows on this page. Each row includes its 'id' and its column values.
Example output
{
"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_idtextRequired - 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_idnumberRequired - The ID of the row to update. You can find it with the List rows action or from a Create row result.
- Column values
fieldsobjectRequired - 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_namestrue/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
idnumber- The row's ID.
Example output
{
"Name": "Acme Inc.",
"Status": "Closed",
"id": 1,
"order": "1.00"
}