Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading data from a password protected website (Last FM)

Hi there,

I am trying to load data from my Last.FM  account.

Last.fm keeps track of the music I play.

I wrote a script that loops through the pages which works great, at least for the first 50 pages....

When I use the wizard I can see the table from page 1: http://www.last.fm/user/Dennisnet/tracks?page=1

Up to page 50 : http://www.last.fm/user/Dennisnet/tracks?page=50

But from page 51 : http://www.last.fm/user/Dennisnet/tracks?page=51
I get "Cannot open HTML file"

When I am logged on to my account on the website I can visit all pages
When I am not logged on to my account I can only access the first 50 pages.

At page 51 or higher I get : "Sorry you must be logged in to do that"

Is there a way to send a login and password with my load script?
Login to the website and saving my password (Chrome and IE) doesn't solve the problem.

Any suggestions?

Thanks,

Dennis.

1 Reply
disqr_rm
Partner - Specialist III
Partner - Specialist III

Try using wget or curl tool. Check here: http://community.qlik.com/message/122208#122208

QlikView will not be able to connect direcly, authenticate and load the data.