Baserow icon

Baserow

Create, update, and delete row in Baserow.
Join our community

Actions5

Overview

This node integrates with Baserow, a no-code database platform, to perform CRUD operations on rows within a specified table. It supports creating, listing, retrieving, updating, and deleting rows in Baserow tables. This node is useful for automating data management workflows, such as adding new records, updating existing data, or extracting data for further processing.

Use Case Examples

  1. Create a new row in a Baserow table to log form submissions automatically.
  2. Retrieve and list rows from a Baserow table to sync data with another system.
  3. Update specific rows in a Baserow table based on external triggers or events.
  4. Delete rows from a Baserow table as part of a cleanup process.

Properties

Name Meaning
Host The base URL of the Baserow API endpoint to connect to.
Table ID The identifier of the Baserow table where rows will be accessed or modified.
Additional Options Optional settings to customize behavior, including disabling automatic field name mapping from internal field IDs to column names.

Output

JSON

  • id - The unique identifier of the row in the Baserow table.
  • field_xxx or columnName - The data fields of the row, either using internal field IDs or mapped column names depending on the auto mapping setting.
  • success - Indicates successful deletion of a row (only for delete operation).

Dependencies

  • Requires an API key credential for authenticating with the Baserow API.

Troubleshooting

  • Ensure the provided Table ID is correct and accessible with the API key used.
  • If field auto mapping is disabled, use internal field IDs (e.g., 'field_123') in input and output data; otherwise, use column names.
  • Common errors include authentication failures due to invalid API keys, or 404 errors if the table or row IDs do not exist.
  • For pagination in list operations, ensure limits and sizes are set appropriately to avoid incomplete data retrieval.

Links

Discussion