Skip to content
AI Agents

Silent Null & PairedItem Range Output Auditor

8 nodes 79 6 Manual trigger
Download

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. 1.Manual Trigger runs a Code node emitting four fictional pairs: healthy, silent null, missing field, out-of-range index
  2. 2.The audit Code node compares fields, validates pairedItemIndex against sourceLength, and builds a detailed defects array per record
  3. 3.IF routes damaged (TRUE) to the Damaged Records Path noOp; healthy (FALSE) to Set tagging verified_healthy while keeping all fields
  4. 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

  1. Import the JSON into n8n and run Execute Workflow
  2. Confirm ORD-1002, ORD-1003, ORD-1004 flow through the Damaged Records Path and only ORD-1001 carries auditStatus=verified_healthy
  3. Verify the final report shows 1 healthy, 3 damaged with per-type counts and otherDefectCount at zero
  4. 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

Manual Trigger Code If No Op Set Merge

Details

Trigger Manual trigger
Nodes 8
Apps 6
Views 79
Downloads 6

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (8)

Manual Trigger

Manual Trigger

#1

Load Sample Input-Output Pairs

Code

#2

Audit Nulls, Missing Fields, PairedItem Range

Code

#3

Is Record Damaged?

If

#4

Damaged Records Path

No Op

#5

Enrich Healthy Records

Set

#6

Merge Audited Records

Merge

#7

Build Run Summary Report

Code

#8

Method Sticky Note

Sticky Note

#9

Setup Sticky Note

Sticky Note

#10
Stay in the loop

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

Be first to discover what is new

Your name, your email, and one confirmation.

Email confirmation · Unsubscribe anytime