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.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  


Queries the value of the json.

Component Version macOS Windows Linux Server iOS SDK
JSON 6.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.GetValue"; json )   More


Parameter Description Example
json A JSON text or reference. "1.3"


Returns value or error.


Queries the value of the json.
This is same as using JSON.GetDoubleValue or JSON.GetStringValue, but automatically detect type.
For boolean value return 0 or 1.
For object or array returns JSON text.
Numbers are returned as numbers.


Returns 5 for a numeric value:

MBS( "JSON.GetValue"; "5" )

Example result: 5

Returns text:

MBS( "JSON.GetValue"; "\"Test JSON\"" )

Example result: Test JSON

Returns 1 for boolean:

MBS( "JSON.GetValue"; "true" )

Example result: 1

See also

Release notes

  • Version 9.3
    • Changed JSON.GetValue to pass number via string to avoid double rounding.

Blog Entries

FileMaker Magazin

Created 3th February 2016, last changed 11st December 2016

JSON.GetType - JSON.Import

Feedback: Report problem or ask question.

MBS Xojo PDF Plugins

Start Chat