Qlik JSON Reader

The Qlik JSON Reader allows FME to read QlikJSON (Qlik JavaScript Object Notation) documents.

Overview

QlikJSON allows users to import their data from Qlik Sense to FME. Qlik Sense users may use the Qlik Engine JSON API to extract their spatial data and import it into FME using the Qlik JSON reader. The extracted JSON document from the Qlik Engine will contain spatial data stored in identical fashion to the GeoJSON (Geographic JavaScript Object Notation) Reader/Writer format.

For more information about Qlik Sense, see the Qlik Help documentation.

Reader Overview

The Qlik JSON reader produces an FME feature type for each QlikJSON file. QlikJSON files are saved JSON responses from the Qlik Engine JSON API.

The general layout of the JSON file extracted from Qlik Sense is a generic object which contains a HyperCube. The HyperCube contains an array of spatial data stored in the GeoJSON format. The QlikJSON reader extracts this array of spatial data and transforms it into a list of spatial features.

Data Extraction

Extracting data from Qlik Sense requires a degree of understanding and knowledge on how data in Qlik Sense is stored and structured. At the top level, there is the global object which then contains a doc object, and that doc object will contain a number of AppObjects. For more information, please refer to the topic Generic Objects in Qlik Sense help documentation.

The data file can be extracted by executing commands using the Qlik Engine JSON API.

In the Qlik Engine JSON API, navigate to the list of generic objects and retrieve the generic object that contains the spatial data. The resulting JSON response then can be saved to a file and read into FME using the Qlik JSON reader.