Altova XMLSpy 2024 Enterprise Edition

Validating JSON Documents

Home Prev Top Next

XMLSpy contains a JSON validation engine that can be invoked to do the following:

 

If a JSON schema is the active document: Validates the JSON schema against the appropriate JSON Schema specification (for which no additional schema assignment is needed); the schema version is indicated by the \$schema keyword; the validation can be carried out in any of the three views (Text, Grid, and JSON Schema).

If a JSON instance is the active document: Validates the JSON instance against a JSON schema. The schema is assigned to the JSON instance as described below. JSON instance validation can be carried out in Text View and Grid View.

If a JSON5 instance is the active document: Validates the JSON instance against a JSON schema. The schema is assigned to the JSON5 instance as described below. JSON5 instance validation can be carried out in Text View and Grid View.

 

Avro validation (Enterprise Edition only)

Avro data and Avro schema documents, as JSON documents, can be validated in Text View and Grid View:

 

If an Avro data instance in JSON format is the active document: Validates the Avro instance against an Avro schema. The schema is assigned to the instance as described below.

If an Avro schema is the active document: Validates the Avro schema against the Avro schema specification (no schema assignment is needed); the validation can be carried out in Text View or Grid View.

 

Assigning a JSON or Avro schema to a JSON instance

In order to validate a JSON instance against a JSON schema or Avro schema, the schema must be assigned to the active instance document. The assignment is entered in the Info window (screenshot below) of the active JSON instance document, or via the Project Properties dialog (the Validate With option). Note that JSON5 instance documents are validated against JSON schemas.

JSONInfoWindow

In the JSON tab of the Info Window, click the arrow icon next to Validation against schema, and, in the menu that appears, click Select JSON Schema or Select Avro Schema (see screenshot above). Browse for the schema, and click OK. The schema will be assigned to the active JSON instance document, and the schema's filename will be entered in the Info window. If the JSON instance document is empty, the assignment of a JSON or Avro schema to the instance will automatically fill the JSON instance with sample data based on the schema.

 

To remove the assignment, select the command Remove Schema from the same menu (see screenshot above).

 

For information about generating JSON schema from the JSON instance, see the section Generating JSON Schema from a JSON Instance.

 

Validating instance and schema documents

Select the command XML | Validate XML (F8) or click the Validate (F8) icon ic_validate in the toolbar to validate the active JSON document (instance or schema) or Avro schema. If an instance document is being validated, a schema document must be assigned to the instance (see above). Validation results are displayed in the Messages window. Errors are also flagged in the line-numbering margin. If a smart fix is available for an error, then a light bulb icon is shown on the line that generates the error. When you place the mouse over the icon, a popup appears that lists available smart fixes. Select a fix to apply it immediately.

Note:The validation error indicators and smart fixes described above are refreshed only when the XML | Validate (F8) command is executed; they are not updated in the background. So, after correcting an error, you must run the Validate (F8) command again to make sure that the error has indeed been fixed.

 

To go to the schema document from the instance document, double-click the schema in the Info window (see screenshot above), or select the command DTD/Schema | Go to Schema. To go directly to the schema definition of a JSON keyword or object, select the keyword or object in the instance document and select DTD/Schema | Go to Definition.

 

You can also validate a project folder containing JSON files by using the Validate command.

 

Validate on modification

The Validate on Edit mode is toggled on by default. When toggled on, well-formed checks and validation checks are carried out as you modify a document in JSON Grid View. For validation of a JSON document to be carried out (additional to well-formed checks), a JSON Schema must be assigned to the JSON document. Errors are shown by displaying erroneous text in red and flagging the location with a red exclamation mark. See Validating JSON Documents for more information.

 

The Validate on Edit mode can be toggled on/off either (i) via the XML | Validate on Edit menu command, (ii) the Validate on Edit toolbar button, or (iii) via the On Edit option of the Validation settings of the Options dialog.

 

 

© 2017-2023 Altova GmbH