XMLSpy includes a revolutionary, first-of-its-kind JSON Viewer called JSON Grid. This JSON Viewer provides an easy-to-understand graphical view of your JSON file along with powerful editing features like automatic type detection, in-cell commands, XQuery filters for modifying the view, XQuery formulas for generating additional output from the JSON data, and more, all of which make viewing JSON faster and easier than a text-based JSON editor.
Check out this deeper dive into JSON Viewer for a more indepth look.
JSON View provides 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 Viewer 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:
JSON Grid View 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, the JSON Viewer auto-detects string, number, boolean, and null values as you type. Other types can be manually selected within the cell.
JSON Grid View 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.
If there is a JSON Schema associated with your JSON document, JSON View provides auto-completion based on that schema as you type, and data types are automatically determined based on the schema as well.
JSON Grid Filters and Formulas
XQuery filters and formulas in JSON Grid View 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.
It's also easy to view JSON documents in the XMLSpy JSON editor using text-based JSON viewer. You might find it useful to switch between JSON Text View and JSON Grid View. Both JSON viewer options help you understand the structure and content of the JSON file with line numbering, syntax coloring, source folding, and more.
The text-based JSON viewer 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. You can also take advantage of intelligent JSON editing tools.
Syntax checking and JSON validation in the JSON viewer guide you in making valid 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 JSON Schema, making trouble-shooting a breeze.
Unlike basic online tools, the XMLSpy JSON viewer provides myriad advanced features for working with JSON, letting you go way beyond simply viewing JSON file contents.
You can generate JSON files, convert between JSON and XML, edit JSON and JSON Schema, and even develop XSLT and XQuery for use with JSON. That's what makes XMLSpy the best JSON viewer available.
The JSON viewer download below is easy to install and available for a free, 30-day trial with no credit card required.