Configuring the JSON Parser step
Configure the location of the JSON source data and the schema that you want to use to parse it.
Procedure
- Click the JSON Parser step in the outline.
- On the JSON Source page specify the location of the JSON
source data. In this example, the JSON source data is in the single
file schema.json.
- Select Single file.
- Click Insert Parameter and select the json_example_root_folder parameter. Specify the exact location of the file when you run the job. For example if you have downloaded and saved the json schema file in the directory, C:\json_example_root_folder, enter this directory as the value for the first parameterc:/json_example_root_folder/schema.json.
- On the Document Root page, you select the schema element that describes the documents that the step parses. Click Browse. Open the Example_Parser library, which is the library into which you imported the schema.json file.
- Select the root element and then click OK. The Document Root page displays the structure of the schema. The Output schema page also displays the same structure.
- On the Validation page, select Minimal Validation. If you use Minimal Validation all data types are automatically converted to the String type.
Parent topic: Example 1: Parsing JSON data