Four Stars

download and save an xls file from url

Hello,

so i have a url with downloading a file.

which component on talend can i use to access this url, download the file and output it as xls ??
i have used tHttprequest but when i open the xls file it's empty, i think i use it wrong.

Thanks

Khaled

5 REPLIES
Four Stars

Re: download and save an xls file from url

please try using tFIleFetch using FTP protocol. 

Seven Stars

Re: download and save an xls file from url

Can you plz elaborate how ? @sonardilip

Seven Stars

Re: download and save an xls file from url

Hi @AkshayNG

Open the job and place tFilefetch component.

 

URL : give the link which you want to download

Destination Directory: give the path of directory

Destination FileName : give the name for file eg: Sample.xls

Then run the job.

Seven Stars

Re: download and save an xls file from url

Thanks for your quick reply @Sara

I've performed the same but getting an error. I thought I might be missing something. Please have a look at my question here :
https://community.talend.com/t5/Design-and-Development/tFileFetch-to-extract-file-from-remote-CSV-li...

Two Stars

Re: download and save an xls file from url

Hi,
My download URL is:
https://socialweb-analytics.lcloud.com/api/public/reports/report/21b6e2ea-a359-3632-b798-81d3f06ca96...

which gives me :
tFileFetch_1 Method failed: HTTP/1.1 405 Method Not Allowed
Could you help me with this?