Copy data from website to Azure Blob

Pandey, Aman 1 Reputation point
2021-09-08T16:39:55.98+00:00

Hi,

Thanks in advance!

I am trying to copy data from website to Azure blob using copy function in ADF. I am getting the below mentioned error.

Link for file: http://transparenciacre.westcentralus.cloudapp.azure.com/PNT/73/III/E/PL/Precios_promedio_diarios_y_mensuales_en_estaciones_de_servicio.xlsx

File is a excel.

Error:

Operation on target Copy data1 failed: Failure happened on 'Sink' side. ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server：Unable to connect to the remote server,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=Unable to connect to the remote server,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 13.78.144.244:80,Source=System,'

Can you suggest me what to do to resolve this error?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,614 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2021-09-09T08:12:58.94+00:00

    Hi @Pandey, Aman ,

    Welcome to Microsoft Q&A Platform. Thank you for posting query here.

    l tried to Copy file from below link to Blob and it was working perfectly fine. You need to consider using HTTP connector type dataset in Source tab of Copy activity as your link is going to download a file.

    HTTP connector is generic to retrieve data from any HTTP endpoint, e.g. to download file.

    Please check below detailed steps of implementation.

    Step1: Copy activity, source tab select a dataset which is HTTP connector type with binary format.

    130683-sourcedataset.gif

    Step2: Copy activity Sink tab select a dataset which is Blob connector type with binary format and give file name inside your dataset as per your requirement. Here I gave name to my file in sink as excelfile.xlsx

    130665-sinkdataset.gif

    Step3: Copy activity executed Successful.

    130684-execution.gif

    Hope this will help. Please let us know if any further queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators