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.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
Statistic
FMM
Blog
Queries value from JSON path in array of objects.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
JSON | 7.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
json | A JSON text or reference. | "{\"people\":[{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}]}" | |
Path | The path through the json hierarchy as list. For object, pass name of item to choose. For array pass index. |
"people¶0¶last" | |
AsValue | Pass 1 to return as value, e.g. text or number. Pass 0 (or nothing) to return as JSON. |
Optional |
Returns OK or error.
Query all test values in objects in array:
MBS("JSON.GetArrayPathItems"; JSON Test::JSON; "test")
Lookup items in array:
MBS( "JSON.GetArrayPathItems"; "[{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}, {\"first\":\"Peter\",\"last\":\"Miller\",\"city\":\"New York\"}]"; "first"; 0 )
Example result:
"Christian"
"Peter"
Lookup item values in array:
MBS( "JSON.GetArrayPathItems"; "[{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}, {\"first\":\"Peter\",\"last\":\"Miller\",\"city\":\"New York\"}]"; "first"; 1 )
Example result:
Christian
Peter
Created 27th January 2017, last changed 28th June 2017
JSON.GetArrayItemsAsList - JSON.GetArraySize
Feedback: Report problem or ask question.