Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extracting data from webpage

Hi,

I am trying to extract the data from the webpage i am getting the error as not aurthorized to access.I understood the actual problem is Internet is accessed based on credentials and the data in the webpage also accessed through passing the credentials.

(a)Websites are accessed by providing the username and Password.

(b)Data in the website are accessed by logining in to the specific website.

How the same can be implemented. Please suggest.

24 Replies
mr_ramshini
Contributor III
Contributor III

Hi

Can you help me

i want get data of website and show them in my qlik view file automatically after run the file

But i don't know to do it

mr_ramshini
Contributor III
Contributor III

Hi

Can you help me

i want get data of website and show them in my qlik view file automatically after run the file

But i don't know to do it

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

It can be as simple as this:

LOAD

  *

FROM

[http://en.wikipedia.org/wiki/List_of_countries_by_population]

(html, codepage is 1252, embedded labels, table is @1);

It can get more complicated if the data are not in a sensible table, or if a password is involved.

If the latter is the case then you may want to look at the REST connector on Qlik Market.


Steve

rahulsingh12
Contributor III
Contributor III

Hi,

Were you then able to download the data from a website with a password??

If yes then can you share the steps and batch file code you used ??

 

Regards,

Rahul

 

rahulsingh12
Contributor III
Contributor III

Hi,

Were you then able to download the data from a website with a password??

If yes then can you share the steps and batch file code you used ??

Regards,

Rahul