# List Records

> Part of the NocoDB documentation (Workflows > Workflows > Nodes > Action). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/workflows/nodes/action-nodes/list-records
Last updated: 2026-10-03

Get many records from a NocoDB table as part of your workflows.

Use the **List Records** action node in NocoDB workflows to get many records from a selected table. Defined filters and limits control which records you get. Use this node to process, evaluate or act on a collection of records in a workflow.

<img alt="List Records Node" src={__img0} placeholder="blur" />

<AskNocoAI>
  <Prompt>
    Every [morning], list [tasks due today] and email them to me
  </Prompt>

  <Prompt>
    Every [Friday], list [deals closed this week] and email a summary to [the sales team]
  </Prompt>

  <Prompt>
    When a [Project] is marked [Done], list its [open tasks] and set them to [Cancelled]
  </Prompt>
</AskNocoAI>

### Configuration

| Setting     | What it does                                                                                                                                                                                                  |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Table**   | Select the table that contains the records.                                                                                                                                                                   |
| **View**    | (Optional) Select a view. NocoDB then uses the filters and sorting of that view.                                                                                                                              |
| **Limit**   | (Optional) Set the maximum number of records to get. The default is 25.                                                                                                                                       |
| **Offset**  | (Optional) Set the number of records to skip before the results start.                                                                                                                                        |
| **Filters** | (Optional) Set conditions to limit the records that you get. Filters can use static values or data from previous workflow nodes. NocoDB applies these filters together with the filters of the selected view. |
| **Sort**    | (Optional) Specify the field(s) and the order (ascending/descending) for the records.                                                                                                                         |

### How it works

* When the workflow gets to the List Records node, the node queries the selected table with the configured filters.
* The node returns the matching records as a list. Later nodes can use this list, for example loops or conditional logic.

### Use cases

* Get all pending tasks, or all records with a specific status.
* Get related records before bulk updates or notifications.
* Prepare a dataset for iteration with loop nodes.

## Availability

* Available on NocoDB Cloud (all plans) and licensed on-premise deployments.

---

## Related pages

- [Create Record](https://nocodb.com/docs/workflows/nodes/action-nodes/create-record.md): Create new records in NocoDB tables as part of your workflows.
- [Update Record](https://nocodb.com/docs/workflows/nodes/action-nodes/update-record.md): Update existing records in NocoDB tables as part of your workflows.
- [Delete Record](https://nocodb.com/docs/workflows/nodes/action-nodes/delete-record.md): Delete existing records in NocoDB tables as part of your workflows.
- [Find Record](https://nocodb.com/docs/workflows/nodes/action-nodes/find-record.md): Get one record from a NocoDB table view by its record ID in a workflow.
- [Send Email](https://nocodb.com/docs/workflows/nodes/action-nodes/send-email.md): Send emails as part of NocoDB workflows.
- [Run Script](https://nocodb.com/docs/workflows/nodes/action-nodes/run-script.md): Run custom JavaScript scripts as part of NocoDB workflows.
- [HTTP Request](https://nocodb.com/docs/workflows/nodes/action-nodes/http-request.md): Send HTTP requests from a NocoDB workflow to external APIs or services, with configurable methods, headers and parameters.