#91. Azure Data Factory: Copy File From HTTP Server to ADLS

This video takes you through the steps required to implement a copy activity from a HTTP server to ADLS.

Update: instead of using the file type as excel, if we choose binary format in the data set, the excel file gets downloaded to the ADLS as such.

[marinasokolova]

Hi,
Thank you so much for your tutorial video!!
Especially great for the beginner!!! It is super useful with all explanation on it!
I was trying use the binary type to load excel. It doesn't work. Do you have a video how to load excel using binary type?

[parallelescapes]

I want to copy entire folder from http location. How can i do that using copy activity

[bilalshafqat]

Hi, I am getting this error while doing preview data:

Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at
at millisecondsTimeout, CancellationToken cancellationToken)
at

Please guide.

[indirapatil]

Hi,
Please can know that have two HTTP links as source, like having buliding ID'S in one link and adding ID'S to 2nd link and getting data.

[harithaaharii]

Hi, If we need to add additional headers, then what is the syntax for it

[cajaykiran]

Hello there. It was very helpful video. Is there any video on how to copy a file from SharePoint Online to Azure blob storage. If not can I request you to make one.

[Ravi-guww]

Hi,
how to hit the same url in regular interval of time to place new data into blob everytime

[SRBBS]

Hi, can we consume a rest api end point and passing params in the url ? Thanks !

[vardhan]

Hi,
Thanks your doing such type of videos which are very helpful.
when I am trying same this sheet name is not loading to select in source dataset setting.

Also, I am unable to read xlsx file from sharepoint url link (which is in my self sharepoint folder path).I tried with copying entire url in base url and divided into relatavie & base url parts. but same issue that sheet name is not loading to select and preview the data.
can you please let me know how to get this
Thanks in advance

[IaAnkitSingh]

Can you please
Help me in how to migrate sftp files to azure blob

[mealearner]

thanks mam, was looking for something like this.

[venkyjagarlamudi]

Hi tq so much, it is useful, but i need copy files from share file citrix yo azure blob can u plz provide me ASP

[RajendraPrasad-ptyk]

Hi
Thanks for this video, This is very useful.
Can you do one video on how to copy files from an on-prem shared folder to ADLS.

[harinim]

Hi
Thank you for the video .
one issue from my side

[SantoshKumar-yrmd]

not explained properly from where you started, previous configured you explained

[vilanvijay]

Error details
Error code
21359
Activity ID

Details
Encrypted excel file 'file_example_XLSX_100.xlsx' is not supported, please remove its password. Wrong Local header signature: 0x4F44213C