Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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 :


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>

Labels (3)
2 Replies
vapukov
Master II
Master II

????? ?????????? Smiley Happy

ns1: - part of tag name, same as root - not root 
 
Anonymous
Not applicable
Author

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