Connecting to Office 365 Sharepoint

[#1]

Hello everyone,

I'm trying to load an excel document using the Office 365 sharepoint connector available within the qlik web connectors 2.2.0 but without success.

I entered the sharepoint base url then tried to Authenticate, but how should i get the authentication code?

The popup doesn't display anything, the client_id in the popup link doesn't work as a code neither.

Is there another way to connect (also some documents are not public, so they are accessible only for the logged in user)

stevedark‌

bal

chrisbrain

Appreciate getting your help.

[chrisbrain]

Hi - When you say the 'popup doesn't display anything' - what do you mean? Does a blank window open? Does nothing happen?

[#3]

Hi Chris,

The page that opens displays the attached image (pic1).

And if I click on my name, I'd get the pic2 (attached).

Should I extract the authentication code from the link?

Thanks.

[chrisbrain]

You shouldn't need to extract anything from the browser address bar (if that's what you are suggesting).

Can you not click on the name in pic2 to continue with the auth flow?

[#5]

Ok no problem

But can you please clarify how can I get the authentication code?

As nothing is happening in the web connector interface (image attached) nor in the opened popup.

Appreciate your help

[#6]

In your screen shot there is no Client ID. How did you remove the client id?

What is your connector version? mine is 0.8.6.19733

Thank you!

[chrisbrain]

Client ID has been removed from the latest version.

Jean-Pierre - Can you not click on the name in pic2 to continue with the auth flow?

[#8]

Chris,

Thanks for your follow-up.

I can assure you I am not clicking on anything

That's the url that's opened in the popup window:

https://login.microsoftonline.com/common/oauth2/authorize?client_id=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx...

Yesterday I tried taking the client_id part and use it as authentication code, but I was getting the below error:

An error occurred while trying to authenticate. (status code = 500, Invalid authentication code [1])

Vishnu,

That's the connector version 0.8.8.20138

It's found in the qlik web connectors 2.2.0.

Thanks

[chrisbrain]

I would like to do a quick screen share with you, but I can't figure out how to DM you.

[ravireddyk]

Hi Chris,

I am having some issues with connecting share point using QWC 220 office 365 SharePoint connector .below is the error I am getting.

There was an error running the table (status code = 500, Failed on attempt 1 to GET. (The remote server returned an error: (404) Not Found.), HttpStatusCode: NotFound, StatusCode: 404, StatusDescription: Not Found, Message: The remote server returned an error: (404) Not Found., ResponseBody: <?xml version="1.0" encoding="utf-8"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code>-2147024894, System.IO.FileNotFoundException</m:code><m:message xml:lang="en-US">File Not Found.</m:message></m:error>)

Can you please suggest.

Thanks,