JSONPARSE

Extracts a single field from a json

JSONPARSE( Column, Name )

Checks if a column contains an input name within the Json path

Arguments

Input

Description

column

Column of json to parse and extract field for name

name

String path to search for in column

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

Was this helpful?