Pre-Flatten Nested JSON Strings So Set Works With Simple Mappings Only

How it works

1. 1.Run Manual Trigger; Sample Records emits fictional items with nested JSON strings
2. 2.Parse And Flatten parses any string starting with { or [ into dot-path typed fields
3. 3.Broken JSON is tagged failed with reason invalid_json_text and kept in field__unresolved
4. 4.Map Flat Fields assigns record_id, status and counters using simple assignments plus includeOtherFields
5. 5.If compares unresolved_json_marker to empty and sends leftovers to Review Queue
6. 6.Review and clean NoOp nodes feed two separate Merge inputs in append mode
7. 7.Build Report (runOnceForAllItems) returns exactly one report sorted by record_id

Use cases

• Avoid failing JSON.parse expressions inside Set nodes on n8n Cloud
• Flatten webhook payloads delivered as a JSON string in one field
• Detect fields that remain unresolved JSON text before downstream stages
• Produce a parsing-quality report for a batch of records

Requirements

• n8n 2.46.4 or newer
• No credentials needed for the manual demo
• For real data replace Sample Records with Webhook, HTTP Request or a DB node using the same schema
• Fields intended for parsing must start with { or [

Setup and testing in n8n

1. Import the JSON and click Execute Workflow
2. Confirm REC-1001 and REC-1003 are resolved with flattened dot-path keys
3. Confirm REC-1002 is failed with invalid_json_text and route review
4. Add a record without record_id and verify NO_ID-n generation
5. Empty the records array and verify a zeroed report with an empty records list

Service Value

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