Find request operators and wildcards

Expert

Use FileMaker find operators — ranges, wildcards, exact match, and negation — inside Data API query objects.

What you'll learn

How to use range, wildcard, and exact-match operators in query objects
How to negate a find request to omit records
How to combine multiple query objects for complex searches

Data API find requests accept the same operators as FileMaker's Find Mode UI — ranges, wildcards, exact match, and field negation. Combining these operators lets you replicate any complex find that a user would build interactively, entirely from an API call.

1/3

Common find operators

Field values in a query object support the same operator prefixes as FileMaker's Find Mode.

JSON

// Range: dates in January 2025
{ "InvoiceDate": "1/1/2025...1/31/2025" }

// Wildcard: names starting with "Sm"
{ "LastName": "Sm*" }

// Exact match: use == prefix
{ "Email": "==user@example.com" }

// Greater than
{ "Amount": ">100" }

// Less than or equal
{ "Amount": "<=500" }

// Not equal
{ "Status": "!=Cancelled" }

Data API token management and session reuse Bulk creates and updates via the Data API