get-records
For DATA QUERIES (search, filter, paginate). For current view rows, use get-grid-rows.
Parameters:
tableId (required)
viewId - Apply view filters (optional)
recordId - Fetch a specific record by ID. When provided, search/take/skip are ignored (optional)
take - Records to return, default 100, max 1000 (optional)
skip - Records to skip for pagination (optional)
projection - Field IDs or names to return (optional). If not provided, only first 50 fields will be returned
search - Search filter object: { value: "keyword", fieldId: "Name" } (fieldId accepts field name OR ID; omit for global search) (optional)
Important:
If user refers to rows in current view ("first 3 rows", "last row", "row N"), use get-grid-rows instead.
This tool queries server-persisted data. For the user's live view state (unsaved filters/sorts), use get-grid-rows.
Response (tabular format): {header: ["id", "Name"], rows: [["rec001", "Task A"]]}
Examples: All: { tableId: "tblXXX" } By ID: { tableId: "tblXXX", recordId: "recXXX" } Search: { tableId: "tblXXX", search: { value: "keyword", fieldId: "Name" } } Pagination: { tableId: "tblXXX", take: 50, skip: 100 }
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": {
"tableId": "<tableId>",
"projection": "<projection>"
},
"name": "get-records"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skip | No | Number of records to skip for pagination | |
| take | No | Number of records to return (default: 100, max: 1000) | |
| search | No | Search filter. Pass { value: "keyword" } for global search, or { value: "keyword", fieldId: "Name" } to search a specific field | |
| viewId | No | View ID to use for filtering (optional) | |
| tableId | Yes | The ID of the table to query records from | |
| recordId | No | Record ID to fetch a specific record directly. When provided, search/take/skip are ignored. | |
| projection | Yes | Projection of field ids to return, pass "all" to return all fields (max 50) |