After configuring the configuration for the SharePoint Connector in Confluence, a 500 error is displayed in the Configuration Test Results at "Search Sites", "Search Lists" or "Search Documents":
...
| Info |
|---|
This problem could occur for SharePoint Online and SharePoint on-premise as well (For on-premise the screenshot looks a bit different). |
Usual Causes
The logged in user to SharePoint does not have at least read access to the SharePoint site collection in order to perform search queries on the SharePoint List macro configuration.
Can receive the following error that can be seen in the postquery when analyzing the network calls.
Code Block {"error":{"code":"-1, Microsoft.Office.Server.Search.REST.SearchServiceException","message":{"lang":"en-US","value":"The SafeQueryPropertiesTemplateUrl \"The SafeQueryPropertiesTemplateUrl "{0}" is not a valid URL.\" is not a valid URL."}}}
Grant admin consent was not performed when configuring API permissions in Azure. See the documentation here for more info.
The following errors can be seen in the postquery when analyzing the network calls.
Code Block "error":{"code":"-1, Microsoft.Office.Server.Search.REST.SearchServiceException","message": {"lang":"en-US","value":"The current principal does not have permission to execute queries on behalf of other users."}
...
For an investigation please provide our support with the following information:
...