Sharepoint Online - Can't access external source - External data source is unavailable because of an error.
I am trying to connect my Salesforce Org to Sharepoint Online (Office 365) I have followed the instruction for OpenId thru Azure (Winter 17) and I have manged to Aurtorise the External Data Source.
The issue I have is when I click on the Sharepoint Link on the files page I get the following error.
Or if I validate & sync the External Data Source I get the following error.
Can anyone help?
The Azure and Salesforce Auth Provide setup seems fine as I can authenticate.
A note for other users I had to change the following in https://help.salesforce.com/articleView?id=admin_files_connect_sp_online_auth.htm&type=5
Authorize Endpoint URL—Enter the URL as follows:https://login.microsoftonline.com/common/oauth2/authorize?prompt=consent&resource=https%3A%2F%2FYOUR_TENANT.sharepoint.com%2F
Authorize Endpoint URL—Enter the URL as follows:https://login.microsoftonline.com/common/oauth2/authorize?prompt=consent&resource=https://YOUR_TENANT.sharepoint.com%2F
I'm encountering the same error - did you resolve this?
I don't have an answer yet, I am currently working with Helpdesk to resolve.
I will provide an update once I have resolved the issue.
I personally would recommend using a 3rd party tool called Document Extractor to handle the SharePoint integration. As it guarantees forward compatibility with future versions, I think it is a good bet. You can find it in AppExchange and there is an article on it here https://www.connecting-software.com/blog/sharepoint-integration-with-salesforce/