Troubleshoot the SharePoint Online list connector in Azure Data Factory and Azure Synapse

APPLIES TO: Azure Data Factory Azure Synapse Analytics

This article provides suggestions to troubleshoot common problems with the SharePoint Online list connector in Azure Data Factory and Azure Synapse.

Error code: SharePointOnlineAuthFailed

• Message: The access token generated failed, status code: %code;, error message: %message;.

• Cause: The service principal ID and key might not be set correctly.

• Recommendation: Check your registered application (service principal ID) and key to see whether they're set correctly.

Related content

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Stack Overflow forum for Data Factory