Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting to Office 365 Sharepoint

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.

25 Replies
chrisbrain
Specialist II
Specialist II

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

Not applicable
Author

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
Specialist II
Specialist II

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?

Not applicable
Author

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

Not applicable
Author

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
Specialist II
Specialist II

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?

Not applicable
Author

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
Specialist II
Specialist II

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

ravireddyk
Contributor III
Contributor III

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,