How to extract information from an application published in Qlik Sense On premise by means of an Api

[mateo12]

Good afternoon to all,

I hope you are super well, at the moment I am facing a problem and is that I need to generate an extraction of specific information from an application that I have in a Qlik Sense On premise environment where the idea is to extract the information in a file with .json extension type is this possible?

Thank you in advance

Thank you very much

[JonnyPoole]

Try something like this.  It uses a folder connection to a folder that contains .json files. It will pick up top level attributes in the JSON payload.  JSON can have a lot of variability.  You may need to support arrays, child properties etc etc...  The approach below can work for very simple JSON files but it gets complex with more complicated JSON files. 

LOAD *
FROM [lib://JSONTEST/Task1json.txt]
(json, utf8);