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.GetObjectItem

Queries named item from an object.

Parameters

Parameter	Description	Example	Flags
json	A JSON text or reference.	"[1,2,3]"
name	The name of the key to query.	"test"
AsReference	Whether to return a reference number (1) instead of the JSON text (0). Default is 0 for JSON text.	0	Optional

Result

Returns JSON code.

Description

Examples

Create object, add content and pick value:

Let(
[
j = MBS( "JSON.CreateObject");
j = MBS( "JSON.AddStringToObject"; j; "hello"; "world" );
r = MBS( "JSON.GetObjectItem"; j; "hello" )
];
r)

Pick a text from a JSON dictionary:

set $json to "{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}"
set $first to MBS("JSON.GetObjectItem"; $json; "first")
set $firstText to MBS("JSON.GetStringValue"; $first)
display dialog $firstText

Extract error details from JSON:

# JSON in field:
#{
# "error": {
# "message": "Your card's expiration year is invalid.",
# "type": "card_error",
# "param": "exp_year",
# "code": "invalid_expiry_year"
# }
#}
#get it in variable
Set Variable [$json; Value:test::input]
#pick error node
Set Variable [$error; Value:MBS("JSON.GetObjectItem"; $json; "error")]
If [$error = ""]
    Show Custom Dialog ["No error"; "No error node in the JSON."]
Else
    #get message node
    Set Variable [$message; Value:MBS("JSON.GetObjectItem"; $error; "message")]
    #decode text
    Set Variable [$messageText; Value:MBS("JSON.GetStringValue"; $message)]
    #get code node
    Set Variable [$code; Value:MBS("JSON.GetObjectItem"; $error; "code")]
    #decode text
    Set Variable [$codeText; Value:MBS("JSON.GetStringValue"; $code)]
    #show result
    Show Custom Dialog ["Got error"; "Message: " & $messageText & ¶ & "Code: " & $codeText]
End If

See also

• JSON.AddStringToObject
• JSON.CreateObject
• JSON.GetObjectItemTree
• JSON.GetObjectItemTreeRef
• JSON.GetObjectName
• JSON.GetObjectSize
• JSON.GetStringValue

Example Databases

• CURL/Email/IMAP Email List
• CURL/Email/IMAP Email
• CURL/WebServices/TinyURL
• CURL/WebServices/WeatherBit.io test
• JSON/JSON Order Parsing
• JSON/JSON Test
• Win Only/WindowsML

Blog Entries

• With JSON in excellent form

FileMaker Magazin

• Ausgabe 5/2020, Seite 18, PDF

Created 18th August 2014, last changed 3th February 2016

JSON.GetIntegerValue   -   JSON.GetObjectItemTree

Feedback: Report problem or ask question.