JSON Path (Dictionary)

Collects the parts specified by JSONPath s from a JSON column. For those parts that cannot be found or have incompatible types, missing values will be returned.

Example input table:
column namepathtypebookyear$.book[*].yearList(Double)invalidyear$.book[2].yearDoubletimeline$.book[?(@.year==1999)].titleStringpaths$..*List(Path) Example input:

{"book": [
  {"year": 1999,
   "title": "Timeline",
   "author": "Michael Crichton"},
  {"year": 2000,
   "title": "Plain Truth",
   "author": "Jodi Picoult"}
]}

The results look like this: bookyearinvalidyeartimeline{1999, 2000}?Timeline The paths column contains the following values (String list): $['book'] , $['book'][0] , $['book'][1] , $['book'][0]['year'] , $['book'][0]['title'] , $['book'][0]['author'] , $['book'][1]['year'] , $['book'][1]['title'] , $['book'][1]['author']

Input ports

1. Type: Table
   Data with JSON
   Table containing JSON column
2. Type: Table
   JSONPaths
   Table containing JSONPath, type and output column name definitions.

Output ports

1. Type: Table
   Extracted columns
   Table with extracted columns appended