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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"dataTableId": "<dataTableId>"
},
"name": "n8n_get_datatable_rows"
}
}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 |