Query data table rows
n8n_get_datatable_rowsList rows from a data table with optional JSON filter, full-text search, sorting, and pagination.
Instructions
List rows from a data table with optional filter, search, sorting and pagination. Filter is a JSON string with {type, filters} structure.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataTableId | Yes | Data table ID | |
| limit | No | Max rows (default 50) | |
| cursor | No | Pagination cursor | |
| filter | No | JSON filter, e.g. {"type":"and","filters":[{"columnName":"status","condition":"eq","value":"active"}]} | |
| sortBy | No | columnName:asc or columnName:desc | |
| search | No | Full-text search on string columns |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | ||
| nextCursor | No |