extract value from soap response

Question

I need help to extract value from a soap response. The response is the following:

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<env:Header/>
<env:Body env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<m:acceptRequestResponse xmlns:m="http://vassv02:7001">
<response xsi:type="xsd:string"><![CDATA[<spml:searchResponse xmlns:spml='urn:oasis:names:tc:SPML:1:0' xmlns:dsml='urn:oasis:names:tc:DSML:2:0:core' requestID='20130211113519377' result='urn:oasis:names:tc:SPML:1:0#success'>
<spml:operationalAttributes>
<dsml:attr name='id'>
<dsml:value>0802100000</dsml:value>
</dsml:attr>
<dsml:attr name='errorCode'>
<dsml:value>1000</dsml:value>
</dsml:attr>
</spml:operationalAttributes>
<spml:searchResultEntry>
<spml:identifier type='urn:oasis:names:tc:SPML:1:0#GUID'>
<spml:id>0802100000</spml:id>
</spml:identifier>
<spml:attributes>
<dsml:attr name='district'>
<dsml:value>080</dsml:value>
</dsml:attr>
<dsml:attr name='svcType'>
<dsml:value>APT</dsml:value>
</dsml:attr>
<dsml:attr name='masterCli'>
<dsml:value>0802100000</dsml:value>
</dsml:attr>
<dsml:attr name='cliDistrict'>
<dsml:value>080</dsml:value>
</dsml:attr>
<dsml:attr name='isMaster'>
<dsml:value>Y</dsml:value>
</dsml:attr>
<dsml:attr name='billingCli'>
<dsml:value>0802100000</dsml:value>
</dsml:attr>
<dsml:attr name='outboundProxy'>
<dsml:value>85.38.231.9</dsml:value>
</dsml:attr>
<dsml:attr name='presenceServer'>
<dsml:value>10.5.20.18</dsml:value>
</dsml:attr>
<dsml:attr name='applicationServer'>
<dsml:value>sip:10.8.20.8</dsml:value>
</dsml:attr>
<dsml:attr name='administrativeStatus'>
<dsml:value>ACTIVE</dsml:value>
</dsml:attr>
<dsml:attr name='operationalStatus'>
<dsml:value>RUNNING</dsml:value>
</dsml:attr>
<dsml:attr name='geographicArea'>
<dsml:value>0020230201251</dsml:value>
</dsml:attr>
<dsml:attr name='exchangeId'>
<dsml:value>0000000205465</dsml:value>
</dsml:attr>
<dsml:attr name='accessDevice'>
<dsml:value>AG</dsml:value>
</dsml:attr>
<dsml:attr name='userDevice'>
<dsml:value>WIFI</dsml:value>
</dsml:attr>
<dsml:attr name='sipKey'>
<dsml:value>fb9c96084d6e153da4be84a3f5a8633c0c430a1bef73cbee4146deb02682d8c7</dsml:value>
</dsml:attr>
<dsml:attr name='QoS'>
<dsml:value></dsml:value>
</dsml:attr>
<dsml:attr name='suppClis'>
<dsml:value>0802100001</dsml:value>
<dsml:value>0802100002</dsml:value>
<dsml:value>0802100003</dsml:value>
<dsml:value>0802100004</dsml:value>
</dsml:attr>
<dsml:attr name='suppClisKeys'>
<dsml:value>fd6a26919ff4b8755256de4e8458d2527e8bae333541c95a95bdefaf79f3f260</dsml:value>
<dsml:value>fd6a26919ff4b8755256de4e8458d2527e8bb3f55266d7ae3f21006b075e2a61</dsml:value>
<dsml:value>fd6a26919ff4b8755256de4e8458d2527e8bbf798cb0f9ca8dc572e46d8f1262</dsml:value>
<dsml:value>b0dab81899ab22b262d898eb5ed6d4b6b581090d21bd3a85ba98475e100a095f</dsml:value>
</dsml:attr>
<dsml:attr name='STS_disablingClass'>
<dsml:value>sts_subscription=access</dsml:value>
<dsml:value>disablingClass=C10</dsml:value>
</dsml:attr>
<dsml:attr name='STS_accessBidirectionalCall'>
<dsml:value>sts_subscription=number</dsml:value>
<dsml:value>accessBidirectionalCall=2</dsml:value>
</dsml:attr>
<dsml:attr name='STS_405'>
<dsml:value>sts_subscription=number</dsml:value>
<dsml:value>active=false</dsml:value>
</dsml:attr>
<dsml:attr name='STS_CLIR'>
<dsml:value>sts_subscription=number</dsml:value>
<dsml:value>blockingPeriod=1</dsml:value>
</dsml:attr>
<dsml:attr name='STS_accessTerminatedCall'>
<dsml:value>sts_subscription=number</dsml:value>
<dsml:value>accessTerminatedCall=2</dsml:value>
</dsml:attr>
<dsml:attr name='STS_400'>
<dsml:value>sts_subscription=number</dsml:value>
<dsml:value>active=false</dsml:value>
<dsml:value>billingFlag=false</dsml:value>
<dsml:value>date=0</dsml:value>
<dsml:value>number=0</dsml:value>
<dsml:value>time=0</dsml:value>
</dsml:attr>
<dsml:attr name='STS_inArrears'>
<dsml:value>sts_subscription=access</dsml:value>
<dsml:value>typeOfMorosity=NULL</dsml:value>
</dsml:attr>
<dsml:attr name='STS_accessOriginatedCall'>
<dsml:value>sts_subscription=number</dsml:value>
<dsml:value>accessOriginatedCall=2</dsml:value>
</dsml:attr>
</spml:attributes>
</spml:searchResultEntry>
</spml:searchResponse>]]></response>
</m:acceptRequestResponse>
</env:Body>
</env:Envelope>

