How to store response values into excel using SOAP UI pro?
How to store response values into excel and verify the same with expected through SOAP UI pro
Forum Discussion
Create a datasource in your teststeps, adding the number of properties that you would like to be added to your excel file. From the datasource tab, select excel as your datasource type.
From your soapui test, right click and selcet get data. Find the test you want to get the information from and pick property [Response]. From teh select Xpath window that opens up select the information you want to add. That should get you the information that you are looking for. NOTE if you are using an excel vesrion newer that 2003 you need to ensure that you change the ecxel file type to xls, be default it goes to xlsx.
From your soapui test, right click and selcet get data. Find the test you want to get the information from and pick property [Response]. From teh select Xpath window that opens up select the information you want to add. That should get you the information that you are looking for. NOTE if you are using an excel vesrion newer that 2003 you need to ensure that you change the ecxel file type to xls, be default it goes to xlsx.