Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mrojze
Helper II
Helper II

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 DF?

A WEB call requires a base URL, which I don't have.

Any suggestions?

 

Thanks!

Martin Rojze

 

1 ACCEPTED SOLUTION
mrojze
Helper II
Helper II

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

In order to download the file I do the following:

 

mrojze_0-1709331297149.png

 

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:

 

mrojze_1-1709331480325.png

 

Thanks anyone that responded to my post.

 

 

View solution in original post

6 REPLIES 6
SyedN
Regular Visitor

@mrojze I am looking to ingest JSON file in my android download folder and tryig to push it through my android APP ( using Java ) to write it on One Lake can you please guide me how to do this ? 

mrojze
Helper II
Helper II

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

In order to download the file I do the following:

 

mrojze_0-1709331297149.png

 

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:

 

mrojze_1-1709331480325.png

 

Thanks anyone that responded to my post.

 

 

Anonymous
Not applicable

Hi @mrojze ,

Thanks for using Fabric Community.
You can only save the dataframe to file, but you cannot download a file while working with notebooks.

If you are passing url from notebook activity to notebook using fabric data factory.

vgchennamsft_1-1709111638019.png

 

After reading the notebook parameters value, you can make a requests get call but gets the data in string format only.

vgchennamsft_0-1709111521997.png

vgchennamsft_2-1709112620352.png


Hope this is helpful. Please let me know incase of further queries.

Thanks for your reply!

So what are my options if I have a URL with a GZIP?

Is there any way to download it?

Maybe using LogicApps?

 

Anonymous
Not applicable
Anonymous
Not applicable

Hello @mrojze ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

Top Solution Authors