JSON and XML Editor

XML Editor

XMLSpy abstracts away the complexity of editing XML and related technologies through its intuitive user interface and rich variety of views and options. Whether you prefer to edit XML documents in a text-based or graphical XML viewer, XMLSpy provides intelligent guidance and entry-helpers as you type, and troubleshooting is fast and easy with the industry's most standards-conformant XML validator.

XML Grid View displays the XML document structure using a set of nested containers that reflects its hierarchical structure. It also includes table view that rearranges repeating elements in a table for easy viewing and sorting. By default, XML Grid View uses attributes and child elements for the columns, and shows repeating XML element as row - but you can flip rows and columns to adapt the display based on the type of data the file.

XML Grid makes XML editing faster and more powerful than when using a text editor alone. Advanced features include:

XML Grid will revolutionize the way you edit XML documents. Take a look at this quick video demo.

As you work, XMLSpy provides Smart Fix XML validation, a process that detects errors - and then enumerates the possible corrections for fixing them, which you can choose to implement in your XML document with one click. That's right - XMLSpy will make the corrections automatically, based on your selection. Because the XML validator can make the corrections automatically, it saves you significant time and frustration associated with resolving validation issues.

JSON Tools

XMLSpy includes an intuitive JSON viewer and JSON editor with support for JSON, JSON5, JSON Lines, and JSON Comments, allowing you to view and edit JSON files using the same intuitive Text and Grid Views available for XML editing, with useful editing guides and entry helpers. The JSON editor provides:

A revolutionary, first-of-its-kind JSON editing environment is provided by XMLSpy JSON Grid View. JSON Grid 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. Advanced features such as automatic type detection, in-cell commands, XQuery filters for modifying the view, XQuery formulas for generating additional output from the JSON data, and more, combine to make JSON editing faster and easier than a text-based JSON editor. JSON Grid even allows you to create charts from JSON data.

In addition to utilizing XQuery for filters and 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 JSON file as a base-64 encoded image. Or, simply right-click on the chart to save it in an image file such as .png or .jpg.

No other JSON editor offers anything even close to this functionality!

Just as XMLSpy pioneered the first graphical XML Schema editor, it now also includes the first enterprise-grade, graphical JSON Schema editor to greatly speed schema generation, development, and validation for developers working with JSON.

JSON Schema View will be immediately familiar to XMLSpy customers who’ve used XML Schema View and are now learning to design JSON Schemas, while at the same time being easy to comprehend for new users. Use the JSON Schema editor for:

The JSON Schema editor supports BSON (binary JSON) datatypes used in NoSQL databases such as MongoDB.

Despite the growing popularity of JSON, there isn't a widely used language for querying and transforming JSON data. Luckily, functionality added to XPath/XQuery 3.1 provides a means for targeting JSON maps, arrays, and objects, offering a standardized way to query and transform JSON data using these familiar languages.

XMLSpy makes it easy to process JSON documents with XPath, XSLT, and XQuery using intelligent editors and the interactive XPath/XQuery Builder & Evaluator Window. Functionality includes:

XSL and XSLT Tools

The JSON and XML Editor provides complete support for XSL and XSLT development in its XSLT editor with context-sensitive entry helpers, an XSL outline window, and more.

For transformation, seamless integration with installed RaptorXML Servers delivers hyper-performance functionality coupled with strict conformance to W3C standards, including XSLT, XPath, and XQuery versions 1.0, 2.0, and 3.1. This allows you to take advantage of super-fast transformations during development and testing, all directly inside XMLSpy.

XMLSpy even includes intelligent HTML and CSS editors along with an integrated browser view.

Testing and perfecting XSLT stylesheets can be a complicated, time-consuming process. With the XMLSpy XSLT debugger, you can step through and debug even the most intricate stylesheets quickly and easily. Support for XSLT 1.0, XSLT 2.0, and XSLT 3.0 is provided, and you can even debug stylesheets that contain program code in Java, C#, JavaScript, or VBScript.

The XMLSpy XSLT profiler is an invaluable tool for optimizing the performance of your XSLT code. Based on the information revealed by the XSLT profiler, you can immediately see which parts of your XSLT code are taking the most time to process and adjust them accordingly to fully optimize your XSLT stylesheets.

The XSLT profiler delivers important information for expert XSLT developers, but if you want to speed up XSLT execution time without manually changing your XSLT and XPath code, try the XSL Speed Optimizer.

The XSL Speed Optimizer in XMLSpy is a revolutionary, patented approach to speeding up XSLT transformations, providing tremendous increases in throughput with no manual analysis required to determine exactly which XSLT or XPath expressions are causing bottlenecks.

Because XSLT and XQuery documents are frequently long and complex, it can be difficult to identify the source of unintended output. For targeted debugging, back-mapping makes it easy to immediately correlate output elements to source nodes and instructions.

With back-mapping enabled, XSLT transformations and XQuery executions are carried out so that the result document can be mapped back on to the originating XSLT+XML or XQuery+XML documents. When you click on a node in the result document, the XSLT instruction and the XML source data that generated that particular result node will be highlighted.

Back-mapping in XMLSpy is revolutionary in two ways. First, it saves developers considerable time in debugging, refining, and perfecting their code as well as understanding inherited code written by other team members. Second, XMLSpy does not make any changes or add additional code to the output document in order to achieve back-mapping.

XBRL Tools

Altova provides comprehensive support for end-to-end XBRL development and report generation, from taxonomy editing in XMLSpy, to high-performance validation on RaptorXML Server, to data mapping and analysis in MapForce, to multi-channel report generation StyleVision.

The XMLSpy XBRL taxonomy editor provides a graphical view of XBRL taxonomies and intelligent taxonomy editing features.

By organizing different components on easy-to-filter tabs and providing informative icons, mouseover messages, detail windows, and context-sensitive entry helpers, the XMLSpy XBRL taxonomy editor makes it easy to both view and understand existing taxonomies, and create new ones by way of extending industry-standard taxonomies.

It even includes the handy XBRL Taxonomy Wizard to give you a head start when extending or creating a new XBRL taxonomy.

XBRL editing features include:

The XULE processor and validator in XMLSpy processes XULE expressions against an XBRL instance document, as well as providing validation of XULE documents for correct syntax according to the XULE spec.

XMLSpy includes the industry’s first interactive XULE editor. XULE editing is supported both in Text View and a specialized XULE window, shown above. Both editing views guide users with syntax help, code completion, and other helpful features that make it easy to write and test XULE expressions. As you work, auto completion values are based both on XULE syntax and the structure of the selected XBRL taxonomy, if applicable. Learn more about the powerful XULE editor.

OIM (Open Information Model) provides a syntax-independent model for XBRL data to be transformed into other formats such as CSV and JSON. Though XBRL provides an efficient, standards-based representation of business report data, such data is often stored and/or consumed in other formats. OIM is an abstraction layer that decouples XBRL from the underlying XML syntax: this way, organizations can take advantage of the functionality of XBRL and at the same time have XBRL documents written in JSON and/or CSV.

XMLSpy is one of the very first XBRL tools to support OIM with support for validation of reports in XML, JSON, and CSV, as well as one-click conversion between those formats.

Database Integration

Powerful relational database integration in XMLSpy helps reduce interoperability challenges by allowing you to easily query SQL databases and convert back and forth between databases and XML files.

XMLSpy interacts with the most popular relational databases in their native interface language, including:

Database integration functionality includes:

YAML Editor

XMLSpy includes integrated support for working with YAML alongside XML and JSON, including a YAML editor, validator, and converter.