Visualize and analyse JSON APIs with Tableau

Tableau's user interface showing three line charts showing the reuse of the cores, fairings and payloads of SpaceX rockets. Starting in 2017 the reuse of cores and payloads is rising.

With REFORM and Tableau you can visualize your JSON APIs in minutes.

JSON APIs contain huge amounts of valuable data. You can find everything from call transcripts to meteorological data and from social media posts to banking data in JSON APIs. This way of accessing data is more commonly referred to as "REST APIs" and even just "APIs" as JSON is the modern standard for data. JSON owes this esteem to its numerous advantages such as how easily it maps to application and device data structures, compound documents and sparse fieldsets.

JSON is not a normal tabular data format. Unlike tabular data the structure of each piece of JSON is tailored to a specific purpose. For example a piece of JSON for a form about you and your pets would have a very different structure to a piece of JSON for a manufacturing dashboard. JSON APIs expects standard tabular data. In order to visualize JSON data and find insights we need to transform it into meaningful tables.

A screenshot of REFORM. The structure of a JSON dataset is presented as a filesystem which is being browsed and from which relational columns are being picked

REFORM lets you access JSON APIs as tables in Tableau for visualization and analysis. Simply provide the details of the API endpoints, browse even the most complex data as if it were a file browser and pick what you're interested in. Simply download the CSV from REFORM and access it with Tableau.

Tableau Partner

REFORM also supports situations where the data is too large to fit onto a single computer and situations where data needs to be analysed at scale. REFORM will stream your data directly into tables in AWS Redshift, Snowflake, AWS Athena, Google Big Query and MS SQL Server which support any size of dataset at scale and can easily be used as data sources by Tableau.