I want extract the errorrCode value (1000).

sandeepss · Answer

Hi,The below code may help You// Read All response XML Using Xml Holdercontext.utils = new com.eviware.soapui.support.GroovyUtils(context)def response = context.expand( '${Your Operation Name here#Response}' )context.holder = context.utils.getXmlHolder(response)// context.holder.getNodeValues("//Put the tagname as below")context.Dueval = context.holder.getNodeValues("//dsml:value")def sVal =  context.Dueval.toString()log.info sVal         // you will get your result.

max1965 · Answer

I have the following error: java.lang.RuntimeException: net.sf.saxon.trans.XPathException: XPath syntax error at char 13 on line 2 in {
//dsml:value}: Prefix dsml has not been declared error at line: 7

ccdssv1 · Answer

hi, normal parsing on your xml will now work since your data is put in a CDATA block, you may take a look at the similar issues already resolved: search.php?st=0&amp;sk=t&amp;sd=d&amp;sr=posts&amp;keywords=cdata

max1965 · Answer

I write the following groovy script:def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )def response = context.expand( '${searchRequest APT NAKED#Response}' ) //searchRequest APT NAKED is the step namedef holder = groovyUtils.getXmlHolder( response )def cdata = holder.getDomNode('//response/text()').nodeValuedef holder2 = groovyUtils.getXmlHolder( cdata )def id = holder2.getDomNode('//spml:id/text()').nodeValuelog.info idThe id value is correctly extract from soap response:Wed Feb 13 13:51:58 CET 2013:INFO:0802100000I don't know how the script should be modify to extract the errorCode value ?

ccdssv1 · Answer

Hi, the xpath for the errorCode should be: //dsml:attr[@name='errorCode']/dsml:value/text()

You should read some tutorials about xpath, here are some nice example how to access various elements from xml stuctures: http://www.zvon.org/xxl/XPathTutorial/O ... mple1.html

Forum Discussion

extract value from soap response

8 Replies

Related Content

How to extract a value from a SOAP response

Extracting child node from JSON Response

How to extract value from xml response in script assertion

extract xml node value from a response in script assertion

Extract nested JSON response values in DataSource for JSON - how to export to file / excel?

Recent Discussions

Introducing the new SmartBear DevRel Newsletter

Testing REST API with SoapUI - Emmanuel Katto Uganda

OAuth 2.0 Authorization Code Grant problem

Unsupported or unrecognized SSL message for Mock request in Soapui

Support soapui-maven-plugin Java 17