Record Schema Unifier with Missing-Field Gap Report

How it works

1. 1.Run the workflow manually from the Manual Trigger
2. 2.A Code node emits fictional records: one with groups, one with adminGroups, one with groups:null, plus a non-object invalid case
3. 3.The unify Code node computes the key union, infers types, fills gaps, and documents them in filled_fields
4. 4.The Set node adds filled_count and is_complete while retaining all fields
5. 5.The final Code node emits one report item with totals, per_key_defaults, and normalized records, filtering the internal stats item

Use cases

• Normalizing nested irregular API responses before binding expressions
• Detecting records with missing fields in data pipelines
• Preparing schema-consistent data for downstream n8n nodes

Requirements

• No credentials and no external calls
• n8n 2.45.5 with default Code, Set, NoOp nodes
• For real use, replace the sample emitter with an HTTP Request output using the same json.record schema

Setup and testing in n8n

1. Import the JSON into n8n and click Execute Workflow
2. Verify every record carries the same key union with no undefined
3. Check filled_fields per record, filled_count, and that total_fields_filled=6
4. Test no-valid-records: set the emitter array to [{record:null}] and verify a correct report (total=1, valid=0, invalid=1)

Service Value

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