Reference > Functions reference > JSON 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.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Working with the JSON functions