List Records
Lists records in NocoDB.
This node is also exposed as an AI Agent tool.
This node has 1 input port and 1 output port.
Common Properties
Every node shares these.
- Name — the node's display name on the canvas.
- Color — the node's colour on the canvas.
- Delay Before (sec) — wait this long before the node runs.
- Delay After (sec) — wait this long after the node runs.
- Continue On Error — carry on instead of failing the flow. Defaults to false.
info
When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.
Inputs
| Property | Field | Description |
|---|---|---|
| Client ID | inClientID | Client ID from Connect node (optional if credentials provided) |
| Table ID | inTableID | Table ID (starts with 'm' prefix，e.g. m1abc2def) |
Outputs
| Property | Field | Description |
|---|---|---|
| Count | outCount | Number of records returned |
| Has More | outHasMore | True if there are more records available |
| Records | outRecords | Array of records matching the query |
| Total Rows | outTotalRows | Total number of records matching the filter (for pagination) |
Options
| Property | Field | Description |
|---|---|---|
| Base URL | optBaseURL | NocoDB base URL (required if not using Connect node) |
| Credentials | optCredentials | NocoDB API token (optional - use instead of Connect node) |
| Fields | optFields | Comma-separated list of fields to return (empty |
| Limit | optLimit | Maximum number of records to return (default 25，max 100) |
| Offset | optOffset | Number of records to skip (for pagination) |
| Sort | optSort | Sort by field (prefix with - for descending，e.g. -CreatedAt) |
| Timeout (seconds) | optTimeout | Maximum time to wait for response |
| Where | optWhere | Filter condition (e.g. (Status，eq，Active) or (Age，gt，18)) |
Requirements
- A Client ID from this package's Connect node, unless you set credentials directly on this node.
- NocoDB API Token — API token for NocoDB authentication. Tokens do not expire.
value— API Token (password, required). Your NocoDB API token
Store these in a Vault and reference the vault item from the node, rather than typing the secret into the property.
Related nodes
Create Record · Get Record · Update Record · Delete Record · Bulk Create Records · Bulk Update Records · Bulk Delete Records
Elsewhere in the package: Connect · Disconnect · Toolkit
See also
- NocoDB — every node in this package
- Message object — how properties read values from
msg - Handling failure — Continue On Error, Catch and retries