Overview
The "Get Many" operation of the Row resource in this node allows users to retrieve multiple rows from a specified table within a NocoDB project. This operation supports fetching all rows or limiting the number of returned rows, applying sorting rules, filtering by formulas, selecting specific fields, and optionally downloading attachments associated with the rows.
This node is beneficial when you need to extract bulk data from a NocoDB table for further processing, reporting, or integration with other systems. For example, you might use it to fetch all customer records sorted by their signup date or to retrieve only active orders filtered by a custom formula.
Properties
| Name | Meaning |
|---|---|
| Authentication | Choose the authentication method: "API Token" or "User Token". |
| API Version | Select the version of the NocoDB API to use: "Before v0.90.0", "v0.90.0 Onwards", or "v0.200.0 Onwards". |
| Workspace Name or ID | (Only for API Version 3) Select or specify the workspace where the base resides. |
| Base Name or ID | (API Version 2 and 3) Select or specify the base/project containing the table. |
| Project ID | (API Version 1) Specify the project ID containing the table. |
| Table Name or ID | Select or specify the table from which to retrieve rows. |
| Return All | Boolean flag indicating whether to return all matching rows or limit the results. |
| Limit | Maximum number of rows to return if "Return All" is false. Minimum value is 1. |
| Download Attachments | Whether to download attachment files defined in the "Download Fields" property. |
| Download Fields | Comma-separated list of attachment field names to download. Case sensitive. Required if "Download Attachments" is true. |
| Options | Additional options to customize the query: |
| - View ID | Specify a view ID to select particular fields of the returned rows. |
| - Fields | List of specific fields to return for each row. |
| - Sort | Sorting rules for the returned rows. Each rule includes: • Field: The field name to sort on. • Direction: "ASC" (ascending) or "DESC" (descending). |
| - Filter By Formula | A formula string used to filter rows, e.g., (name,like,example%)~or(name,eq,test). |
Output
The output is an array of JSON objects representing the rows retrieved from the specified table. Each object contains key-value pairs corresponding to the fields and their values in the row.
If "Download Attachments" is enabled, the node also outputs binary data for the specified attachment fields. These binaries represent the downloaded files linked to those fields, allowing subsequent nodes to process or store them.
Dependencies
- Requires access to a NocoDB instance with appropriate permissions.
- Needs either an API token or user token for authentication.
- Depending on the selected API version, different endpoints are used internally.
- For downloading attachments, the node performs additional API calls to fetch file data.
Troubleshooting
- Empty Results: If no rows are returned, verify that the table, base/project, and workspace IDs are correct and that the filter formula (if any) matches existing rows.
- Attachment Download Failures: Ensure that the specified attachment field names are correct and that the attachments exist. Also, confirm that the node has permission to access storage endpoints.
- API Errors: Common errors include invalid credentials, incorrect IDs, or unsupported API versions. Check the authentication settings and ensure the node configuration matches your NocoDB setup.
- Limit Ignored: If "Return All" is set to true, the "Limit" parameter is ignored; ensure this is intentional.
- Sorting Not Applied: Confirm that the field names used in sorting exist in the table and are spelled correctly.
Links and References
- NocoDB Official Documentation
- NocoDB API Reference
- n8n Expressions Documentation (for using expressions in property fields)