Schema Integrity Auditor and Dead-Letter Quarantine Router

How it works

1. 1.Initiate manual execution via Manual Execution Trigger.
2. 2.Generate realistic normal and corrupted payloads via Emit Fictional Payloads.
3. 3.Inspect types, required fields, and regular expressions in Validate Schema Rules.
4. 4.Branch the records using Evaluate Audit Validity based on boolean audit status.
5. 5.Forward healthy payloads through Pass-Through Valid Records.
6. 6.Enrich and tag invalid records with quarantine metadata in Tag Dead-Letter Quarantine.
7. 7.Synthesize telemetry, operational counts, and quarantine diagnostics in Generate Execution Telemetry.

Use cases

• Validating incoming API payloads before database insertion or CRM updates.
• Isolating corrupt webhook events to prevent downstream task failure.
• Creating an auditable dead-letter routing mechanism within native n8n workflows.

Requirements

• Test target: n8n 2.44.6 with Merge 3.2, If 2.2 and Set 3.4.
• No third-party credentials required; runs completely offline using native n8n nodes.
• Optional _auditAt sets the audit time; otherwise current time is used. Demo inputs use a fixed time for repeatable testing.
• Quarantine means tagging records and grouping them in the deadLetterQueue output array for this execution only. It is not a durable queue, persistent audit store, or external delivery service. Inspect the output or add suitable storage for production use.

Setup and testing in n8n

1. Import the JSON workflow into your n8n workspace.
2. Click Test Workflow on the canvas to trigger execution.
3. Inspect the final node Generate Execution Telemetry output.
4. Verify that two records are marked valid and two records are captured in the deadLetterQueue array with explicit reasons.

Service Value

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