JSONListKeys
Purpose
Lists the object names (keys) or array indexes in JSON data for an element specified by an object name, an array index, or a path.
Format
JSONListKeys(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 names of all objects at the root of the JSON object.
JSONListKeys( "{ \"a\" : 11, \"b\" : 22, \"c\" : 33 }", "" ) returns a¶b¶c.
Example 2
From the
Example JSON data stored in the $$JSON variable, gets the indexes of all elements in the array in the "product" object.
JSONListKeys ( $$JSON ; "bakery.product" ) returns 0¶1¶2.
Example 3
From the
Example JSON data stored in the $$JSON variable, gets the keys of all elements in the first "product" object in the array.
JSONListKeys ( $$JSON ; "bakery.product[0]" ) returns category¶id¶name¶price¶special¶stock.
Related topics