Re: Extracting data from webpage - Page 2 - Qlik Community

Report Inappropriate Content · ‎2011-04-14

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.

stevedark · ‎2012-07-17

There certainly are issues with opening web-pages with security on them, as there is no way of passing credentials in when making the call.

Youl could perhaps build a wrapper page in IIS that pulls down the page after passing in credentials that is then not secured with a username and password - but is only accessable to the IP address that your QlikView app is being reloaded on. This is not a particularly direct route though.

There are a number of articles on QlikCommunity relating to this - and you may be able to find a solution in the forums.

Hope that helps.

Steve

alec1982 · ‎2012-07-26

I have created a batch file to open IE then add the credential and log in.

I added the batch file as a supporting task to the publisher and run the application on a success of this task.

it seems to work just fine!.

stevedark · ‎2012-07-26

Nice! QlikView is obviously using part of the IE engine when it makes the call. Publisher is then carrying out all of its tasks in the same process. It should be possible to do the IE part in a QlikView macro and then trigger the reload from the same macro - so the same functionality could be gained without Publisher.

Could you perhaps post up the batch file, or the code from in the batch file - with the credentials removed, of course.

Regards,

Steve

qlikviewforum · ‎2012-08-28

Given link is not working!

qlikviewforum · ‎2012-08-28

Given link is not working!

qlikviewforum · ‎2012-08-28

Hi Alec

Could you post up the batch file, or the code from in the batch file - with the credentials removed, of course. It will help us as I am working on the same.

Thanks,

qlikviewforum

qlikviewforum · ‎2012-08-28

Thanks for the nice video. But in our case the website/sharepoint needs authentication to view the page. Please share the video if the same is possible.

subin6600 · ‎2012-08-28

Hi Alec1982,

Could you please attach the batch file? That would be helpful for many of us here struggling to get the data read into Qlikview from sharepoint sites.

Regards,

Subin Thomas

qlikviewforum · ‎2012-08-29

Hi Alec

Please share the batch file with us!

Thanks,

qlikviewforum

qlikviewforum · ‎2012-08-31

Hi All,

I tried my level best but unfortunately couldn't able to succeed yet.

I read some where about QVSource. Is it possible to load the data from secured sharepoint site using the same? Any help please?

Thanks,

qlikviewforum