Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Partner - Specialist II
Partner - Specialist II

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

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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
Partner - Specialist II
Partner - 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?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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
Partner - Specialist II
Partner - 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?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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
Partner - Specialist II
Partner - Specialist II

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

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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,