Overview
The Row - Get Many operation for the BaserowAdvanced n8n node retrieves multiple rows from a specified table in a Baserow database. This is useful for extracting data sets, performing bulk analysis, or integrating Baserow data with other systems. Common scenarios include syncing Baserow tables with external databases, generating reports, or filtering and sorting large datasets based on custom criteria.
Practical examples:
- Fetch all customer records from a CRM table for reporting.
- Retrieve filtered lists of orders placed after a certain date.
- Export sorted product inventories for integration with an e-commerce platform.
Properties
| Name | Meaning |
|---|---|
| Database Name or ID | Database to operate on. Choose from the list, or specify an ID using an expression. |
| Table Name or ID | Table to operate on. Choose from the list, or specify an ID using an expression. |
| Return All | Whether to return all results or only up to a given limit. If disabled, you can set a maximum number of results to return. |
| Limit | Max number of results to return (only shown if "Return All" is false). Minimum value is 1. |
| Options | Additional options for customizing the query. Includes: • Filters: Filter rows based on comparison operators (see below for filter options). • Filter Type: Combine filters using AND or OR logic. • Search Term: Text to match in any column. • Sorting: Set the sort order of the result rows. |
| └ Filters | Add one or more filters to compare fields using various operators: • Contains • Contains Not • Date After Date • Date Before Date • Date Equal • Date Equals Month • Date Equals Today • Date Equals Year • Date Not Equal • Equal • Filename Contains • Higher Than • Is Empty • Is Not Empty • Is True • Link Row Does Not Have • Link Row Has • Lower Than • Not Equal • Single Select Equal • Single Select Not Equal |
| └ Filter Type | How to combine multiple filters: • AND: Rows must match all filters • OR: Rows must match at least one filter. Defaults to AND. |
| └ Search Term | Text string to search for in any column. |
| └ Sorting | Specify one or more fields to sort by, and the direction (ASC or DESC) for each. |
Output
- The output is an array of JSON objects, each representing a row from the selected Baserow table.
- Each object contains key-value pairs where keys are the field names (as mapped from Baserow's internal IDs to human-readable names).
- Example output structure:
[
{
"id": 123,
"Name": "Alice",
"Email": "alice@example.com",
"Created At": "2024-06-01T12:34:56Z"
},
{
"id": 124,
"Name": "Bob",
"Email": "bob@example.com",
"Created At": "2024-06-02T09:21:00Z"
}
]
- No binary data is returned by this operation.
Dependencies
- External Service: Requires access to a Baserow instance.
- API Key: Needs valid Baserow API credentials configured in n8n under the name
baserowApi. - n8n Configuration: Ensure the BaserowAdvanced node is installed and credentials are set up.
Troubleshooting
Common Issues:
- Invalid Credentials: If the API key is missing or incorrect, authentication will fail. Double-check your Baserow API credentials in n8n.
- Incorrect Database/Table ID: If the provided database or table ID does not exist or is inaccessible, the node will throw an error.
- Filter Syntax Errors: Using invalid filter values or operators may result in errors or empty results.
- Large Data Sets: Retrieving very large tables without setting a limit may cause performance issues or timeouts.
Error Messages & Resolutions:
"Request failed with status code 401": Check your API credentials."Table not found"or"Database not found": Verify the selected database/table exists and the user has access."Invalid filter operator": Review the filter configuration for typos or unsupported operators.