Forum Discussion
I'd strongly urge you to use a Database not Excel for this.
In the Community edition, if you must use Excel then you will need to use Groovy, which is covered in this question/answer: https://community.smartbear.com/t5/SoapUI-Open-Source/How-to-save-response-data-in-Excel-CSV-format-in-SOAP-UI-5-2-1/m-p/115816#M20008
Groovy provides the most flexibity approach for Excel or DB but requires that you use or learn some Groovy Programming. Groovy is what makes SOAPUI such a powerful test tool and it is worth the effort.
If you use a DB then you do not need to learn programming and could use a JDBC step: see: https://www.soapui.org/resources/tutorials/tutorial-data-driven-testing.html
IF you have Pro, you can do this with Excel or DB and take a look at this tutorial
https://www.soapui.org/docs/data-driven-tests/functional-tests.html
- durgapandey6 years agoNew Contributor
Thanks MartinSpamer for the guidance
My request is in json and I will have to use excel only. I am using a community version. Will follow and update once done.
just an update I got a pro version. Now trying for excel
Related Content
- 8 years ago
- 4 years ago
- 8 years ago
Recent Discussions
- 4 days ago
- 8 days ago
xml to soap
Solved8 days ago