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']