JSON Tools

JSON Tools

Flexible Tools for Editing, Generating, Transforming, and Converting JSON

JSON (JavaScript Orientation Notation) is a light-weight, text-based, open standard for data interchange. JSON is often used for serializing and transmitting structured data over a network connection and therefore is commonly used in AJAX and Web services applications.

Though there has been an ongoing debate about XML vs. JSON, the conclusion is that each technology is appropriate in different situations. That’s why it’s important to choose development tools that support both.

Altova provides support for both JSON and JSON across the product line, including editing and generation of JSON instances and JSON Schemas, any-to-any data mapping, and high-performance JSON validation.

Edit and Generate JSON, JSON5, and JSON Schema

JSON Schema Editor

Graphical JSON Schema Editor

Like XSD, the structure of JSON Schema lends itself to visual editing. Following the same, graphical schema editing paradigm pioneered by the XML Schema editor, the JSON Schema editor in XMLSpy allows visual, drag and drop editing with intelligent entry helpers. This makes JSON Schema development much easier, compared to working in a text only view.

And, you don’t have to start from scratch to create a JSON Schema - XMLSpy will generate one from any existing XML Schema, greatly speeding development time.

Validation against the JSON Schema spec is also provided.

Finally, JSON Schema support is rounded out with complete, automated documentation generation in HTML, PDF, or RTF formats.

JSON Editor

JSON editor and JSON5 editor

The JSON editor in XMLSpy supports both JSON and JSON5.

Editing, syntax checking, and validation of JSON instances is also supported in XMLSpy in text view and the graphical grid view. Entry helpers provide relevant choices as you work, and you can even convert an existing XML document to a JSON document, and vice versa – all with one click.

Query and Transform JSON

Process JSON with XSLT and XQuery in XMLSpy

XMLSpy makes it easy to take advantage of functionality added to XPath/XQuery 3.1 that provides an elegant, standardized way to query and transform JSON data using these familiar languages.

The intelligent XSLT and XQuery editors, as well as the interactive XPath/XQuery Builder & Evaluator Window, provide full sopport for processing JSON documents.

JSON Data Mapping, Conversion, and Integration

Convert JSON data

When more complex or recurrent JSON data mapping is required, MapForce is the tool for the job. An any-to-any data transformation tool, MapForce supports JSON as both an input and output data format, allowing you to map JSON to and from:

  • XML
  • Databases
  • Flat files
  • EDI
  • XBRL
  • Web services
  • Excel

Simply load data sources and targets, and drag and drop to define data mappings, filters, and processing functions. View and save output immediately, or automate the transformation via MapForce Server.

Read a real-world JSON data mapping use case.

Mobile Apps and JSON

Building a mobile app that consumes JSON data

The advantages of JSON’s small footprint make it well suited as a back end data format for mobile apps, where it’s important to transfer the smallest amount of data possible to deliver optimal performance.

When building your mobile app in MobileTogether, you can utilize JSON either loaded directly from a file or consumed via a REST web service or via an HTTP or FTP request.

High Performance JSON Validation

When you need to process a large volume of JSON data, RaptorXML Server offers hyper-performance validation of JSON, JSON5, and JSON Schema.

Features for developers include including error reporting, .NET and Python APIs, and more, and you can even integrate an installed RaptorXML Server with XMLSpy for server processing speeds inside the editor.