topic Re: Automatic login in Sharepoint 365 in QlikView

Automatic login in Sharepoint 365

Thu, 13 Jul 2017 18:16:19 GMT

Hi everyone!

I am trying to retrieve data from a Sharepoint 365 list into QlikView, and Sharepoint ask me for a login before let me get the data. So in this case, I have to select "Open URL" from the file menu, put the Sharepoint URL, log me in the site (using the embedded browser in the QlikView Environment), and then yes, I can get the data.

The fact is that I have to schedule this reload to be executed automatically, so Qlikview should make the login process by itself and then load the data.

I was trying with a vbScript that perform the process automatically, this process run and logged in to Sharepoint successfully, but this login is not recognized by Qlikvew reload process, only works if I make the login process manually through "Open URL" option.

I tried using:

Set objIE = CreateObject("InternetExplorer.Application.1")

Call objIE.Navigate URL

Does anyone have any idea to do this? Does anyone know if there is a way to execute the exact "Open URL" option with a macro?

Thanks and let me know if you need any additional information.

Regards.

Re: Automatic login in Sharepoint 365

Anil_Babu_Samineni — Fri, 14 Jul 2017 02:27:00 GMT

Hello Guzman,

When you use Reload the script automatically by using macro. This will fetch data automatically

Sub ReloadDoc

ActiveDocument.Reload

ActiveDocument.Save

End sub

Re: Automatic login in Sharepoint 365

Fri, 14 Jul 2017 15:01:33 GMT

Hello Anil, thanks for your answer.

Yes, I tried with that, but then of to make the login process and wait some seconds to be sure that the user is really logged in, the reload fails because it continues not recognizing the login.

Do you have any other idea to try?

Thanks again.

Regards.

Re: Automatic login in Sharepoint 365

aarkay29 — Thu, 19 Jul 2018 19:09:36 GMT

Any luck??