AnsweredAssumed Answered

Reduce and convert XML response in PolicyManager

Question asked by anbl on Jun 13, 2017
Latest reply on Jun 19, 2017 by Mark_HE

Hi

 

I have an XML response that I want to reduce and then covert to JSON. How do I do that easiest? I have tried the xPath properties but that only gives me the value of the node back and not the whole node. 

 

Example:

 

<soapenv:Envelope>
   <soapenv:Body>
   <GetAccountsResponse >
      <ns1:Header>
         <tl:MsgId></tl:MsgId>
         <tl:SystemId>TDE</tl:SystemId>
         </ns1:Header>
      <ns1:GetAccountsResponseRecord>
         <ns1:Account>
            <tl:AccountNo>xx</tl:AccountNo>
           <tl:LastName>xx</tl:LastName>
           <tl:FirstName>xx</tl:FirstName>

....

 

 

I want only the Account object and then convert 

/A

Outcomes