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

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: o.adekanye
Created at: 2023-10-08
On NodePit since: 2023-10-09
Last update: 2024-05-01
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!