I am trying to retrieve bulk data from an external DB and embed to form a xml with tags and then try to send it via TSOAP component to related web service as an input.
1-How can I introduce an XML file to TSOAP component to read from as an input?
2-Is there a way or component that can read from external DB and create the xml with required tags automatically and then send to TSOAP as input in Talend?
Hi
I think you need to write a XML string with tWriteXMLField, and then store this XML string to a context variable, use the context variable as soap message on tSOAP. eg;
tMysqlInput--main--tWriteXMLField--main--tJavaRow--oncomponentok--tSOAP
Regards
Shong
