fm_find_records
Find records in a FileMaker database by providing a layout name and an array of search query objects. Optionally limit the number of results or specify a starting record.
Instructions
Find records using a query. Query is an array of search criteria objects.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of records to return (optional) | |
| query | Yes | Array of query objects (e.g., [{"FirstName": "John"}, {"LastName": "Doe"}]) | |
| layout | Yes | Layout name | |
| offset | No | Starting record (optional) | |
| database | No | Database name (optional, uses default from session if not provided) |