Qlik Community

Connectivity & Data Prep

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics 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

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.

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

nestmartv
Contributor II
Contributor II

Do you find what is the code?

kalyandg
Partner
Partner

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