Centralizing JSON file metadata

If you often need to use a JSON file, you may want to use the New Json File wizard to centralize the file connection, XPath query statements, and data structure in the Repository for easy reuse.

Depending on the option you select, the wizard helps you create either an input or an output file connections. In a Job, the tFileInputJSON and tExtractJSONFields components use the input schema created to read JSON files/fields, whereas tWriteJSONField uses the output schema created to write a JSON field, which can be saved in a file by tFileOutputJSON or extracted by tExtractJSONFields.

For information about setting up input JSON file metadata, see Setting up JSON metadata for an input file.

For information about setting up output JSON metadata, see Setting up JSON metadata for an output file.

In the Repository view, expand the Metadata node, right click File JSON, and select Create JSON Schema from the contextual menu to open the New Json File wizard.