How to access ExportData URL via Qlik Engine API

arkham — Thu, 02 Nov 2023 16:42:41 GMT

Hello,

I have the following issue:

I wrote a python script to connect to the Qlik engine API via websocket to gather information about the content of a table and export it. The whole script is working and as a result I receive a qURL that I append to my server URL and get the final URL. After adding this URL into the browser, the browser is downloading the file. So far, so good.

Expected Outcome

I would like my script to access this URL and download the CSV file locally. But so far none of my attempts worked. Whenever I tried using the request module, a timeout was presented to me without any file.

Reading in another post, I learned one can't download that file through a websocket. You need to do an HTTP GET to download it. But for the HTTP GET you also need to send the session cookie of the websocket session.

So how can I catch the cookie from the header response of the websocket session? I checked

websocket.enableTrace(True) and was able to see the cookie put can't save it to a variable this way.

And even after getting the cookie, where should I send my GET request to, to access the file from the download?

Does anyone have a solid solution here? I just need the content of the file but I'm out of ideas and found only snippets to various attempts without solving this riddle.

Re: How to access ExportData URL via Qlik Engine API

ajaykakkar93 — Fri, 03 Nov 2023 07:38:39 GMT

Hi,

Simply you can generate a ticket via python or bat file using CRUL & get that file downloaded.

Re: How to access ExportData URL via Qlik Engine API

arkham — Fri, 03 Nov 2023 09:10:27 GMT

Hi,

Thanks for your reply. Which Qlik API do I need to use here? I never worked with tickets in Qlik before

Re: How to access ExportData URL via Qlik Engine API

ajaykakkar93 — Fri, 03 Nov 2023 09:23:06 GMT

API is called as QRS API which generates a session ticket for a user.

topic Re: How to access ExportData URL via Qlik Engine API in Integration, Extension & APIs

How to access ExportData URL via Qlik Engine API

Re: How to access ExportData URL via Qlik Engine API

Re: How to access ExportData URL via Qlik Engine API

Re: How to access ExportData URL via Qlik Engine API