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:
- 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.
- 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.