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

  1. Click the JSON Parser step in the outline.
  2. 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.
    1. Select Single file.
    2. 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.
  3. 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.
  4. 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.
  5. On the Validation page, select Minimal Validation. If you use Minimal Validation all data types are automatically converted to the String type.