fm_query
Query FileMaker records with OData filters, sorting, pagination, and field selection. Retrieve up to 1000 records per request with optional count and related portal data.
Instructions
Query records from a FileMaker table. Supports OData $filter, $select, $top, $skip, $orderby, $expand, $count. Default limit: 100 records (override with $top).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | FileMaker table name (exact name from FM) | |
| filter | No | OData $filter expression, e.g. "Name eq 'Max'". Escape single quotes in string literals: ' → '' | |
| select | No | Comma-separated field names, e.g. "ID,Name,Date" | |
| top | No | Max number of records | |
| skip | No | Records to skip (pagination) | |
| orderby | No | Sort order, e.g. "Name asc" | |
| expand | No | Include related portals, e.g. "LineItems" | |
| count | No | Return total record count |