topic How to extract information from an application published in Qlik Sense On premise by means of an Api in Integration, Extension & APIs

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

mateo12 — Tue, 02 Apr 2024 16:36:34 GMT

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

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

JonnyPoole — Tue, 02 Apr 2024 17:11:37 GMT

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);