JSONPARSE
Extracts a single field from a json
Last updated
Was this helpful?
Extracts a single field from a json
Last updated
Was this helpful?
JSONPARSE( Column
, Name
)
Checks if a column
contains an input name
within the Json path
Input
Description
column
Column of json to parse and extract field for name
name
String path to search for in column
Outputs field found in json
Json
JSONPARSE( { Json }, "first" )
{"first" : "John", "middle" : "K", "last" : "Doe"}
"John"
{"first" : "Jane", "middle" : "J", "last" : "Doe"}
"Jane"
Json
JSONPARSE( { Json }, "name[0].middle" )
{"name": [{"first" : "John", "middle" : "K", "last" : "Doe"}]}
"K"
{"name": [{"first" : "Jane", "middle" : "J", "last" : "Doe"}]}
"J"