Unanswered

Download a csv file by a url

(0) Share

Report

Posted on by airma

I have a URL if I search it in edge, will download a csv file in my Downloads folder. I want to build a flow that can weekly download the file then put it in my one Drive or share point.

I try to use upload file from URL but it failed...

I want to know do we have better way to do this...thanks~!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

TheNextOne 37 on at

Like (0)

Report

@airma try to read the content of the file and create another to the destination with the content of the first one.

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report

I didn't have any issues with the default OneDrive connector Upload file from URL:

Here is the file in my OneDrive:

What is the issue you are having specifically? Can you provide some screenshots of the error(s) and the part of your flow you are having trouble with?

Was this reply helpful? Yes No
airma 6 on at

Like (0)

Report

Thanks for you help , this is correct file I want:
this is which I use upload file from URL get 😂

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report

Are you able to provide the URL you are getting this from? Or is it an internal one? I would also need to see your flow to see what could be going on. At a glance, it looks like it's pulling in HTML to an Excel file, which won't work as far as I know.

Was this reply helpful? Yes No
DexPoint 185 on at

Like (0)

Report

its a service now link looking at the HTML code. but i have similar issue. i use the UPload file from URL for an .xlsx document and works great. but as soon as i try the CSV file i get the same HTML stuff,

Here is just one column. i think it has to do with the encoding type but not sure. the HTTP Premium one also doesnt seem to work for this CSV file.
<!doctype html><html xmlns:ng="" xmlns:tb=""><head><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="initial-scale=1

Was this reply helpful? Yes No
DexPoint 185 on at

Like (0)

Report

I wanted to follow up on this, In reviewing the process i did, the Upload file from URL essentially does a GET command, retrieving file contents, if the program is an API it works file because it retreives the file. however in some cases it will just return the results of the GET command. (not sure im explaining it right).

So i actually built a powershell script that downloads my file and i used a batch file and windows task manager to get that file, in my case its a fixed link that doesnt change because its from a reporting tool. this is how i solved for that issue.

Was this reply helpful? Yes No