[resolved] How to convert WSDL response to table rows

Anonymous — Sat, 16 Nov 2024 09:59:58 GMT

Hi, all!
I have Web-service, which returns xml-tree (see below). I use tWebServiceInput to accept data (single column DTStr as document in schema) and tXMLMap to convert XML-tree to table rows. tXMLMap returns no rows.
Could somebody help?
Regards
tXMLMap prefs :

WSDL response:

<ns1:return xmlns:ns1="" xmlns:xs="" xmlns:xsi="">
    <ns1:DTStr>
     <ns1:CenterName>'KiaS'</ns1:CenterName>
     <ns1:BrandName>???</ns1:BrandName>
     <ns1:PeriodBeginDate>CONVERT(DATETIME, '2017-03-01 0:00:00', 120)</ns1:PeriodBeginDate>
     <ns1:PeriodEndDate>CONVERT(DATETIME, '2017-03-31 23:59:59', 120)</ns1:PeriodEndDate>
     <ns1:FinR_ID>5</ns1:FinR_ID>
     <ns1:FactValue>0</ns1:FactValue>
     <ns1:PlanValue>0</ns1:PlanValue>
    </ns1:DTStr>
    </ns1:return>

Re: [resolved] How to convert WSDL response to table rows

vapukov — Wed, 15 Mar 2017 01:27:14 GMT

????? ??????????

ns1: - part of tag name, same as root - not root

Re: [resolved] How to convert WSDL response to table rows

Anonymous — Wed, 15 Mar 2017 05:50:00 GMT

It works!
I marked ns1: DTStr as loop and got result
Thank you!
??????? ?? ??????, ???????!

topic Re: [resolved] How to convert WSDL response to table rows in Talend Studio

[resolved] How to convert WSDL response to table rows

Re: [resolved] How to convert WSDL response to table rows

Re: [resolved] How to convert WSDL response to table rows