fm_query_records
Query FileMaker records by table with OData filters, field selection, pagination, and sorting. Returns formatted results with optional record count.
Instructions
Query FileMaker records from a FileMaker table using OData v4.
Use this tool to search, filter, and retrieve records from your FileMaker database.
Args: table: Table name (use fm_list_tables to see available tables). filter: OData $filter expression. ALWAYS call fm_get_schema(table) first — field names vary by table. Examples (use exact names from get_schema): - "City eq 'Springfield'" - "ServiceDate ge 2026-01-01" - "Amount gt 500" - "Region eq 'A' and Status eq 'Open'" select: Comma-separated field names to return. Leave empty for all fields. Example: "Company Name,Phone,City,Email" top: Maximum records to return (default 20, max 10000). skip: Number of records to skip (for pagination). orderby: OData $orderby expression. Example: "ServiceDate desc" or "Company Name asc" count: Include total record count in response (default True).
Returns: Formatted text with matching records and field values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | ||
| skip | No | ||
| count | No | ||
| table | Yes | ||
| filter | No | ||
| select | No | ||
| orderby | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |