Hi everyone,

I'm using TOS 3.0.0r18993 on a Windows Vista x64 Business SP1 system. My Talend project is in Java and I'm quite a newbie using TOS.

Well, I spend now several hours here in this forum, but I couldn't find a usefull hint for my problem. As I am reading values from an SQL Database (that contains ID, name, zip, telephone and email as VarChar), I would like to get the missing city name by accessing an URL, in this case "http://ws.geonames.org/postalCodeSearch?country=de&maxRows=1&style=short&postalcode=<ZIP>"

I figured it out how to read ot iteratively XML Files from this URL by using the tFetchFile Operator. But as far as I can see it does not really help me here, as I have to read in those files later step by step.
What I get are some XML Files, stored in a temporary folder...but how could I access them later, if the Name is <ZIP>.xml? If I want to compare the ZIP code later and get the city name - how could that be done best?

My other question is, if and how I could access the URL directly and process the XML File in a way that I can directyl read the missing city name and insert it in the data flow. Would the WebServiceInput helpfull in that case? And how can I integrate it later, e.g. in a tMap component?

Kind regards
mrvoyles