You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-14 13:51:36

Semav1
Member
2 posts

Semav1 said:

[resolved] How to convert WSDL response to table rows

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 :
mini_xml_map.jpg

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>

Last edited by Semav1 (2017-03-14 14:17:43)

Offline

#2 2017-03-15 02:27:14

vapukov
Member
470 posts

vapukov said:

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

Добро пожаловать smile

ns1: - part of tag name, same as root - not root 
mini_Screen_Shot_2017-03-15_at_2.25.56_PM.png.png 
mini_Screen_Shot_2017-03-15_at_2.25.51_PM.png.png

Last edited by vapukov (2017-03-15 02:28:50)

Offline

#3 2017-03-15 06:50:00

Semav1
Member
2 posts

Semav1 said:

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

It works!
I marked ns1: DTStr as loop and got result
Thank you!
Спасибо за помощь, коллега! smile

Last edited by Semav1 (2017-03-15 06:50:40)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy