fm_query_records
Retrieve records from FileMaker databases using advanced filters, sorting, and pagination. Specify layout, query conditions, sort order, limit, and offset to get precise data.
Instructions
Query records with advanced filtering and sorting
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": {
"database": "<database>",
"layout": "<layout>"
},
"name": "fm_query_records"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Sort array | |
| limit | No | Max records to return | |
| query | No | Find requests array | |
| layout | Yes | Layout name | |
| offset | No | Records to skip | |
| database | Yes | Database identifier |