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

Output

Outputs field found in json

See documentation for further details:

https://jsonpath-rw.readthedocs.io/en/latest/#jsonpath-syntax

Example

Example 2

Last updated