Row → Get All
AI-generatedSummary
List rows from a NocoDB table with optional view, filters, sorting, field selection, and relation expansion.
Inputs
- workspaceId — Optional workspace to scope the base selection.
- baseId (required) — Base (project) identifier or slug.
- tableId (required) — Table identifier or slug.
- viewId — Optional view to scope the query.
- filterGroups — Filter conditions; groups are OR-ed, conditions inside a group use AND/OR.
- recordOptions — Options for fields to return, sorting, expanding relations, and pagination.
- returnAll — If true, fetch all pages; otherwise limit the number of returned records.
- limit — Maximum number of records to return when returnAll is false (default 50).
- page — Page number to start fetching from (default 1).
Output shape
Array of row objects matching the selected fields, with link fields expanded if requested.
Each item represents a row from the table. When expandRelations is true, link fields are replaced with the linked records.
Examples
Example 1: Get the first 100 rows from a table, sorted by a date field descending.
Set baseId and tableId, enable returnAll false, set limit 100, add a sort on the date field with direction descending.