topic Websource probleme in QlikView

Websource probleme

Wed, 25 Nov 2020 16:16:04 GMT

Hello QV Community,

Im trying to connect QV with the following data source (webadress) :

https://XXXXXXXXXXXXXX/report/aftersales/report_weekly.html

When I open the page in browser i am getting referred to our Corporate Login Page:

https://XXXXXXXXXXXXXX/internal/login?TYPE=3324323&REALMOID=06-d8fb72-4ebf-110c-f120fb1e&GUID=&SMAUTHREASON=0&METHOD=GET&SMAGENTNAME=$SM$%2f3XwsaYZTeZVpBIm93i8EeXe3H4r0%2beiJ%2bFRxRGPfDKDZmLYB6a4nnwDq%2f8luA3&TARGET=$SM$https%3a%2f%2fXXXXXXXXXXXXXXXXXXXXX%2freport%2faftersales%2freport_weekly%2ehtml

and after filling in my credentials i am instantly redirected to the wished Page.

But in QV im not reaching the data!

Heard about using Qlik Rest Connector but I have no clue how to handle the connector!

Can anybody give some hint or example how to use the connector in my case? Or is there another way getting the data connected to QV?

Thanks for helping!

Susan

Re: Websource probleme

Fri, 13 May 2016 06:24:27 GMT

Any ideas?

Every hint will be appreciated

Re: Websource probleme

Anonymous — Tue, 17 May 2016 05:06:48 GMT

The REST Connector is designed for connecting to a REST interface, not a standard web page.

You could try appending your credentials to the original URL and test this in a browser that is not already logged in.

eg ...report/aftersales/report_weekly.html?userName=SomeUser&password=somePassword

But it may be "login" or "user" instead of "userName"

If this works and takes you straight to the report then you can use this in the REST connector.

You would have the base URL then parameters would be userName and password with their values.

Better still if there is a real API for this reporting software then you need to get the guide for it. Then you may be able to specify the report name and report parameters through the connector.

Hope that this helps - without a published API it's the best I can do.

Re: Websource probleme

Anonymous — Tue, 17 May 2016 05:17:28 GMT

Actually, looking at your final URL, you could parse this in the REST connector as follows.

But chances are that some of these parameters are specific to the original login and can't be reused. There may be a re-usable token that you can generate and use instead of a login.

Re: Websource probleme

Wed, 18 May 2016 10:30:26 GMT

Thank u very much for answering.

I will give it try tomorrow !