Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Performs a JMESPath query.

Component Version macOS Windows Linux Server iOS SDK
JSON 13.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.Search"; json; path )   More


Parameter Description Example
json A JSON text or reference. "{\"people\":[{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}]}"
path The path to query.


Returns JSON or error.


Performs a JMESPath query.
The jmespath extension implements JMESPath. JMESPath is a query language for transforming JSON documents into other JSON documents. It's supported in both the AWS and Azure CLI and has libraries available in a number of languages.

To learn more about JMESPath, please check this website:

See also JSON.Query for queries with JSONPath expressions.


Try it:

MBS( "JSON.Search"; "{ \"locations\": [
  {\"name\": \"Seattle\", \"state\": \"WA\"},
  {\"name\": \"New York\", \"state\": \"NY\"},
  {\"name\": \"Bellevue\", \"state\": \"WA\"},
  {\"name\": \"Olympia\", \"state\": \"WA\"}
]}"; "locations[?state == 'WA'].name | sort(@) | {WashingtonCities: join(', ', @)}")

Example result:
{ "WashingtonCities": "Bellevue, Olympia, Seattle" }

See also

Release notes

  • Version 14.0
    • Fixed an endless loop in JSON.Search function with a bad query. Now propergates the error properly.
  • Version 13.5
    • Added JSON.Search to perform JMESPath queries in FileMaker.

Example Databases

Blog Entries

This function checks for a license.

Created 17th September 2023, last changed 13th October 2023

JSON.ReplaceItemInObject - JSON.SetPathItem