Hi forumites, I just started evaluating TOS as replacement for Apatar, which seems to be ceased sadly. One thing we have to use very often is reading XML data from an URL which looks like this: https://url.com/getxml.php?get=1¶=12345¶=*****¶=14¶=2¶=2 Calling this URL generates a standard XML object:
3807071829 own
I want to read this XML input, transform and put it into a MySQL database. The only XML input I found in TOS so far is file base - how to realize the URL based XML input? After all its pretty much the same thing, in Apatar its the same connector handling both. Thanks for reading!
You can use the cTalendJob component to send the contents over to a Job (under the covers it's just invoking the Job as a Java class). Then when you use tRouteInput in the job, you chose what to read off of the Route Message (a.k.a. Camel Exchange) and read the data you need in as fields. Check out Apache Camel's Simple Expression language to see how to read the data out of the Route (Search for Camel Simple for the Apache documentation).
I hope that helps!
