Forum Discussion

NK12's avatar
NK12
Occasional Contributor
7 years ago

Validating Json Response with DB Response

Hello All,   I need to test REST API- JSON Response with DB(SQL Server) Response How can I make it dynamically so that I can validate the JSON Response and DB Response   Currently I'm validati...
PaulMS's avatar
PaulMS
Super Contributor
7 years ago

An example comparing selected columns from DB query

 

Add a script assertion in the JDBC request step to set the property values

 

import com.eviware.soapui.support.XmlHolder
holder = new XmlHolder( messageExchange.getResponseContent() )

context.testCase.setPropertyValue( "Array IDs", holder["//Row/ID"].toString() )
context.testCase.setPropertyValue( "Array Names", holder["//Row/NAME"].toString() )

Then use JSONPath Match assertions

(in this case I converted ID to lower case to match the response)

JSONPath Expression  $..Id

Expected Result  ${="${#TestCase#Array IDs}".toLowerCase()}

 

JSONPath Expression $..Name

Expected Result  ${#TestCase#Array Names}