topic Re: download and save an xls file from url in Talend Studio

download and save an xls file from url

Anonymous — Wed, 26 Apr 2017 12:16:00 GMT

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

Re: download and save an xls file from url

DilipSonar — Sun, 07 May 2017 16:34:22 GMT

please try using tFIleFetch using FTP protocol.

Re: download and save an xls file from url

Anonymous — Fri, 02 Jun 2017 12:30:41 GMT

Can you plz elaborate how ? @ds98930

Re: download and save an xls file from url

Anonymous — Fri, 02 Jun 2017 12:41:58 GMT

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.

Re: download and save an xls file from url

Anonymous — Fri, 02 Jun 2017 12:46:00 GMT

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-link/td-p/26583/jump-to/first-unread-message

Re: download and save an xls file from url

Anonymous — Mon, 09 Oct 2017 07:21:12 GMT

Hi,
My download URL is:
https://socialweb-analytics.lcloud.com/api/public/reports/report/21b6e2ea-a359-3632-b798-81d3f06ca96a/23DwDbqY71efb7zXL1gTbiHoXDz3JrVch8kCl7IWP9zKo%3D/download?companyKey=hpcsc

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

Re: download and save an xls file from url

Rajender — Thu, 24 Jan 2019 05:01:20 GMT

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.