AnsweredAssumed Answered

Unable to parse XML

Question asked by rbachmann Champion on Sep 5, 2016
Latest reply on Dec 13, 2016 by emha

Hi,

I query a custom Web Service in Nintex Workflow 2013 and get the following XML.

Somehow, I can't parse it using the Query XML Action. As a result, I get the orignal XML data back.

Can anybody help me out?

 

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
 <s:Body>
  <GetPersonIdListResponse xmlns="http://tempuri.org/">
   <GetPersonIdListResult xmlns:a="http://schemas.datacontract.org/2004/07/xyz" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
    <a:Error>_NoError</a:Error>
    <a:ErrorMessage/>
    <a:Result>true</a:Result>
    <a:Count>4</a:Count>
    <a:Ids xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
     <b:int>100108</b:int>
     <b:int>100123</b:int>
     <b:int>100375</b:int>
     <b:int>103741</b:int>
    </a:Ids>
    <a:Objekt>Person</a:Objekt>
    <a:SqlCommand>SELECT DISTINCT P.PERSONID FROM PERSON P INNER JOIN PERSONORG PO ON PO.PERSONID=P.PERSONID INNER JOIN ORGEINHEIT O ON O.ORGEINHEITID=PO.ORGEINHEITID INNER JOIN KOSTENSTELLE K ON K.KOSTENSTELLE_PKEY=O.KOSTENSTELLE_FKEY  WHERE K.KREIS LIKE '501' AND P.MODIFYDATE&gt;=TO_DATE('2015.08.12 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND P.MODIFYDATE&lt;TO_DATE('2016.08.10 00:00:00', 'yyyy/mm/dd hh24:mi:ss') ORDER BY 1</a:SqlCommand>
    <a:StrIds xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/>
   </GetPersonIdListResult>
  </GetPersonIdListResponse>
 </s:Body>
</s:Envelope>

Outcomes