topic soap to xml in Talend Studio

soap to xml

veryimportantdude — Thu, 16 Oct 2014 14:48:51 GMT

Hello
I am using TOS 5.5.1 and I am trying to get data from WSDL service and create xml file
I put tSOAP component and connected to tfileoutputXML. I am getting a realy disturbing string in body tag
"<ns2:GetWarningDeviceStatusHistoryResponse xmlns:ns2=" http://analytics.pins.iskratel.si/"><return><id>1</id><timeStart>2014-09-30T13:32:19+02:00</timeStart><timeEnd>2014-10-15T13:28:01+02:00</timeEnd><warningDevice><type>TelegrafijaSirene</type><id>1</id><name>Sirena_Grasic_mobile</name>< "

any suggestions on how to create a simple xml file for forward processing (transfering data into db)

Thank you

best regards

Re: soap to xml

Anonymous — Tue, 04 Nov 2014 07:04:04 GMT

Hi
The body returns a XML string, you can use a tExtractXMLField to extract the data from SOAP message after tSOAP.
Best regards
Shong