The ADF Xero connector has started failing since a recent Xero API update

Dataloop 0 Reputation points
2025-08-26T09:23:39.61+00:00

A recent Xero API update has caused our ADF Xero connector to fail across all pipelines, do we have a resoltuion date?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

1 answer

Sort by: Most helpful
  1. Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator
    2025-08-26T11:38:21.59+00:00

    Hi Dataloop This behavior is expected due to a recent change introduced by Xero in their API. The ADF Xero connector currently relies on the older authentication and endpoint implementation, which Xero has deprecated. As a result, connections are failing across pipelines when attempting to refresh or extract data.

    At this time, there isn’t an official resolution date announced for the native ADF Xero connector. The product team is tracking this issue, but in the interim, there are two workarounds you can consider:

    1. Use the REST connector in ADF : You can call Xero’s new API endpoints directly by registering an app in the Xero developer portal and configuring OAuth 2.0 authentication in ADF. This allows you to continue extracting data while bypassing the broken native connector.
    2. Leverage an Azure Function or Logic App: Some customers are successfully using Azure Functions/Logic Apps as an integration layer to handle authentication and data pulls from Xero, then landing data into Blob/ADLS for ADF ingestion.

    Monitoring the Azure Data Factory connector updates documentation for any announcements on when Xero connector support will be updated.


    I hope this information helps. Please do let us know if you have any further queries. Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.