Icon

Nested JSONs Example

extract json with nested observation datathis has the data points for each yearThe refence area and unit are not nestedretain the json data onlyungrop the data so that each reference areahas their own line of dataExtract the data points of obervation timeand observation value foreach reference areaUngroup the data so that there is a record for each period of each areaFSI Feildsof interestURL Prefix_AnnualURLSurfixURLSort by feild nameascGroup be feild nameURL with field codeto retrieve dataCollate dataremove missing rowsselect only 5 fieldsfor brievityget rid of missing valuesfor the observed valueJSON Path Column Filter Ungroup JSON Path Ungroup Table Creator ConstantValue Column ConstantValue Column String Manipulation Sorter Group Loop Start GET Request Loop End Missing Value Row Sampling Missing Value extract json with nested observation datathis has the data points for each yearThe refence area and unit are not nestedretain the json data onlyungrop the data so that each reference areahas their own line of dataExtract the data points of obervation timeand observation value foreach reference areaUngroup the data so that there is a record for each period of each areaFSI Feildsof interestURL Prefix_AnnualURLSurfixURLSort by feild nameascGroup be feild nameURL with field codeto retrieve dataCollate dataremove missing rowsselect only 5 fieldsfor brievityget rid of missing valuesfor the observed valueJSON Path Column Filter Ungroup JSON Path Ungroup Table Creator ConstantValue Column ConstantValue Column String Manipulation Sorter Group Loop Start GET Request Loop End Missing Value Row Sampling Missing Value

Nodes

Extensions

Links