Learning Pentaho Data Integration 8 CE - Third Edition

Parsing JSON structures

If you need to parse complex JSON structures and the JSON Input step doesn't meet your needs, you can resolve the task with a Java Class step. A simple way for this is with the org.json.simple package. Among the classes found in this package, you will mainly use the following:

org.json.simple Class	Description
JSONParser	This class parses JSON text
JSONValue	This class has methods to parse JSON string into Java objects
JSONObject	It's an unordered collection of name/value pairs
JSONArray	It's an ordered sequence of values

 

To use this package in a Java Class step, you just import the needed libraries at the beginning of the code, as follows:

import org.json.simple.JSONArray;import ...