topic Re: loop through tOracleInput and tFileFetch in Talend Studio

loop through tOracleInput and tFileFetch

Anonymous — Wed, 25 Jul 2012 19:26:29 GMT

Hi,
I'm very new to Talend.
I'm trying to create a job reading a tOracleInput returning a bunch of latitudes/longitudes and looping through results executing a tFileFetch to call a URI for each record based on the latitude/longitude to return weather data. I need to put the latitude/longitude into the URI for each record. Is this possible? Are these the right components to use?
Thanks,
Marcie

Re: loop through tOracleInput and tFileFetch

Anonymous — Thu, 26 Jul 2012 02:25:07 GMT

Hi
tOracleInput--main(row1)-->tFlowToIterate--Iterate-->tFileFetch
Type row1.URI in tFileFetch.
Regards,
Pedro

Re: loop through tOracleInput and tFileFetch

Anonymous — Thu, 26 Jul 2012 14:07:41 GMT

Thank you so far. I have set up tOracleInput--main(row1)--tflowIterate--iterate--tfileFetch
I need to build the URI based on what is returned in the tOracleInput so I am doing this
"http://www.ncdc.noaa.gov/cdo-services/services/datasets/GHCND/locationsearch?latitude=" +row1.latitude + "longitude=" + row1.longitude + "&token=XuynqsXFIGjQEXIshdoyFizBgrdZdwXO"

however it isn't working using latitude and longitude as variables.
How do I accomplish this?
Thanks,
Marcie

Re: loop through tOracleInput and tFileFetch

Anonymous — Fri, 27 Jul 2012 02:19:06 GMT

Hi Marcie
Do you get any errors?
If there are two columns "latitude" and "longitude" in tOracleInput, these values should be passed into tFileFetch.
Regards,
Pedro

Re: loop through tOracleInput and tFileFetch

alevy — Fri, 27 Jul 2012 04:07:40 GMT

I suggest for testing that you replace the tFileFetch with tJava and print the URI you are trying to construct to the console so you can ensure that it is correct e.g.

System.out.println("http://www.ncdc.noaa.gov/cdo-services/services/datasets/GHCND/locationsearch?latitude=" +row1.latitude + "longitude=" + row1.longitude + "&token=XuynqsXFIGjQEXIshdoyFizBgrdZdwXO");

Re: loop through tOracleInput and tFileFetch

Anonymous — Tue, 31 Jul 2012 12:12:11 GMT

The job doesn't execute and I get a message that latitude and longitude cannot be resolved or is not a field.

Re: loop through tOracleInput and tFileFetch

Anonymous — Tue, 31 Jul 2012 12:18:14 GMT

I get the error as well when I try to use tJava to see the results of the variables.

Re: loop through tOracleInput and tFileFetch

Anonymous — Tue, 31 Jul 2012 12:49:52 GMT

I figured it out. I was using context.latitude/longitude instead of row1.

Re: loop through tOracleInput and tFileFetch

Anonymous — Wed, 01 Aug 2012 02:25:58 GMT

Hi
Thanks for your feedback!
Regards,
Pedro