Setting the type of metadata and loading the template JSON file

About this task

In this step, the type of schema is set as either input or output. For this procedure, the schema of interest is output.

From the dialog box, select Output JSON click Next to proceed to the next step of the wizard.
Choose whether to create the output metadata manually or from an existing JSON file as a template.
If you choose the Create manually option you will have to configure the schema and link the source and target columns yourself. The output JSON file/field is created via a Job using a JSON output component such as tWriteJSONField.

In this example, we will create the output metadata by loading an existing JSON file. Therefore, select the Create from a file option.
Click the Browse... button next to the JSON File field, browse to the access path to the JSON file the structure of which is to be applied to the output JSON file/field, and double-click the file. Alternatively, enter the full path to the file or the URL which links to the template JSON file.
The File Viewer area displays a preview of the JSON structure, and the File Content area displays a maximum of the first 50 rows of the file.
Enter the Encoding type in the corresponding field if the system does not detect it automatically.
In the Limit field, enter the number of levels in the JSON hierarchical depth to which you want to limit the JsonPath or XPath query, 0 for no limits.
Setting this parameter to a value less than 5 can help prevent the wizard from hanging in case of a large JSON file.
Optionally, specify an output file path.
Click Next to define the schema.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!