For asserting response please check http://www.soapui.org/userguide/functio ... tions.html . As for saving response in excel file you can do it by Transfering request.response through a PropertyTransferTestStep to an Excel DataSink TestStep: 1. create the RequestTestStep whose response you want to save 2. create PropertyTransferTestStep 3. create DataSink TestStep, choose excel type, add a property with value empty and set the out file where to save the content 4. in PropertyTransferTestStep set source to request/response and target to DataSink/property you've added After running the TestCase the eclel file you've specified in DataSink/out file should contain the response.
The description of the configuration options are available in the user guide, right here
File - the source excel file to use as a template for adding data Out File - the target excel file to write. If not specified the data is written to the source file Worksheet the worksheet to which the data should be added Start at Cell - the top-left cell to start at when writing data.
As for verifying, I would recommend you do this first, in the form of Assertions on the Request step. Good luck!
Unfortunately we don't have an option of asserting excel file, but it is the same as if you asserted the response from the RequestTestStep. You can do this after running a request in two ways: 1. in response/outline view position at the node that you want to assert, by right clicking you'll get Add assertion/for content (along with other options) 2. on request desktop panel open Assertions inspector in the bottom left part and click on the "+" , then from the list select Xpath Match. In the dialog that opens you can click on declare - to select the node from response (in the upper part), and on content to select the comparing content (in the bottom part).
But I am only able to do validation for just one response. how to do if I have multiple numbers of responses.
Here is my scenario: I have to pass three rows of input data to request through excel file. Then I stored the values of all the three responses in another excel file. Now I want to validate all the three responses values, but the way you suggested I am only able to validate one response.
Is it possible to validate all the responses through SOAP UI Pro?
Please let me know if you need more information. We are not able to proceed further.