Setting the type of metadata and loading the template JSON file - 7.3

Talend Open Studio User Guide
Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

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.

Procedure

  1. From the dialog box, select Output JSON click Next to proceed to the next step of the wizard.
  2. 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.
  3. 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.
  4. Enter the Encoding type in the corresponding field if the system does not detect it automatically.
  5. 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.
  6. Optionally, specify an output file path.
  7. Click Next to define the schema.