Overview
The Recursive JSON With Parent command provides functionality for:- Recursively traversing nested JSON structures
- Preserving parent context at a configurable number of levels
- Identifying child elements by a specified property key
Command Type
Command Type ID: 1006Parameters
| Parameter | Type | Description | Required |
|---|---|---|---|
| property | string | The property key in the JSON object used to identify child elements | Yes |
| parentLevel | number | Determines how many levels up the hierarchy to include in the returned structure | Yes |
Usage Examples
Extract Children with One Parent Level
Extract with Two Parent Levels
Traverse Nested Categories
Common Use Cases
- Tree Traversal: Flatten recursive tree structures (e.g. categories, menus, org charts)
- Hierarchy Extraction: Pull leaf nodes out of deep nesting while retaining parent context
- Data Normalization: Convert nested recursive JSON into flat records with ancestry
Related Commands
- Json Path - Extract elements from JSON structures
- Key Mapping - Remap fields after extraction
- Insert To Children - Inject parent data into children