I am trying to create a linked service in Data Factory to Share point Online but i am getting connection error

Dee T 26 Reputation points
2021-01-18T21:30:44.833+00:00

Hi I am referring this document: https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list and I am able to complete all the steps mentioned but when I test the connection I get this error:

Failed to get metadata of odata service, please check if service url and credential is correct and your application has permission to the resource. Expected status code: 200, actual status code: Unauthorized, response is : {"error":"invalid_request","error_description":"Token type is not allowed."}.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,692 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Holpar, Peter 1 Reputation point
    2021-06-05T21:50:11.723+00:00

    https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs

    Azure Access Control (ACS), a service of Azure Active Directory (Azure AD), has been retired on November 7, 2018. This retirement does not impact the SharePoint Add-in model, which uses the https://accounts.accesscontrol.windows.net hostname (which is not impacted by this retirement). For more information, see Impact of Azure Access Control retirement for SharePoint Add-ins. For new tenants, apps using an ACS app-only access token is disabled by default. We recommend using the Azure AD app-only model which is modern and more secure. But you can change the behavior by running ‘set-spotenant -DisableCustomAppAuthentication $false' (needs the latest SharePoint admin PowerShell).

    0 comments No comments

  2. Kasper Ulvedal 11 Reputation points
    2023-10-01T16:22:35.7333333+00:00

    I've had the same issue, and spend some time understanding why and how to resolve.

    I have made the following guide on what to do in Sharepoint, to allow Data Factory to access SharePoint online (after November 2018 due to ACS, as Peter Holar also states).

    How to article here:

    https://github.com/kasperulvedal/Azure-Data-Factory-Stuff/blob/main/Linked%20Services/Sharepoint/Setting%20up%20Sharepoint%20so%20Azure%20Data%20Factory%20can%20access%20it.md#setting-up-sharepoint-so-azure-data-factory-can-access-it

    Sharing the link, just in case someone will run into the same issue.

    0 comments No comments