Options
The Hierarchical JSON input step features several tabs with fields. Each tab is described below.
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
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
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
Last updated
Was this helpful?