Script to traverse in response to get data, then insert data to a request

Question

Hi, a newbie in soapUI Pro 3.0.2.&nbsp; I need to be able to parse through an XML response to check for a value, if true grab another value in the same type, and insert that data value in another request.&nbsp; I believe Groovy Script can help me do this, but I need some pointers on which methods to use and proper syntax.&nbsp; Here is what the response would look like:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;162&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Canceled&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;177&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...[more data types]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;If Status == "Approved", get the Number in DataType, else go to next Status.&nbsp; Once I get the first Number with Approved Status, I need to insert it into the next request.&nbsp; How would I get started to do this?&nbsp; I am thinking that I would start by using the XmlHolder object and use the get/setNodeValue methods, but I am not sure how to set up the for loop and/or if statements.Appreciate your help.

m_mcdonald · Answer

Assuming you want the first "Approved" value, why not do use a PropertyTransfer step.

Set the source step to be the initial request, the source property 'ResponseAsXML' and the XPath like this:

[tt:35u4nv8f]declare namespace a='http://company.com/definition/2009/08/someservice';
//DataTypes/a:DataType[a:Status='Approved']/a:Number[/tt:35u4nv8f]

Make the target a Properties step, then use a property expansion to insert the value in the request XML of the next request.

Make sure to check "Transfer Text Content" checkbox in the PropertyTransfer step.

yhkimingd · Answer

Thanks for the reply.&nbsp; To clarify, I need to do a check for Status only, then get the Number value associated with that Status for the next request.

m_mcdonald · Answer

That XPath will give you the Number value from within the first DataType that has Status = 'Approved', which seems to be what you want.

I guess you would need additional logic if you could have a result where there was no Approved DataType.

m_mcdonald · Answer

Also see http://onebyteatatime.wordpress.com/2009/02/13/how-to-insert-a-node-in-soapui-property-transfer/

yhkimingd · Answer

M McDonald wrote:That XPath will give you the Number value from within the first DataType that has Status = 'Approved', which seems to be what you want.I guess you would need additional logic if you could have a result where there was no Approved DataType.Yes, I would need additional logic because in most cases the first few will not have the Approved status.&nbsp; Appreciate any help/pointers on implementing this logic.&nbsp; Thanks.

Forum Discussion

Script to traverse in response to get data, then insert data to a request

7 Replies

Recent Discussions

SoapUI 5.9.0 released

OS SoapUI: Can it connect and use Cosmos DB

"Clone interface" between projects not working

Related Content

traverse/walk through Response schema

How to traverse through two JSON responses and get the differences in groovy?

Saving request and response