What null and missing-value inspection is
A record-by-record measure of field completeness
Completeness inspection compares the fields discovered across every object in an array. It separates properties that are absent, explicitly null, or present as empty strings, then calculates the share of usable values for each field.
Data quality workflows
Find incomplete records before they enter another system
Review customer exports, event logs, configuration lists, or migrated records before importing them. Normalized paths aggregate repeated nested arrays so completeness remains comparable across the document.
API validation
Compare actual response coverage without generating a schema
Inspect saved API responses to see whether expected fields are populated across all resources. Null and missing values remain separate because they often represent different API behavior.
Analytics preparation
Measure dimension and metric coverage before analysis
Check identifiers, labels, categories, timestamps, and measures before loading a dataset into a spreadsheet or analytics pipeline. The report makes weak fields visible without changing the source.
Examples
Interpret each completeness signal precisely
| Record value | Reported as |
|---|---|
"email": null | Present and null |
No email property | Missing |
"email": "" | Present and empty string |
"active": false | Complete |
Inspection utilities
Continue with related UtilityDock inspection workflows
FAQ
Questions about JSON completeness
Does UtilityDock upload or store my JSON?
No. Your files never leave your computer. Validation, array discovery, completeness analysis, preview, copying, and report creation all happen locally inside your browser.
What counts as a complete value?
A value is complete when its property exists and the value is neither null nor an empty string. Zero, false, objects, and arrays count as complete values.
What is the difference between null and missing?
Null means the property exists with the JSON value null. Missing means the property does not exist in that record.
Are whitespace-only strings considered empty?
No. Version 1 counts only the exact empty string as empty. A string containing spaces remains present and complete.
Can the tool fix incomplete records?
No. Version 1 is read-only. It does not correct data, generate schemas, modify documents, or call APIs.