AnsweredAssumed Answered

Parse response of a WS with GEL

Question asked by Yaman_Yazgan on Dec 28, 2016
Latest reply on Jan 10, 2017 by gcubed

Hi All,

 

I have called an external .NET webservice and get a resultset like below. I managed to read a single result but has anyone address any sample to read somteihn like this in a loop?

 

<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<CaPmoTFSProjectInfoCountResponse xmlns="http://tempuri.org/">
<CaPmoTFSProjectInfoCountResult>
<xs:schema xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" id="NewDataSet">
<xs:element name="NewDataSet" msdata:UseCurrentLocale="true" msdata:MainDataTable="CAPMOTFSProjectInfoCountDT" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="CAPMOTFSProjectInfoCountDT">
<xs:complexType>
<xs:sequence>
<xs:element name="Type" minOccurs="0" type="xs:string"/>
<xs:element name="State" minOccurs="0" type="xs:string"/>
<xs:element name="Count" minOccurs="0" type="xs:int"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<DocumentElement xmlns="">
<CAPMOTFSProjectInfoCountDT diffgr:id="CAPMOTFSProjectInfoCountDT1" msdata:rowOrder="0" diffgr:hasChanges="inserted">
<Type>Test Case</Type>
<State>Toplam</State>
<Count>1</Count>
</CAPMOTFSProjectInfoCountDT>
<CAPMOTFSProjectInfoCountDT diffgr:id="CAPMOTFSProjectInfoCountDT2" msdata:rowOrder="1" diffgr:hasChanges="inserted">
<Type>Bug</Type>
<State>Açık</State>
<Count>2</Count>
</CAPMOTFSProjectInfoCountDT>
<CAPMOTFSProjectInfoCountDT diffgr:id="CAPMOTFSProjectInfoCountDT3" msdata:rowOrder="2" diffgr:hasChanges="inserted">
<Type>Bug</Type>
<State>Kapalı</State>
<Count>0</Count>
</CAPMOTFSProjectInfoCountDT>
<CAPMOTFSProjectInfoCountDT diffgr:id="CAPMOTFSProjectInfoCountDT4" msdata:rowOrder="3" diffgr:hasChanges="inserted">
<Type>Bug</Type>
<State>Çözüldü</State>
<Count>0</Count>
</CAPMOTFSProjectInfoCountDT>
<CAPMOTFSProjectInfoCountDT diffgr:id="CAPMOTFSProjectInfoCountDT5" msdata:rowOrder="4" diffgr:hasChanges="inserted">
<Type>Bug</Type>
<State>İptal</State>
<Count>0</Count>
</CAPMOTFSProjectInfoCountDT>
<CAPMOTFSProjectInfoCountDT diffgr:id="CAPMOTFSProjectInfoCountDT6" msdata:rowOrder="5" diffgr:hasChanges="inserted">
<Type>Bug</Type>
<State>Toplam</State>
<Count>2</Count>
</CAPMOTFSProjectInfoCountDT>
</DocumentElement>
</diffgr:diffgram>
</CaPmoTFSProjectInfoCountResult>
</CaPmoTFSProjectInfoCountResponse>
</soap:Body>
</soap:Envelope>

Outcomes