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]

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]

Brain,

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

[Levi_Turner]

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]

Levi,

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

Thanks,
Ravinder

[Anonymous]

Do you find what is the code?

[kalyandg]

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