Baserow Extended icon

Baserow Extended

Consume the Baserow API

Actions5

Row → Get Many

AI-generated

Overview

The Baserow Extended node for n8n, when configured with the "Row" Resource and "Get Many" Operation, retrieves multiple rows from a specified table in a Baserow database. It supports advanced filtering, searching, and sorting options, making it suitable for scenarios where you need to extract structured data from Baserow for further processing or integration with other systems.

Common use cases:

  • Exporting filtered datasets from Baserow to spreadsheets or reporting tools.
  • Synchronizing Baserow tables with other databases or applications.
  • Building dashboards or automations that require dynamic querying of Baserow data.

Example:
You could use this node to fetch all customer records from a "Customers" table where the "Status" field is "Active", sorted by "Signup Date" in descending order, and limited to the top 100 results.

Properties

Name Type Meaning
Database Name or ID options The Baserow database to operate on. You can select from a list or specify an ID using an expression.
Table Name or ID options The table within the selected database to query. Select from a list or specify an ID using an expression.
Return All boolean Whether to return all matching rows or limit the number of results. If false, the "Limit" property applies.
Limit number Maximum number of rows to return (applies only if "Return All" is false). Must be between 1 and 100.
Options collection Additional options for customizing the query. Includes filters, filter type, search term, and sorting.
└ Filters fixedCollection Define one or more conditions to filter rows based on field values and operators (e.g., equals, contains, date comparisons, etc.).
└ Filter Type options Logical operator ("AND"/"OR") to combine multiple filters. Defaults to "AND".
└ Search Term string A text string to match against any column in the table.
└ Sorting fixedCollection Specify fields and directions (ascending/descending) to sort the result set.

Output

  • The output is a JSON array, where each element represents a row from the queried Baserow table.
  • Each row object contains key-value pairs corresponding to the table's fields, with field names mapped to their human-readable names.
  • No binary data is produced by this operation.

Example output:

[
  {
    "ID": 123,
    "Name": "Alice",
    "Status": "Active",
    "Signup Date": "2024-01-15"
  },
  {
    "ID": 124,
    "Name": "Bob",
    "Status": "Active",
    "Signup Date": "2024-02-10"
  }
]

Dependencies

  • External Service: Requires access to a Baserow instance via its API.
  • API Key: You must provide valid Baserow API credentials (configured as baserowApi in n8n).
  • n8n Configuration: Ensure the node has network access to your Baserow server and that credentials are correctly set up.

Troubleshooting

Common Issues:

  • Invalid Database/Table ID: If the provided database or table ID does not exist, the node will fail. Double-check IDs or use the dropdown selectors.
  • Authentication Errors: Missing or incorrect API credentials will result in authentication failures.
  • Filter Misconfiguration: Using invalid field names or unsupported operators in filters may cause errors or empty results.
  • Result Limits: If "Return All" is false and "Limit" is set too low, you may not retrieve all desired data.

Error Messages & Resolutions:

  • "Cannot find database/table": Ensure the correct database and table are selected or the IDs are accurate.
  • "Authentication failed": Verify your Baserow API credentials in n8n.
  • "Field does not exist": Check that filter and sort fields exist in the target table.

Links and References

Discussion