topic Re: download Zip file from Web in qlik in QlikView

download Zip file from Web in qlik

rupalimane1390 — Sat, 16 Nov 2024 18:13:53 GMT

Hello All,

Is it possible to download zip file from website in Qlikview?

It is not possible using web connectors as I tried. Please help if we have execute commands or can make use of macros to download zip files from website.

Thank you.

Re: download Zip file from Web in qlik

cwolf — Thu, 13 Aug 2020 10:53:32 GMT

With macro:

function DownloadFile(url,localFile) Set xHttp = createobject("MSXML2.XMLHTTP.6.0") Set bStrm = createobject("Adodb.Stream") xHttp.Open "GET", url , False xHttp.Send with bStrm .type = 1 '//binary .open .write xHttp.responseBody .savetofile localFile, 2 '//overwrite end with DownloadFile="ok" end function

Calling from script:

let df=DownloadFile('https://ayera.dl.sourceforge.net/project/qmsedx/12.50/qmsedx_12.50.0.zip','c:\temp\qmsedx_12.50.0.zip');

Re: download Zip file from Web in qlik

rupalimane1390 — Thu, 13 Aug 2020 11:56:01 GMT

Thank you so much for your reply.

Will try this.

Re: download Zip file from Web in qlik

rupalimane1390 — Wed, 02 Sep 2020 12:40:42 GMT

Thanks a ton @cwolf. It worked 🙂