Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Ajeeth11
New Contributor II

load local json file to qlik sense

Hi All,

I have a requirement that i need to pull  local JSON file to qlik sense desktop.

But that JSON file is in nested structure. So i can't fetch the records from file. please he

Can you please give suggestions for  fetching all records from JSON file?

Thanks,

Ajeeth

 

 

Tags (2)
Labels (2)
3 Replies
MVP & Luminary
MVP & Luminary

Re: load local json file to qlik sense

I think you'd have to install a local webserver so you can access it with QS as a web document. A local file won't work if the json file has a nested structure like you indicate.


talk is cheap, supply exceeds demand
Highlighted
Ajeeth11
New Contributor II

Re: load local json file to qlik sense

Thanks for your response. Still, I am not clear about local webserver. Could you please suggest the local webserver name to be installed and next process.

One more doubt. Why QS works for simple local json file but not for nested json? Please help me out.
MVP & Luminary
MVP & Luminary

Re: load local json file to qlik sense

Could be anything. Perhaps you already have node or python installed. Then you could use that.
Simple local json files work because of an undocumented feature: https://community.qlik.com/t5/Qlik-Sense-Data-Connectivity/Is-it-possible-to-load-de-local-JSON-file...


talk is cheap, supply exceeds demand