Silent Null & PairedItem Range Output Auditor
Loading workflow…
Workflow Description
A self-contained manual-trigger n8n workflow loads fictional input/output record pairs, then a Code node compares every field to flag values that silently resolved to null, fields that vanished entirely, and pairedItem indexes that are outside source bounds or invalid. IF sends damaged records (TRUE) to the damaged noOp path and healthy records (FALSE) to a Set node tagging verified_healthy with includeOtherFields. Both branch nodes enable alwaysOutputData so Merge completes even when one branch is empty, and the summary skips placeholder items. A final Code node emits one report with per-type counts and locations. It detects loss only; no repairs or external calls.
How it works
- 1.Manual Trigger runs a Code node emitting four fictional pairs: healthy, silent null, missing field, out-of-range index
- 2.The audit Code node compares fields, validates pairedItemIndex against sourceLength, and builds a detailed defects array per record
- 3.IF routes damaged (TRUE) to the Damaged Records Path noOp; healthy (FALSE) to Set tagging verified_healthy while keeping all fields
- 4.Merge appends both paths (empty-branch safe via alwaysOutputData) and a final Code node emits exactly one summary item
Use cases
- Auditing multi-branch stage outputs before downstream stages
- Catching silent item loss in production executions
- Guaranteeing record completeness before delivery or billing
Requirements
- n8n 2.44.4 or newer
- No credentials, no external calls
- For real use: input/output pairs of the same schema with pairedItemIndex and sourceLength
Setup and testing in n8n
- Import the JSON into n8n and run Execute Workflow
- Confirm ORD-1002, ORD-1003, ORD-1004 flow through the Damaged Records Path and only ORD-1001 carries auditStatus=verified_healthy
- Verify the final report shows 1 healthy, 3 damaged with per-type counts and otherDefectCount at zero
- Replace the sample loader with clean pairs for a zero summary, and with all-damaged pairs to verify Merge completes
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (8)
Manual Trigger
Manual Trigger
Load Sample Input-Output Pairs
Code
Audit Nulls, Missing Fields, PairedItem Range
Code
Is Record Damaged?
If
Damaged Records Path
No Op
Enrich Healthy Records
Set
Merge Audited Records
Merge
Build Run Summary Report
Code
Method Sticky Note
Sticky Note
Setup Sticky Note
Sticky Note
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
- New workflows
- Clear overviews
- Setup guides