| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
JSON.GetValue
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
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
Decode the escape unicode sequence:
MBS( "JSON.GetValue"; "\"\uD83C\uDF4E\"")
Example result: 🍎
See also
Release notes
- Version 13.4
- Changed JSON.GetStringValue, JSON.GetBooleanValue, JSON.GetDoubleValue, JSON.GetIntegerValue and JSON.GetValue to return empty result if called with empty value.
- Version 9.3
- Changed JSON.GetValue to pass number via string to avoid double rounding.
Blog Entries
- MBS FileMaker Plugin, version 13.4pr1
- Sort with evaluate in FileMaker
- With JSON in excellent form
- MBS FileMaker Plugin, version 9.3pr5
- MBS FileMaker Plugin, version 6.1pr2
FileMaker Magazin
This function checks for a license.
Created 3th February 2016, last changed 31st January 2023
