File download using HTTP connector

Sachin S 26 Reputation points
2022-01-26T02:42:53.81+00:00

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

168450-image.png

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
    2022-01-27T17:04:10.833+00:00

    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:
    169126-image.png

    Sink Dataset of Copy activity:
    169094-image.png

    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.


0 additional answers

Sort by: Most helpful