Open Studio for Big Data
Open Studio for Data Integration
Open Studio for ESB
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
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.