tFileFetch to extract file from remote CSV link

Seven Stars

tFileFetch to extract file from remote CSV link

I'm using Data Integration Open Studio.

How can I extract file from remote csv link : 52.88...../.../file.csv ?

 

I've tried it but getting following error :

 

Screen Shot 2017-06-02 at 3.31.15 PM.png

 

 

Tags (1)

Accepted Solutions
Seven Stars

Re: tFileFetch to extract file from remote CSV link

can you try giving ur link inside quotes


All Replies
Seven Stars

Re: tFileFetch to extract file from remote CSV link

Seven Stars

Re: tFileFetch to extract file from remote CSV link

Here is the link I'm trying to read csv from :

http://52.88.152.46/dataset/Duplicates.csv
Seven Stars

Re: tFileFetch to extract file from remote CSV link

Fetchcsv.PNGoutput.PNG

Seven Stars

Re: tFileFetch to extract file from remote CSV link

Hi @AkshayNG,

is this you need?

Seven Stars

Re: tFileFetch to extract file from remote CSV link

I'm using mac so setup like this: 

 

Screen Shot 2017-06-02 at 5.43.07 PM.png

 

still getting same error :

Screen Shot 2017-06-02 at 5.47.40 PM.png

 

Seven Stars

Re: tFileFetch to extract file from remote CSV link

can you try giving ur link inside quotes

Seven Stars

Re: tFileFetch to extract file from remote CSV link

Great, writing link inside quotes worked. Many Thanks Smiley Happy @Sara
Seven Stars

Re: tFileFetch to extract file from remote CSV link

Great Smiley Happy

Two Stars

Re: tFileFetch to extract file from remote CSV link

hello mam

 

i m getting error in tfilefetch

pls help me to solve this.

pls find the attached image

Untitled.png

Moderator

Re: tFileFetch to extract file from remote CSV link

Hello,

There is a java.net.UnknownHostException in your job.

The URI is correct for you? Are you able to ping your remote CSV link successfully?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.