fm_query_records
Query FileMaker database records with advanced filtering, sorting, and pagination. Specify database, layout, and query criteria to retrieve targeted 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 |