Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
saimahasan
Partner - Creator III
Partner - Creator III

How to connect to third party website's API

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??

10 Replies
Frank_Hartmann
Master II
Master II

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

eg

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