ADF copy data issue with RESt

Ram Raju 6 Reputation points
2021-10-26T14:13:15.957+00:00

Hi,

I am pulling api data. I have a copy activity with the source as REST and sink as csv. The link service test for the REST is successful. But during the activity an error throws up

""Code": 11564,
"Message": "Failure happened on 'Source' side. ErrorCode=UserErrorFailToReadFromRestResource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=An error occurred while sending the request.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=The underlying connection was closed: An unexpected error occurred on a send.,Source=System,''Type=System.IO.IOException,Message=Authentication failed because the remote party has closed the transport stream.,Source=System,'"

I have tested this API with postman and curl and it works all fine.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator
    2021-10-27T15:51:47.757+00:00

    Hi @Ram Raju ,

    Thank you for posting query in Microsoft Q&A Platform.

    From the error message it looks like Authentication issue.

    • Are you using correct request method and authentication types? Could you please review once?
    • Could you please check Preview data option under source tab of Copy activity after selection REST dataset?
    • Could you please share your configurations of copy activity and datasets and linked services? That may help to repro scenario.

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.