Record → Search
AI-generatedOverview
This node operation allows searching for records within a specified base, table, and optionally a view in Cubable. It supports returning all results or limiting the number of results, and provides options to include and expand custom fields in the output. This is useful for retrieving filtered or specific data entries from Cubable databases for further processing or integration.
Use Case Examples
- Retrieve all records from a specific table in a Cubable base to analyze data.
- Search records within a particular view to get filtered results based on predefined criteria.
- Fetch a limited number of records with specific custom fields expanded for detailed data extraction.
Properties
| Name | Meaning |
|---|---|
| Authentication | Select the authentication method to access Cubable API, currently supports Access Token. |
| Base | Select or specify the Cubable Base ID where the records are stored. |
| Table | Select or specify the Cubable Table ID within the chosen base to search records. |
| View | Optionally select or specify a View ID to filter the records according to the view's criteria. |
| Return All | Boolean option to return all matching records or limit the number of results. |
| Limit | Maximum number of records to return if 'Return All' is false. |
| Options | Additional options to customize the search output, including which custom fields to output, whether to expand nested custom fields, and whether to return custom fields by their field IDs. |
Output
JSON
records- Array of record objects matching the search criteria, including standard and optionally custom fields.
Dependencies
- Cubable API access with an access token credential
Troubleshooting
- Ensure the Base ID, Table ID, and View ID (if used) are valid and correctly formatted to avoid validation errors.
- If no records are returned, verify that the search criteria and view filters are correctly set and that records exist in the specified table.
- Authentication errors may occur if the access token is invalid or expired; ensure the token is current and has appropriate permissions.