Nested Array Flattener with Source Paths and Two-Way Routing

How it works

1. 1.Run the workflow manually; the loader Code node emits one item holding the fictional nested structure under data
2. 2.The recursive flatten node walks the structure and emits one flat record per leaf element with source_path and parent_fields
3. 3.The IF node checks that qty is not empty and routes each record to the true or false branch
4. 4.The true branch tags records qty_present keeping all fields; the false branch passes through a NoOp
5. 5.A two-input append Merge reunifies both branches into one iterable list

Use cases

• Flattening nested API-style JSON payloads before iteration or merging
• Tracing which parent array each row came from for auditing
• Splitting records by field completeness before downstream processing

Requirements

• No credentials and no external calls; all processing is local
• To use real input: delete the Load Nested Sample Data node and feed the flattener with output containing an object under data

Setup and testing in n8n

1. Import the JSON into n8n and run Execute Workflow manually
2. Verify 5 flat records and that source_path matches original locations
3. Verify the count entering the IF equals the count leaving the Merge (5=5)
4. Try qty null, missing qty, and a nested non-array field (invalid_item)
5. Try a deeper structure by nesting an array inside stock to confirm depth-agnostic flattening

Service Value

Ready-made workflow template for automation delivery and service execution.