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: 11.3   11.4   11.5   12.0   12.1   12.2   12.3   12.4   12.5   13.0    Statistic    FMM    Blog  

JSON.GetStringValue

Queries string value of the JSON node.

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

Parameters

Parameter Description Example
json A JSON text or reference. "[1,2,3]"

Result

Returns text.

Description

Queries string value of the JSON node.

Examples

Get string value:

MBS( "JSON.GetStringValue"; "\"Hello\rjust a test\"" )

Example result:
Hello
just a test

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

Decode string with unicode text:

MBS( "JSON.GetStringValue"; "\"Hello \u00e4\"" )

See also

Release notes

Example Databases

Blog Entries

Created 18th August 2014, last changed 17th February 2017


JSON.GetPathItem - JSON.GetType

Feedback: Report problem or ask question.


Start Chat