Compound find queries with the FileMaker Data API

Intermediate

Use the _query array to send multiple find criteria in a single request, combine them with AND/OR logic, and omit unwanted records using the omit flag.

What you'll learn

How to structure a _query array for multi-criteria finds
How AND vs OR logic maps to the _query structure
How to omit records using the "omit" flag on a criteria object

The Data API models find requests as an array of criteria objects — each object is one Find Request, and multiple objects are ORed together, while fields inside a single object are ANDed.

1/4

Send a simple single-criteria find

POST to /layouts/{layout}/_find with a JSON body containing a _query array. Each element maps field names to find values. Ranges, wildcards, and operators like < and > are all supported as plain strings.

HTTP

POST /fmi/data/v1/databases/{db}/layouts/Customers/_find
Authorization: Bearer {token}
Content-Type: application/json

{
  "query": [
    { "Status": "Active", "Region": "West" }
  ]
}

Running a FileMaker script via the Data API Updating a record with PATCH /records/{recordId}