File download using HTTP connector

Sachin S 26 Reputation points

I'm downloading a file using HTTP connector from a URL similar to as below:

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


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 37,656 Reputation points Microsoft Employee

    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.

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


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

0 additional answers

Sort by: Most helpful