SoapUI Mocks : Automated response from CSV files

When you have hundreds of responses for an operation within a mockService it can be very difficult to search and modify them. This dificulty increases with the number of people who are working on the same project at the same time trying to edit these responses. Having the responses in an easy editable CSV file is much convinient. To achieve this goal we have found a solution which has been described below : 

Step 1 : Update Mock Service

Update the mockService to validate the incoming request for conformity of the request. You can refer to topic "Soap Request Schema Validation : mock Services" to achieve this level.

Step 2 : Update Operation

Open the operation under mockService and put the script below under 

Here below is full script from the above screen

// Define CSV File location and Create Object to read CSV File
def csvFilePath = "C:\\DriveOther\\Trainings\\SoapUI\\mocktest.csv"
context.fileReader = new BufferedReader(new FileReader(csvFilePath))
def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def holder = groovyUtils.getXmlHolder ( mockRequest.requestContent)
def today = new Date()
holder.namespaces["com"] = "http://www.dummy.com/namespace1"
holder.namespaces["cus"] = "http://www.dummy.com/namespace2"
 
def param1 = holder.getNodeValue("//com:param1")
def param2 = holder.getNodeValue("//cus:param2")
def param3 = holder.getNodeValue("//cus:param3")
 
if ( param1 != null )
 param1 = param1.toUpperCase()
if ( param2 != null )
 param2 = param2.toUpperCase()
if ( param3 != null )
 param3 = param3.toUpperCase()
 
log.info("   myOperation : received request -- $param1 : $param2 ; param3 : $param3" )
 
// Read data from file
rowsData = context.fileReader.readLines()
int rowsize = rowsData.size()
String[] dataSet
 
for(int i =0;  i < rowsize;  i++)
{
    rowdata = rowsData[i]
    String[] data = rowdata.split(",")
    if(data[3].toUpperCase() == param3)
    {
      dataSet = data
      break;
    }
}
log.info (" Data : " + dataSet)
 
if (dataSet==null)
{
 return "ResponseUnknown"
}
else
{
 if(dataSet[4]=="0")
 {
  return "NominalResponse"
 }
 else
 {
  return dataSet[4]
 }
}

The above script search for the requested data in the CSV file, if the data is found and value for "returnCode" column is "0" in the CSV file then it returns the "NominalResponse" otherwise returns the response which is mentioned in the place of returnCode under the CSV file. If both these case are failed then it returns "ResponseUnknown". 

Step 3 : Update the Response

The next step is to update the nominal response and parameterize the values with the actual results from the CSV file. Here a new search is made to the CSV file and corresponding data is fetched. Since we already know that the data exist in the CSV file hence no alternate is given, however you are free to improve this script as per your need.

Put the below script (need to udpated for each webservice and each operation) in the "Script" tab of the "NominalResponse". This script fetch the corresponding data from the CSV file and put it in place of the context variables which are used in the response.

// Define CSV File location and Create Object to read CSV File
def csvFilePath = "C:\\DriveOther\\Trainings\\SoapUI\\mocktest.csv"
context.fileReader = new BufferedReader(new FileReader(csvFilePath))
def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def holder = groovyUtils.getXmlHolder ( mockRequest.requestContent)
def today = new Date()
def devStbLcd
holder.namespaces["com"] = "http://www.dummy.com/ns1"
holder.namespaces["cus"] = "http://www.dummy.com/ns2"
 
def param1 = holder.getNodeValue("//com:param1")
def param2 = holder.getNodeValue("//cus:param2")
def param3 = holder.getNodeValue("//cus:param3")
 
if ( param1 != null )
 param1 = param1.toUpperCase()
if ( param2 != null )
 param2 = param2.toUpperCase()
if ( param3 != null )
 param3 = param3.toUpperCase()
 
log.info("   GetDeviceFirstLastConnectionDates : received request -- $param2 : $param3 ; param1 : $param1" )
 
// Read data from file
rowsData = context.fileReader.readLines()
int rowsize = rowsData.size()
String[] dataSet
 
for(int i =0;  i < rowsize;  i++)
{
    rowdata = rowsData[i]
    String[] data = rowdata.split(",")
    if(data[3].toUpperCase() == param3)
    {
      dataSet = data
      break;
    }
}
log.info (" Data : " + dataSet)
context.returnCode = dataSet[4]
context.rfm = dataSet[5]
context.fcd = dataSet[6]
if(dataSet[7] == "0")
{
 devStbLcd = today
}
else
{
 devStbLcd = today - 365
}
context.lcd = devStbLcd.format("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'")

The above script has to be made common for all the common responses, if any special case response  is required then add the special case in the CSV file and in the response list and update the scripts according to your needs.