Error while Testing SharePoint Connector

[abdullah_1]

Symptoms 

• Testing connection to SharePoint is failing with the following error:  

• The error above seems to be a response from SharePoint which indicates that we are getting a response from the SharePoint end but this is not the case as even the registration steps were followed as per below link we are still receiving the same error messages:  
  • https://docs.incorta.com/latest/references-security-oauth-sharepoint  

Diagnosis

From the analytics tenant logs we see the below error messages while testing the connection of the SharePoint external data source:  

Testing SharePoint Connection... [com.incorta.connector.sharepoint.SharePointClient.test]  
DEBUG:Query not successful! [com.incorta.connector.sharepoint.SharePointClient.getHttpResponse] 
DEBUG: Parsing response... [com.incorta.connector.sharepoint.SharePointClient.readResponseContent] 
DEBUG: Parsing response succeeded... [com.incorta.connector.sharepoint.SharePointClient.readResponseContent] 
ERROR:  The Server Status Response: 404 
ERROR:  404 FILE NOT FOUND 
ERROR: [com.incorta.connector.sharepoint.SharePointClient.getHttpResponse] 
ERROR:  Failed to test connection:  [com.incorta.connector.sharepoint.SharePointConnector.testConnection] 
ERROR:  dev.failsafe.FailsafeException: com.incorta.connector.errors.GeneralConnectorException: The Server Status Response: 404 
404 FILE NOT FOUND 
[com.incorta.connector.sharepoint.SharePointConnector.testConnection] ​

Or 

Parsing response succeeded... [com.incorta.connector.sharepoint.SharePointClient.readResponseContent] 
ERROR:  The Server Status Response: 404 
ERROR:  404 FILE NOT FOUND 
ERROR:  [com.incorta.connector.sharepoint.SharePointClient.getHttpResponse] 
ERROR:  Failed to test connection:  [com.incorta.connector.sharepoint.SharePointConnector.testConnection] 
ERROR:dev.failsafe.FailsafeException: com.incorta.connector.errors.GeneralConnectorException: The Server Status Response: 404 
404 FILE NOT FOUND 
[com.incorta.connector.sharepoint.SharePointConnector.testConnection] 

Issue cause:  

•  The customer is using Microsoft Azure entraid  which is not currently supported in the SharePoint Connector.  

 Resolution:  

• A New Custom SharePoint connector version 2.2.1.502031831 was created by our development team through this Jira: https://incorta.atlassian.net/browse/INC-86482  
• The New custom version was provided to the customer through the Marketplace, and below are the steps to install:  
  • Marketplace → Connectors → Sharepoint → Install → Custom Version → 2.2.1.502031831  
• Also attached is a PDF for instructions regarding the Azure App. 
• Please, make sure that the redirect URL from the SharePoint side is the same as the one in the incorta unified.oauth.redirect.uri property in the node/services. 
• So in our case, it was https://cloud.incorta.com/api/gdrive from SharePoint as well. 
• This resulted in the SharePoint connector being created successfully and authorized without error.