Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3    Statistic    FMM    Blog  


Queries named item from an object tree.

Component Version macOS Windows Linux Server iOS SDK
JSON 3.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.GetObjectItemTree"; json; Names... )   More


Parameter Description Example
json A JSON text or reference. "[1,2,3]"
Names... The names for keys to query. Pass several parameters to go down an object tree. For arrays you can pass index. "test"


Returns JSON or error.


Queries named item from an object tree.
You still need functions like JSON.GetStringValue to get back the decoded string.
Works also for arrays where you pass in index.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Names parameter as often as you need.


Query properties object and inside it the lastname object and there the value property:

MBS("JSON.GetObjectItemTree"; JSON Test::JSON; "properties"; "lastname"; "value")

Look into object tree, pick addresses, first address, than value and there the content of street:

MBS("JSON.GetStringValue"; MBS( "JSON.GetObjectItemTree"; test::JSON ; "addresses"; 0; "value"; "streetAddress" ))

See also

Release notes

  • Version 11.3
    • Changed JSON.GetObjectItemTree, JSON.GetObjectItemTreeRef, JSON.AddArrayToArray and JSON.AddItemToArray to ignore empty parameters.

Blog Entries

FileMaker Magazin

Created 18th August 2014, last changed 5th June 2021

JSON.GetObjectItem - JSON.GetObjectItemTreeRef

Feedback: Report problem or ask question.

MBS Xojo tutorial videos

Start Chat