Is it possible to load de local JSON file into Sense?

amien — Mon, 13 Mar 2017 22:12:33 GMT

Using the rest connector it works fine to connect to a remote JSON file .. but is it also possible to connect to a local JSON file using the REST connector?

i also tried to upload the json file in the "Content Library". But i get an error when i try to connect.

Re: Is it possible to load de local JSON file into Sense?

petter — Sat, 12 Aug 2017 20:56:25 GMT

Actually with the latest Qlik Sense (3.2 or later) and QlikView versions (12.10 SR3 or SR3 I think) it is possible to read JSON from a local file via the regular LOAD .... FROM .... statement. It is not documented very well and the dialog boxes does not list JSON as a file format that is supported.

The syntax is like this:

LOAD * FROM C:\DATA\aJSONfile.json (JSON, utf8);

The JSON file must be an array of JSON objects like for instance this:

[

{"firstname":"Alice","lastname":"Anderson"} ,

{"firstname":"Bernie","lastname":"Ballard"} ,

{"firstname":"Donnie","lastname":"Duggard"}

]

I attached both a QlikView and a Qlik Sense application to demonstrate how it works with some simple JSON files.

This feature does not support nested JSON only a straightforward flat JSON table structure.

topic Re: Is it possible to load de local JSON file into Sense? in Connectivity & Data Prep

Is it possible to load de local JSON file into Sense?

Re: Is it possible to load de local JSON file into Sense?