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>=TO_DATE('2015.08.12 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND P.MODIFYDATE<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>