download and save an xls file from url

[Anonymous]

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

[DilipSonar]

please try using tFIleFetch using FTP protocol. 

[Anonymous]

Can you plz elaborate how ? @ds98930

[Anonymous]

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.

[Anonymous]

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...

[Anonymous]

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?

[Rajender]

Hi

Thanks for information on tFileFetch.

If a http url requires authentication, is it possible with tFileFetch component. If yes then how.

Thanks in Advance!

---

@Sara wrote:

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.

---

---

@Sara wrote:

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.

---