Forum Discussion

mrojze's avatar
mrojze
Icon for Helper II rankHelper II
2 years ago
Solved

Copy a file from an URL to OneLake

I have a Fabric pipeline that is requesting an Amazon SP report through API calls. Amazon prepares the report and it returns a unique URL to download the report. How can I download the report using ...
  • mrojze's avatar
    2 years ago

    Yes! I have solved the issue using my new adquired Python skills (aka Copilot).

    In order to download the file I do the following:

     

     

    I capture the URL in the vairable url and then I ised the described library in order to use the urlretrieve method.

    The issue I found after it was that the downloaded file was a GZIP one. Guess what?

    A few more libraries and a few lines of code later I was able to place the unzipped file into the OneLake:

     

     

    Thanks anyone that responded to my post.