topic Connect to http:// with login in QlikView

Connect to http:// with login

Fri, 03 Sep 2010 19:05:02 GMT

Hello!

I am accessing a file .csv directly into a Web address and doing the reading with success! The problem is that before I need log into the site to have access. Obviously I can connect directly via "Open URL". But I would like to create a connection in the area of scrip with the command "Connect to" ... or something similar. Is it possible? Any help is welcome!

Thanks!
Stive - Brasil

Connect to http:// with login

suniljain — Fri, 29 Apr 2011 09:53:38 GMT

if you get any solution pls share

Connect to http:// with login

Fri, 29 Apr 2011 10:47:06 GMT

I have just some ideas, because I had this type of problem.

If you are Ok with just http authentication, you can log-in via Url. When specifying the adress use login info like "http://username:password@yourserver.com/someTable.xml". This does work.

If you are also programming the web, where you are connecting, you can use some generated session ID, which you can obtain via http request and then use it, when connecting to the table. But you can use only GET params. QV cannot store any cookies, it is not a browser.

Or you can write your own app and then pass datastream to QV via new format QVX:).

Tomas