Options

The Hierarchical JSON input step features several tabs with fields. Each tab is described below.

Source tab

Hierarchical JSON Input step dialog box showing source tab

Option/Field	Description
From file	Select to specify the file path and name of the JSON file you want to load into PDI.
File name	File path and name of the JSON file to load.
From field	Select to use an incoming field as the JSON file path.
Field with file name	The incoming field containing the JSON file path.

## Output tab

Hierarchical JSON Input step Output tab

Field	Description
Output field	Specify the field name for output column.
Split rows across path	Specify the JSON path to be parsed. See Hierarchical data path specifications

**Note:** The **Split rows across path** option is especially useful when loading JSON array objects within large JSON files.

Filters tab

Hierarchical JSON Input step filters tab

Use the Path field(Optional) to specify the filters to apply while using the Split rows across path option to fetch the subset of a JSON file. See Hierarchical data path specifications