Because the JSON functions parse the entire JSON object passed into them, it can be more efficient to use the JSON functions on smaller JSON objects inside a loop that is repeated many times. Creating a record for a product each time through the loop, the script uses GetValue to get the JSON object for a product from the list and sets the fields to the values obtained using JSONGetElement. Assuming the Example JSON data is stored in the $$JSON variable, the script uses JSONListValues to get the contents of the product array as a list of values and uses ValueCount to determine the number of products in the list. The following example script creates a record for each product in a JSON array. For example, if a key at the root of a JSON object is "layout.response", then keyOrIndexOrPath would be "". However, you must use bracket notation if key names include periods, so that the JSON parser can correctly identify the entire key name. You can use either notation in keyOrIndexOrPath. The difference between dot and bracket notation is that, instead of using periods (.) to separate key names, bracket notation surrounds key names with single quotes (') and brackets (). The first element of the array in the nameA object, which is at the third level in a set of nested arrays The key of an object named name at the root levelĪn object named nameC, which is a descendent of nameB and nameA The root level, if it’s the first character (optional in dot notation)Įlements at index n of an array at the root level The following two types of syntax for the keyOrIndexOrPath parameter are supported: dot notation and bracket notation. Path – a hierarchical string of key names, array indexes, or both Index – the index of an element in a JSON array (the first element has an index of 0) The second parameter, keyOrIndexOrPath, specifies the portion of the JSON data to operate on: The first parameter of these functions, json, specifies the text field, variable, or text expression that contains valid JSON data to operate on. JSONListValues – Lists the values in JSON data JSONListKeys – Lists the object names (keys) or array indexes in JSON data JSONGetElement – Queries JSON data for an element (an object, array, or value) Use the following JSON functions to parse JSON data-that is, to get keys, values, or entire JSON objects or arrays that you can process further: However, to make the data easier to read while you debug problems, use the JSONFormatElements function, which adds tabs and line ending characters, as shown in Example JSON data. JSON data doesn’t require spaces or line endings between elements. FileMaker Pro provides several text functions that enable your custom app to parse and modify JSON data from other sources, such as web services that transfer data in JSON format via a REST API.įor more information about the JSON data format, see.
0 kommentar(er)
