AnsweredAssumed Answered

Parsing response XML

Question asked by Manish9jul on Mar 24, 2014
Latest reply on Mar 25, 2014 by Tom_Kouhsari
 
HI,
I am using the SOAP operator for doSelect web service for fetching the detail of incident from SDM  and trying to parse the response XML.
But After defining the Xpath variable dataset in the Call Result option like...
 
xpath expression: //summary/text()
Dataset Variable: XpathResult
Type:String
 
It is not showing the values under the operation result for summary and description.
 
Getting the doSelect query result in the below format.
 

<doSelectResponse xmlns="http://www.ca.com/UnicenterServicePlus/ServiceDesk">

<doSelectReturn xmlns="">&lt;?xml version="1.0" encoding="UTF-8"?&gt;

&lt;UDSObjectList&gt;

&lt;UDSObject&gt;

&lt;Handle&gt;cr:400388&lt;/Handle&gt;

&lt;Attributes&gt;

&lt;Attribute DataType="2002"&gt;

&lt;AttrName&gt;summary&lt;/AttrName&gt;

&lt;AttrValue&gt;Testing.......&lt;/AttrValue&gt;

&lt;/Attribute&gt;

&lt;Attribute DataType="2002"&gt;

&lt;AttrName&gt;description&lt;/AttrName&gt;

&lt;AttrValue&gt;Testing......&lt;/AttrValue&gt;

&lt;/Attribute&gt;

&lt;/UDSObject&gt;
&lt;/UDSObjectList&gt;
</doSelectReturn>
</doSelectResponse>

I am not sure how to convert it in standard xml format which can be understandable by call result option in PAM for parsing the variable value.

Can anyone please guide me.

Thanks,

Manish

Outcomes