Read JSON
Read JSON Objects ..
Workshop - Read JSON
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

Create a new Transformation
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

The following content has been automatically generated by an AI system and should be used for informational purposes only. We cannot guarantee the accuracy, completeness, or timeliness of the information provided.
Any actions taken based on this content are at your own risk. We recommend seeking qualified expertise or conducting further research to validate and supplement the information provided.
View the jsonfile.js
{ "document": {
"order": [
{ "productline": "Classic Cars",
"customer": "Christine Loomis",
"status": "Delivered",
"date": "January 2004",
"value": 21.99
},
{ "productline": "Classic Cars",
"customer": "Mary L. Peachin",
"status": "Delivered",
"date": "November 2008",
"value": 24.99
},
{ "productline": "Trains",
"customer": "Bob Italia",
"status": "Delivered",
"date": "July 1994",
"value": 14.99
},
```
Notice that the delivery status can be Delivered | Returned
JSON Input
The JSON Input step extracts relevant portions out of JSON structures, files or incoming fields, and outputs rows.
Start Pentaho Data Integration.
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: Dummy
Last updated
Was this helpful?