JSON Input

JSONPath expressions can use either dot notation or square bracket notation.

The Content tab contains the following options for configuring which data to retrieve:

The Fields tab displays field definitions to extract values from the JSON structure. The table in this tab contain the following columns:

Click Get Fields in the Fields tab to open the Select Fields window. Select the checkbox next to each field in your source file that you want include in your output. All the fields selected in this transform are added to the table. You can search for a field name by entering the field name in the Search box.

The Additional output fields tab contains the following options to specify additional information about the file to process:

All fields of this transform support metadata injection. You can use this transform with ETL Metadata Injection to pass metadata to your pipeline at runtime.