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.
