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?
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.
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...