How to store response values into excel using SOAP UI pro?
Hi, How can I store the response values into external file like excel. And verify the output values with expected values. I will appreciate any help Thanks in advance,
Forum Discussion
Hi,
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.
Regards,
Dragica
eviware.com
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.
Regards,
Dragica
eviware.com
Hello,
I have multiple rows data in excel which I am passing through the single Request in soapuipro.
For those multiple rows data I am able to get multiple response in soapui but not getting stored in the excel again.
Only one response i.e first response is getting updated in excel.
I have used data sink and to read multiple data I have used datasource loop.
