JSONListValues
Purpose
Lists the values in JSON data for an element specified by an object name, an array index, or a path.
Format
JSONListValues(json;keyOrIndexOrPath)
Parameters
json - any text expression or field that contains a JSON object or array.
keyOrIndexOrPath - any text expression or field that specifies a JSON object name (key), an array index, or a path. See
Working with the JSON functions.
Data type returned
text
Originated in
FileMaker Pro 16.0
Notes
•Each returned value, except the last, ends with a carriage return.
•This function is not supported in runtime solutions and returns "?".
Example 1
Gets the values of all objects at the root of the JSON object.
JSONListValues( "{ \"a\" : 11, \"b\" : 22, \"c\" : 33 }", "" ) returns 11¶22¶33.
Example 2
From the
Example JSON data stored in the $$JSON variable, gets the values of all elements in the array in the "product" object.
JSONListValues ( $$JSON ; "bakery.product" ) returns
{"category":"Breads","id":"FB1","name":"Donuts","price":1.99,"special":true,"stock":43}
{"category":"Cakes","id":"FB2","name":"Chocolate Cake","price":22.5,"special":true,"stock":23}
{"category":"Breads","id":"FB3","name":"Baguette","price":3.95,"special":true,"stock":34}
Example 3
From the
Example JSON data stored in the $$JSON variable, gets the values of all elements in the first "product" object in the array.
JSONListValues ( $$JSON ; "bakery.product[0]" ) returns
Breads¶FB1¶Donuts¶1.99¶true¶43.
Related topics