Azure Data Factory调用API遇500错误,无法获取实际数据求助
Background
I'm trying to ingest XML-formatted data from a Web Services API. Since Azure Data Factory doesn't natively support XML as a source, my workflow plan is:
- Read the data in binary format first
- Load it into Azure Data Lake Gen2
- Convert it to XML/CSV using Azure Databricks afterward
Current Status
I can successfully retrieve a token ID from the API, but when I use this token to request the actual business data, the operation fails. I'm using an HTTP linked service for ingestion—all connector configurations are correct, and the test connection passes without any issues.
Error Details
Here's the full error message returned by ADF:
{ "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=UserErrorFailedToReadHttpFile,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The remote server returned an error: (500) Internal Server Error.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (500) Internal Server Error.,Source=System,'", "failureType": "UserError", "target": "Copy data1", "details": [] }
Request for Help
Could anyone help diagnose why this 500 Internal Server Error is popping up? I've double-checked the linked service setup and can get the token without problems, but the business data request keeps failing. I can provide additional details like API header configurations or copy activity settings if needed.
内容的提问来源于stack exchange,提问作者Sra1K

