The Only JSON Dev Tool You’ll Need

The popularity of JSON is ever-increasing, and XMLSpy is keeping pace. Over the past few product releases, we’ve added intelligent functionality for editing and converting JSON data to the product. Most recently, we’ve completed the circle with one-click conversion between XML Schemas and JSON Schemas, as well as sample instance generation and JSON Schema documentation generation.

Let’s walk through some common examples demonstrating this functionality – and see how these time-saving tools make XMLSpy the only JSON development tool you’ll need.

JSON Dev Tools

Read more…

Tags: , , , ,

JSON Data Mapping and Transformation with MapForce

JSON is a popular format for transferring data between systems thanks to its simple markup, small footprint, and heritage based on the JavaScript programming language. MapForce supports JSON as both an input and output format for JSON data mapping and transformation. For instance, MapForce can extract information from any popular database and produce a JSON file ready for transfer.
The Requirement: Here is an example of a typical need for JSON data mapping: A manufacturing company controls costs by exploiting a just-in-time assembly process with very little parts inventory on hand. New customer orders are logged in a sales database, and at the end of every day the components needed to assemble that day’s sales are tabulated via a query into the database. The required parts will be ordered from suppliers via a purchase order transferred in JSON format.

Read more…

Tags: , , ,

Working with Avro Big Data in Your Favorite XML Editor

With every release, we add support in XMLSpy for technologies that developers encounter everyday – even when they’re not XML-based.

Today, Big Data trends have developers working with XML alongside other data protocols such as JSON and Apache Avro, and XMLSpy supports both of these with dedicated editing views and functionality.

Let’s see how specialized Avro support in XMLSpy makes visualizing and searching Avro files, as well as editing Avro schemas, uniquely easy. We’ll also look at some of the advantages of utilizing RaptorXML Server for high-performance Avro processing.


Read more…

Tags: , , , , , ,

Financial Analysis of XBRL Corporate Filings on Mobile Devices

In a previous blog post we’ve described some of the problems that are encountered when processing corporate filings from the SEC’s EDGAR database  in XBRL. Today we present a system that overcomes these issues by downloading and processing XBRL filings on a daily basis, normalizing the financial data, computing common financial ratios, storing all data into a SQLite database, and then presenting the corporate reporting data for financial analysis through a mobile app for iOS, Android, and Windows Phone.

We are making all the sources for the data ingestion and normalization process available as Python scripts on GitHub under an Apache 2.0 license. The actual normalization rules as well as the financial ratios being computed are defined in external JSON files that can easily be modified without the need to edit the Python sources. In addition the MobileTogether Design file describing the mobile app is also available as open source in the same repository on GitHub so the mobile application can be easily customized as well to graph different data, show other financial ratios, or do more sophisticated financial analysis.

SECdb Process Diagram


Read more…

Tags: , , , , , , , , , , ,

Why You Need a Graphical JSON Schema Editor

The advantages of JSON as a lightweight, interoperable data format have secured its place as the favored mechanism for serializing and transporting data on the web. However, most applications still benefit from or require validation of client-submitted data. Enter the JSON Schema spec, which lets you describe the structure of JSON data for a particular application, for both documentation and validation purposes.

Though JSON Schema code is by design human-readable, building a complex schema with nested and repeating sections in a text-only editor becomes time consuming and error-prone quickly.

There are several reasons why an enterprise-grade, graphical JSON Schema editor is an asset for developers:

  • Graphical view and intelligent entry helpers speed development
  • Those new to JSON Schema can rapidly build a schema using the graphical view
  • Allows incremental data modeling by which you generate a JSON Schema based on an existing JSON instance
  • XML to JSON conversion makes it easy to move between formats as required

Let’s look at each of these ideas more closely and see how they’re implemented in XMLSpy.


JSON Schema Editor in XMLSpy

Read more…

Tags: , , ,

New JSON Schema Editor and Data Mapping Debugger Debut in Altova Version 2016

We are excited to announce details of the latest release of Altova MissionKit desktop developer tools and server software products. Version 2016 includes full Windows 10 compatibility and updated relational database support across the product line, and it also introduces some new features that you simply will not find anywhere else.

XMLSpy 2016 includes the first full featured, enterprise-grade graphical JSON Schema editor. MapForce, our data integration tool, now includes a data mapping debugger that will revolutionize the way you define and test data mapping projects. Let’s take a closer look at these new features.


Altova Version 2016

Read more…

Tags: , , , , ,

Editing, Converting, and Generating JSON

As the use of JSON as a data transport protocol increases, I thought it would be useful to take a look at JSON support in XMLSpy. There’s been much debate about advantages of JSON vs. XML, but when you boil it down, there are simply some cases for which JSON is the best choice, and others where XML makes more sense. This article on the XML Aficionado blog unpacks this topic quite well.
While you might need to choose between JSON and XML depending on the development task at hand, you don’t have to choose between code editors – XMLSpy supports both technologies and will even convert between the two. Let’s take a look at how that works.
Editing JSON
To make JSON editing as easy as possible, Altova extended its intelligent XML editing features to the JSON editor. If you choose to edit JSON in text view, XMLSpy helps you along with syntax coloring, bracket matching, source folding, entry helper windows and menus, and so on.


Here’s that same JSON file in grid view, which offers a graphical representation of the JSON structure with drag and drop editing. Both views provide JSON syntax checking and advanced error checking features.


Another common requirement is converting XML to/from JSON, which is a one-click option on the XMLSpy convert menu. The JSON data above has been converted to valid XML:


Having JSON editing and conversion functionality directly inside the XML editor is quite useful, especially if you’re using the free Eclipse or Visual Studio integration package.
Check it out and let us know what you think.

Tags: , ,