File download using HTTP connector

Question

Hello,
I'm downloading a file using HTTP connector from a URL similar to as below:
https://{website}/FileView2.aspx?IDFile=26a883a7-afb4-4d98-95e8-29cc63638c28

The link points to a zip file. The file downloads with a proper name in the browser but I see the below behaviour using ADF:

1. The .zip extension is left out
2. The file name is actually a GUID instead of a readable name as in the case of download via a browser

Any ideas what changes need to be done in the HTTP connector to download the file with a proper name and extension as downloaded using a browser?
Below is how my source dataset is setup in the copy activity

Answer 1

Hi @Sachin S ,

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

If we don't mention file name in Sink dataset of Copy activity then we will be seeing this behavior.

Make sure to mention file name in sink dataset with extension .zip to avoid this behavior.

Please check below detailed implementation of same which I reproduced for your better understanding.

Source Dataset of Copy activity:

Sink Dataset of Copy activity:

Please check below video, where same thing explained for xlsx file. This may also helpful.
https://www.youtube.com/watch?v=LSF4ca0vfJE

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

-----------------

Please consider hitting Accept Answer. Accepted answers helps community as well.