Posts

Support for JSON5 in Altova MissionKit, Server Products, and MobileTogether


Altova products have supported JSON for several years. Now, Version 2017 Release 3 of MissionKit and Server products, and MobileTogether Version 3.2 all include support for JSON5 across the product line.

The JSON data format was originally designed to be machine-written and consumed, promoting efficient communication between servers. Usage has expanded and JSON5 is a proposed extension intended to make JSON code easier for humans to write and read.  JSON5 extends JSON by adding some ECMAScript 5 features and, like JSON, is a strict subset of JavaScript. Specifically, JSON5 permits inline and block comments, allows long strings to be split over several lines, and defines alternate legal syntax options for quotes and commas.  These features are not permitted in standard JSON, so files containing the proposed enhancements are typically identified with the .json5 filename suffix.

This post details specific support for JSON5 in each Altova product.

Learn about JSON5 support in Altova tools

Read more…

Tags: , , , , , ,

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 and JSON5 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.

shutterstock_88166515

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: , , , , ,