Read JSON
Read JSON Objects ..
Last updated
Read JSON Objects ..
Last updated
Steel Wheels have several JSON data sources. You will create a simple workflow to extract the required reporting dataset.
In this workshop, you will configure the following step:
JSON Input
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking File > New > Transformation
By using the CTRL-N hot key
View the jsonfile.js
Notice that the delivery status can be Delivered | Returned
The JSON Input step extracts relevant portions out of JSON structures, files or incoming fields, and outputs rows.
Drag the ‘JSON Input’ step onto the canvas.
Double-click on the step, and configure the following properties:
Click on the ‘Fields’ tab and configure the following properties:
Close the Step.
➡️ Next:
➡️ Next: