JSONPARSE
Extracts a single field from a json
Due to the complexity of parsing several rows of JSON, this function takes longer than the average Cascade function.
JSONPARSE( Column
, Name
)
Checks if a column
contains an input name
within the Json path
Arguments
Input | Description |
| Column of json to parse and extract field for |
| String path to search for in |
Output
Outputs field found in json
See documentation for further details:
https://jsonpath-rw.readthedocs.io/en/latest/#jsonpath-syntax
Example
Json | JSONPARSE( { Json }, "first" ) |
{"first" : "John", "middle" : "K", "last" : "Doe"} | "John" |
{"first" : "Jane", "middle" : "J", "last" : "Doe"} | "Jane" |
Example 2
Json | JSONPARSE( { Json }, "name[0].middle" ) |
{"name": [{"first" : "John", "middle" : "K", "last" : "Doe"}]} | "K" |
{"name": [{"first" : "Jane", "middle" : "J", "last" : "Doe"}]} | "J" |
Last updated