Is there a way to read data from excel set global variable in SOAP UI and send those global variable in request payload and how to call multiple rest services?

1 Answer 1


Absolutely. You can use a Groovy test script. Use Apache-POI to read the spreadsheet, and store values in SoapUI properties, e.g.:

testRunner.testCase.setPropertyValue("MyProperty", "MyValue")

Then, in the XML request, parameterise it with:


You can have your Groovy test script loop over the spreadsheet and call e.g. a test case for each record:

def soapTestStep = testRunner.testCase.getTestStepByName("SOAP Request1").name

The second part of your question I don't have an answer for.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.