| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
JSON.Search
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
Parameters
| Parameter | Description | Example |
|---|---|---|
| json | A JSON text or reference. | "{\"people\":[{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}]}" |
| path | The path to query. |
Result
Returns JSON or error.
Description
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:
https://jmespath.org
See also JSON.Query for queries with JSONPath expressions.
Examples
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
- JSON Search Example
- MBS FileMaker Plugin, version 13.6pr1
- New in MBS FileMaker Plugin 13.5
- Neues MBS Plugin 13.5 für Claris FileMaker
- MBS Plugin 13.5 for Claris FileMaker
- Using JSONPath in FileMaker
- Checking out JSON.Search function in MBS FileMaker Plugin
- JSON Query in FileMaker
- MBS FileMaker Plugin, version 13.5pr1
This function checks for a license.
Created 17th September 2023, last changed 13th October 2023
