Open SoapUI editor and use the navigation File > New > Functional Test and provide the.Procedure for Data Driven Testing using SOAP Request ‘jxl.jar’ is the jar file which supports all Excel operations, this jar supports only ‘.xls’ format. For example: ‘C:\Program Files\SmartBear\SOAP UI\lib’.Download jxl.jar and place it in lib folder of SoapUI.Download and install the open source version of SoapUI from their website.Here in this case, we’re automating data driven tests with options that are available in the open source version of SoapUI. Additionally, users can download SoapUI Pro, which is a licensed tool that provides great options and simpler ways to automate data driven tests. To automate web services, we are using SoapUI, which is one of the world’s most widely used open source API testing tool.
In this blog post, we’ll understand how to perform data driven testing using SoapUI’s open source version with Groovy and Microsoft Excel as datasource.