Reference > Functions reference > Text functions > JSONListValues

JSONListValues

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¶1¶43.