Copy Data Activity Won't Connect Even Though Connection Tests Succesfully

tlgemp the error message indicates an issue with your request to the Xero API.

Can you verify that the connection settings of your copy data activity match those you used during the connection test. Verify the authentication type, consumer key, private key, and double-check the host (endpoint of the Xero server) in your linked service configuration.

Another possibility is to try debugging with the ‘curl’ command-line tool to test your Xero API requests. This helps identify issues related to headers, URLs, or payloads.

Kindly review KranthiPakala-MSFT solution to https://learn.microsoft.com/en-us/answers/questions/112731/xero-azure-data-factory-connector-operates-success?WT.mc_id=%3Fwt.mc_id%3Dstudentamb_357518

https://learn.microsoft.com/en-us/azure/data-factory/connector-xero?tabs=data-factory&WT.mc_id=%3Fwt.mc_id%3Dstudentamb_357518

If this post is helpful, please give my respond a thumbs up! Or Mark it as the solution to help others find it easily.

Thanks