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. The 'List' operation fetches rows from a table with support for pagination, filtering, ordering, and search. This is useful for automating data retrieval from Baserow tables, such as syncing data with other systems, generating reports, or processing data workflows.

Use Case Examples

  1. List rows from a Baserow table with a limit and specific ordering.
  2. Filter rows based on field values or date conditions.
  3. Search rows containing specific text in any field.

Properties

Name Meaning
Host The base URL of the Baserow API endpoint to connect to.
Table ID The identifier of the Baserow table from which to list rows.
Disable field auto mapping If true, disables automatic translation of field names from internal 'field_xxx' format to user-friendly column names.
Limit result Limits the number of rows returned by the list operation.
Query size Specifies the size of each paginated query when fetching rows.
Search Filters rows to only those containing the search string in any field.
Order Defines how the result rows should be ordered, specifying fields and direction (ascending or descending).
Filter Defines filters to apply on rows, specifying field, operator, and value for comparison.

Output

JSON

  • id - Unique identifier of the row.
  • field_xxx or column name - Field values of the row, either in internal 'field_xxx' format or mapped to column names depending on auto mapping setting.

Dependencies

  • Requires an API key credential for Baserow API authentication.

Troubleshooting

  • Ensure the 'Host' URL is correct and accessible.
  • Verify the 'Table ID' is valid and the API key has permissions to access it.
  • If field auto mapping is disabled, field names will be in 'field_xxx' format which may be less readable.
  • Pagination settings like 'Query size' and 'Limit result' should be set appropriately to avoid incomplete data retrieval or excessive API calls.
  • Filters and ordering must use valid field names and operators supported by Baserow API.

Links

Discussion