how to pull data from URL which requires credentials

[montubhardwaj]

I am trying to fetch some information from one site (URL).Generally I have to logon with my credentials to view the information. When I tried to pull the information (using QV)from the site, it says as below:
"You are not authorized to view this page You do not have permission to view this directory or page"

I know that because it requires a USERID and PWD to get to the information. How can I get it done the same in QV?

[hectorgarcia]

Sure,

1) Download and install wget from http://www.gnu.org/software/wget/

2) create a QV application

3) include in teh script and execute line
should look like this

execute

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

where file is the name of the file you want to download and vpath is the destination folder where you want to store the downloaded file.

in the wget documentation you will find more parameters

Regrds

Hector

[montubhardwaj]

Yes. I am able to pull the data from URLs. All you have to do is, provide your userid and password in the url which you will write in qlikview.Example:

https://userid:password@xyz.com

If the url is related to your company or so, make sure you have access to login and view contents there.

Regards,

Sharma

[qlikviewforum]

Hi Hector

Is there is any way of doing the same without using the third party tool? Please let me know how that can be done!

Thanks,

Attitude

[qlikviewforum]

Erich Shiino wrote:

Hi,

If the website works like this, you can try a syntax like this:

http(s)://username:password@server/resource.ext

Will it work if I have @ in my password? . Also don't think this is secured way of passing the credentials. So let me know if there is any secured way of passing the credentails to sharepoint site.

[erichshiino]

Hi,

I got it from another website an I wasn't able to try it.

You should be able to replace your '@' for a hex code, like this:

user= myuser

pw=h@t

http(s)://myuser:h%40t@server/resource.ext

(replaced @ for %40)

Hope it helps,

Erich

[qlikviewforum]

Thanks! But sorry it didn't work out... Please share if you have any other alternative!

[qlikviewforum]

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

[#9]

Hi Erich,

I want to pull sharepoint data into qlikview which is having authentication.

Can you please help me how exactly we can pull it?

my link is "http://--.---.---.---.--/SitePages/SP_ListsDemo.aspx"

I saw so many posts on community but my problem is not yet resolved...

It will be graet if you can help me.

Thanks!

Regards,

Yojas

[hectorgarcia]

hi, since thera are many possibilities to access a protected internet page, i prefer to use this method because works with any URL

Hector

[#11]

Is this method also working for redirected login?

i need to pull data from html website but when i open the link in browser

im first redirected to our corporate login page and after entering my credentials im

immediately redirected to the original url!

In qlikview i have no chance to pull the data with the original url!

Any idea?