JSON.SELECT
Formula Explanation
Retrieve values from JSON data using a key.
Formula Syntax
json.select("JSON data string", "key to select")
- JSON data string: Must be a valid JSON string.
- If the selected key doesn't exist in the data, it returns a blank value.
- Both parameters can use column references, which are the CODEs at the top of each column in the table. For example: AA1.
Usage Example
Retrieve the "name" value from the JSON data string in column DC2 and write it into column DC3.
DC3 = json.select(DC2, "name");
