top of page
hand-businesswoman-touching-hand-artificial-intelligence-meaning-technology-connection-go-

Part 2- Data Driven Testing -SoapUI Pro/Ready API Data Sink -Data Driven and Save Result

In Part 1 , we learnt about how to do Data Driven Testing using Excel in Brief .

https://www.numpyninja.com/post/data-driven-testing-soapui-pro-ready-api-part-1-using-excel , So in this blog , we will learn how to do data driven testing using Text File, Grid,,, .



What types of testing are supported by SoapUI?

SoapUI can be used for complete RESTful API and SOAP Web Service testing. You can do Functional Testing, Performance Testing, Interoperability Testing, Regression Testing and much more.


Common Steps to do for Data Driven


1. Create Project

Give URL

2. Create New Test Suite

Test Case

Request

3. Add Data Source

Add Data source [ Excel , Text file, Grid, Data Generator , JDBC]

Add Properties

4. Add Data Source Loop

5. Set Request

Get Properties [ select Property from Data Source]

6. Set Response

Get Properties [ select Property from Data Source]

7. Run the Test Case


we can do Data driven using following Sources

  • Data Driven Testing Using Text File

  • Data Driven Testing Using Grid

  • Data Driven Testing Using Data Generator

  • Data Driven Testing Using JDBC(MySQL Database)


Data Source

  • For Text file [ , for separator ]

  • For Grid [Internal Component available in Ready API]

  • For Data Generator [Inbuilt feature in Ready API]

  • For JDBC [ Connect to database using driver]


WSDL URL

https://ws.footballpool.dataaccess.eu/info.wso?wsdl

select WSDL Definition ( SOAP)


Data Driven using Text File


Argentina,AR

Australia,AU

Belgium,BE

Brazil,BR

Colombia,CO



Structure of the Project


Add Data Source

Data Source -Drop Down select File

Add Properties

Give text document file path

Mention < , > as separator


Run To download the Data from Text File



Set Request

Get Properties [ select Property from Data Source]

Test Suite -> Test Case-> Test Step -> Properties

${Data Source#countryname}

Set Response

ISO Code->validate -> Select Content->Test Suite ->Test Case->Test Step->Properties



Add Data Source Loop

Take data from source for the Countries Request



Run The Test Case

Successfully Ran Data driven using Text File



Data Driven Using Grid

Grid is internal component available in Grid

Add Data manually in Configuration

Data Source -Drop Down select Grid


Set Request

Get Properties [ select Property from Data Source]

Test Suite -> Test Case-> Test Step -> Properties

${Grid Data Source#countryname}

Set Response

ISO Code->validate -> Select Content->Test Suite ->Test Case->Test Step->Properties




Add Data Source Loop



Run the Test Case



Data Driven Using Data Generator


Data Generator is in-built feature in Ready API, by which we can generate our own data

Test Data will be maintained within Ready API

Data Source -Drop Down select Data Generator

Select Type Country only from dropdown

It has default property name



Set Request

Get Properties [ select Property from Data Source]

Test Suite -> Test Case-> Test Step -> Properties

${DataGenData Source#countryname}

Set Response

Response also Country Name , No ISO Code , as in dropdown Data Generator , you can add only the property given be SoapUI




Add Data Source Loop


Run The Test Case -Data Driven Using Data Generator




Data Driven Using JDBC


Java Data base connectivity to pass data to the request

Ready API connect to database using Driver

Download sql connector


File -> Preferences -> JDBC Preferences

Select MySQL/com.mysql.jdbc.Driver



Settings

Driver

Connection String

Password

SQL Query



Configure Database


Sql Query

Write SQL query


MySql DataBase



Set Request

Get Properties [ select Property from Data Source]

Test Suite -> Test Case-> Test Step -> Properties

${JDBC Data Source#CountryName}


Set Response

ISO Code->validate -> Select Content->Test Suite ->Test Case->Test Step->Properties





Data Source Loop



Run the Test Case



Data Sink Step

URL : http://www.dneonline.com/calculator.asmx

Data Driven and save result in file

Here we can create our test case and write /save result into some external file like text , Excel ...

Test Suite

Test Case

Add Request Step


Request and Response for Add


To Add multiple sets of data , we have to do Data driven

Test Suite

Test Case

Data Sink Data source

Add

Property Transfer 1

Data Sink

Data Sink Data Source Loop


Excel File with column A and column B which has inputs for Addition Calculation

Results will be saved in Addition Column


Add Data Data Source Excel

Excel Path, Sheet1, A2

Add property A and B

Run to download column A data and column B data


Add Data Source Loop



Set Request

Get Properties [ select Property from Data Source]

Form->Test Suite -> Test Case-> Test Step (Data Source) -> Properties (A)

Form->Test Suite -> Test Case-> Test Step (Data Source) -> Properties (B)

${DataSink Data Source#A}

${DataSink Data Source#B}




To write the result in the same excel sheet in third column

  1. Data sink Step

  2. Property transfer


Add Data Sink

Property : Addresult

Data Sink : Excel

Cell : C2(column c, row 2)








We have to run and get the response , from response get the Addresult and write the result in excel file


Set Response

Outline->AddResult -> Property Transfer Step

Property Transfer=Output of one request is transferred as input for another request , so transfer the result output to DataSink




Give Property Name