topic Re: How to connect to third party website's API in QlikView

How to connect to third party website's API

saimahasan — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

My requirement is to connect to a third party website and fetch the data from that website in qlikview. Can anyone please help me how i can achieve this??

Re: How to connect to third party website's API

Frank_Hartmann — Tue, 19 Jul 2016 08:08:52 GMT

can you give more information? Do you need to Login?

Re: How to connect to third party website's API

Tue, 19 Jul 2016 08:11:33 GMT

You can capture live data from the web to excel, and then reload the excel in Qlik

Automated data scraping from websites into Excel - YouTube‌

Get external data from a Web page - Excel

Re: How to connect to third party website's API

saimahasan — Tue, 19 Jul 2016 08:11:38 GMT

Hi Frank,

I have a website's URL. I have data on that website which i could export in excel. But rather than exporting in excel i want to fetch the data directly from the website.

I suppose fetching directly from the website could be done through API.. right??

So i need to know how do i get the data from the API?

Re: How to connect to third party website's API

saimahasan — Tue, 19 Jul 2016 08:13:00 GMT

is there a way to get the data directly into qlikview without involving excel export??

Re: How to connect to third party website's API

Tue, 19 Jul 2016 08:22:39 GMT

I have not tested it, but I find a video which is related to this QlikView - Load Data From a Web Page - YouTube

Re: How to connect to third party website's API

Frank_Hartmann — Tue, 19 Jul 2016 08:26:22 GMT

Is the website password protected?

Re: How to connect to third party website's API

Anil_Babu_Samineni — Tue, 19 Jul 2016 08:41:25 GMT

Saima,

we have one third party web site. Like Cloud. They will help you to connect from diff page data

Re: How to connect to third party website's API

saimahasan — Tue, 19 Jul 2016 09:39:09 GMT

Can you please elaborate

Re: How to connect to third party website's API

saimahasan — Tue, 19 Jul 2016 09:39:29 GMT

Yes. it needs your credentials to connect

Re: How to connect to third party website's API

Frank_Hartmann — Tue, 19 Jul 2016 09:49:41 GMT

You could try to pass the credentials in the URL, see attached txt.

second possibilty might be to use wget:

1. Load wget from internet

2. Prepare Batchfile with custom information

3. Save batchfile in C:\Program Files (x86)\GnuWin32\bin\wget.exe or with universal batch somewhere in C:

3. Execute Batchfile

cmd.exe /c wget --http-user=XXXXXXXX--http-password=YYYYYYYY--no-check-certificate -E --output-document=$(file) $(vpath);

e.g

wget.exe --no-check-certificate -O d:\1.html--save-cookies=d:\cookies.txt--post-data="AccountName=your_login_here&Password=your_pass_here&action=doLogin&other_post_data_here"

4. Serch Output in: C:\Users\Admin\AppData\Local\VirtualStore\Program Files (x86)\GnuWin32\bin

5. Prepare your QV Script in order to get the infrmation/data in the specified folder updated

6. Thats it