List Records

The List Records action node in NocoDB workflows allows you to fetch multiple records from a selected table based on defined filters and limits. This node is useful when you need to process, evaluate, or act on a collection of records within a workflow.

Configuration

• Table: Select the table from which records should be retrieved.
• View: (Optional) Choose a specific view to apply its predefined filters and sorting to the record retrieval.
• Limit: (Optional) Specify the maximum number of records to fetch. Defaults to 25 if not set.
• Offset: (Optional) Set an offset to skip a certain number of records before starting to return results.
• Filters: (Optional) Define conditions to narrow down the records returned. Filters can use static values or data from previous workflow nodes. These filters are applied in addition to any selected view's filters.
• Sort: (Optional) Specify the field(s) and order (ascending/descending) to sort the returned records.

How it works

• When the workflow reaches the List Records node, it queries the selected table using the configured filters.
• Matching records are returned as a list and can be referenced in subsequent nodes, such as loops or conditional logic.

Use cases

• Retrieve all pending tasks or records matching a specific status.
• Fetch related records before performing bulk updates or notifications.
• Prepare a dataset for iteration using loop-based workflow nodes.