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: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

JSON.GetValue

Queries the value of the json.

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

Parameters

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

Result

Returns value or error.

Description

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.

Examples

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

Blog Entries

FileMaker Magazin

Release notes

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

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


JSON.GetType   -   JSON.Import

Feedback: Report problem or ask question.



Links
MBS FileMaker blog

Start Chat