Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Partner - Specialist II
Partner - Specialist II

This doesn't look like a connector issue specifically. I have seen this issue solved by making sure the system clock is set correctly so maybe you could check this.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
ravireddyk
Contributor III
Contributor III

Brain,

Our Cloud server timings are set to UTC but not sure what timings need to be set.

Levi_Turner
Employee
Employee

From the case that I had with ravireddyk

Symptom: Unable to authenticate into the Office 365 Sharepoint and Google Driver connectors that were part of the Qlik Web Connectors

Log Signature: System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.

Root Cause: Dependency root certificates on the server not present

Resolution: Installed the relevant Trusted Root certificates on the Server: GeoTrust Global CA which was required by Google and the Baltimore Cybertrust Root certificate required by Sharepoint

chrisbrain

ravireddyk
Contributor III
Contributor III

Levi,

Thanks a lot for helping us solve this issue on certificates.

Thanks,
Ravinder

Anonymous
Not applicable
Author

Do you find what is the code?

kalyandg
Partner - Creator III
Partner - Creator III

Hi Ravi,

Your issue got fixed ? if Yes, tell me how did you fixed it? I am also facing the same kind of issue when running "GetFile"

There was an error running the table (status code = 500, Failed on attempt 1 to GET. (The remote server returned an error: (403) Forbidden.), HttpStatusCode: Forbidden, StatusCode: 403, StatusDescription: Forbidden, Message: The remote server returned an error: (403) Forbidden., ResponseBody: <?xml version="1.0" encoding="utf-8"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code>-2147024891, System.UnauthorizedAccessException</m:code><m:message xml:lang="en-US">Access denied. You do not have permission to perform this action or access this resource.</m:message></m:error>)

Thanks and Regards,

Kalyan