Field guide / Analyze records

Spot the gaps.Fix the shape.

See missing fields and mixed types before you change a record.

THE WORKFLOW, AT A GLANCE

Start with this sample

JSON sample

1[
2  { "id": 1, "name": "Ada" },
3  { "id": "2" }
4]

Worth knowing

Here id has two types and name is missing once. This is a structural report, not validation against a supplied JSON Schema.

Follow the steps

01
Choose what to inspect
Open Analyze. The full document is selected first; use Inspect to choose a nested object or array. Your selection stays while editing.
02
Read the field health
Record arrays show field presence, observed types and examples. Primitive arrays show distinct values, duplicates, nulls and blank strings.
03
Locate, then decide
Locate next reveals the source record. Review the confirmation before filling a missing field with null, removing it or normalizing its type.
04
Export the findings
Analysis Export creates JSON or CSV reports. Use the document Export action when you want the current JSON source instead.