XMLSpy includes a JSON Viewer and intelligent JSON Editor. With support for JSON, JSON5, JSON Lines, and JSON with Comments (JSONC) it allows you to view and edit JSON files using the same intuitive text code editor and grid / tree view that are available for XML editing, with useful editing guides and entry helpers. XMLSpy also makes it easy to convert XML to JSON or convert JSON to XML.
Unlike any other JSON editor, XMLSpy supports both JSON and XML, offering you an easy way to work with JSON data in the same environment where you're developing XML, AJAX, and Web services applications, giving you the best of both worlds.
XMLSpy also includes an easy to use, graphical JSON Schema editor for developing, validating, and generating JSON Schemas. To get started on JSON or JSON5 development, you can generate a sample JSON instance from any JSON Schema. Then, continue viewing and editing the JSON data in text or tree view as described below.
If you don't know where to get started and need to learn how to edit JSON files, the code completion and entry helpers in XMLSpy will help make it easy. The JSON file editor even ships with sample JSON documents and schemas.
The XMLSpy JSON Editor includes JSON Grid, which offers a graphical representation of the JSON document structure that is immediately easier to understand than the corresponding JSON code in text view, especially for long, complex documents with multiple nested levels of arrays and objects. JSON Grid also has powerful editing features including:
JSON Grid makes it easy to modify or reorganize the structure of the document using drag-and-drop. Active buttons in each cell provide shortcuts for the most common display, filtering, and editing tasks. During editing, these buttons make it fast to add a child item, change a type, toggle between table and list view, and so on.
For faster editing, JSON Grid auto-detects string, number, boolean, and null values as you type. Other types can be manually selected within the cell.
JSON Grid Editor has numerous easy-to-remember keyboard shortcuts to make editing as fast as possible, letting you continue typing without needing to use your mouse. A right-click context menu is also available so you can edit using your preferred approach.
When there is a JSON Schema associated with your JSON document, JSON Grid provides auto-completion based on that schema as you type, and data types are automatically determined based on the schema as well.
JSON Grid includes table view that groups data under the same array or object for easy understanding and quick editing, and you can toggle between the two displays, for instance:
XQuery filters and formulas in the JSON editor let you use XQuery 3.1 expressions to filter the components that are displayed in the view and calculate results that can be stored in the document.
Each table in JSON Grid includes a filter that lets you manipulate the display of object and arrays. For example, in the screenshot above, a filter has been applied to an array so that only those tracks written by Brian May are displayed. It's easy to toggle between filtered and unfiltered cells by clicking the filter icon. When you save the file, your filters are stored in metadata for later viewing purposes. They don’t affect the content of the document.
A formula enables you to generate output (nodesets as well as calculations) and to display the output in JSON Grid View. Below is an example using an XQuery formula to calculate the price of items. Clicking the save icon for the formula gives you the option to store the output of the formula in the JSON document. In this way, formulas in XMLSpy JSON Grid open an entirely new possibility: the ability to have dynamically computed content in JSON documents.
In addition to utilizing XQuery for formulas in JSON Grid, you can use it to create charts from numerical JSON data.
After configuring a chart function, the save icon embeds the chart in the file as a base-64 encoded image. Additionally, the developer can right-click on the chart in Grid View and save it in an image file such as .png or .jpg.
No other JSON editor offers anything even close to this functionality!
The text-based JSON file editor provides syntax coloring, line numbering, source folding, bookmarking, and more, making it easy to navigate and understand your JSON code, and find and edit strings. When you enable intelligent JSON editing on the JSON tab of the XMLSpy Info window, the Elements entry helper window provides a dynamically built list of the elements present in your JSON document. You can insert an element from the Elements window by double clicking it, or by dragging it into your document in the editing pane.
Syntax checking and JSON Schema-based validation in the JSON editor guide you in making valid JSON edits. Any errors are listed in the multi-tabbed Messages window, which also includes a hyperlink to the error in your document and the related schema, making trouble-shooting a breeze.
XMLSpy supports JSON and JSON5, providing full support for both versions of the standard for JSON editing. By default, XMLSpy recognizes files with the .json file extension as JSON instance documents, and those with the .json5 file extension as JSON5 instance documents. XMLSpy is a JSON editor for Windows.
The XMLSpy JSON editor also supports JSON Lines (JSONL) and JSON with Comments (JSONC) documents for editing and validation.
JSON Lines is a text format for storing structured data where each record is on its own line and each individual line is a valid JSON object. This allows records to be processed one at a time, which makes the format very useful for exporting and sending data.
The JSON with Comments format was introduced to allow comments in any JSON document. While comments are already supported in JSON5, the .JSONC format allows for comments in previous versions of JSON documents.
Converting XSD to JSON Schema is also supported.
Unlike basic online tools, the XMLSpy JSON editor download for Windows gives you all the advanced JSON tools described above, in one version. Takes just a few minutes to install the JSON editor software and start your free trial. There is no credit card required to activate your fully functional, 30-day trial.