Validate the response from the RESTAPI request against the response from the JDBC step

Question

I am new to SOAPUI. I need help to validate in other words groovy script to assert the response from the REST API request against the response from the JDBC step. Could someone help me with this?

nmrao · Answer

May be you have a look at this to get an idea, then you can implement how you want.

http://stackoverflow.com/questions/31472381/dynamically-compare-rest-xml-json-response-and-jdbc-using-groovy-array-in-soapui/35706976#35706976

jesb · Answer

Thank you! but, does it mean that I should have separate groovy step or the groovy assertion in the JDBC and REST API step. And, in the link you shared, I did not understand how the response from each step is retrieved.&nbsp;My REST API response is in XML:&nbsp;&nbsp;&lt;himUser updatedDate="2016-05-25T08:19:42Z" specialty="Nephrology" siteName="Westside - L - 03" siteId="8" login="AKSi79i" speakerCode="BJAi79i"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;address state="Karnataka" zipCode="560078" country="India" city="Bangalore" street1="Magrath Road"/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;contact phoneNumber="9709606"/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;person prefix="Dr." middleName="J1" lastName="spkr123" firstName="Syn123"/&gt;&nbsp;&nbsp; &lt;/himUser&gt;&lt;/himUsers&gt;&nbsp;&nbsp;And, the JDBC response is like:&nbsp;&nbsp; &lt;Row rowNumber="7"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;SPEAKERCODE&gt;BJAi79i&lt;/SPEAKERCODE&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;LOGIN&gt;AKSi79i&nbsp;&lt;/LOGIN&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;UPDATEDDATE&gt;2016-05-25 04:19:42.603&lt;/UPDATEDDATE&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;BUSINESSENTITYID&gt;8&lt;/BUSINESSENTITYID&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;SHORTNAME&gt;Westside - L - 03 &lt;/SHORTNAME&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;DESCRIPTION&gt;Nephrology&lt;/DESCRIPTION&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;STREET1&gt;Magrath Road&lt;/STREET1&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;STREET2/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;CITY&gt;Bangalore&lt;/CITY&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;COUNTRY&gt;India &lt;/COUNTRY&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ZIP&gt;560078&nbsp; &lt;/ZIP&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;STATE&gt;Karnataka&lt;/STATE&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;FIRSTNAME&gt;Syn123&lt;/FIRSTNAME&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;LASTNAME&gt;spkr123 &lt;/LASTNAME&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;MIDDLEINITIAL&gt;J1&lt;/MIDDLEINITIAL&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;SUFFIX/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PREFIX&gt;Dr.&lt;/PREFIX&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;EMAILADDRESS/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PHONE&gt;9709606&lt;/PHONE&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Row&gt;&nbsp;&nbsp;

nmrao · Answer

Can you provide input what is not cleared in the link provided. It clearly says the steps used including its type. Yes, it is a groovy step, what is confusion?

As told earlier, you need to create the model according to your suite. What I gave you will address to that specific issue. But you can make changes as you required. Then compare.

Forum Discussion

Validate the response from the RESTAPI request against the response from the JDBC step

Related Content

validating REST response against JDBC response

Validating current response against previous response?

Parse a JSON Response Using Groovy

Swagger Response In Array

$ref in response example relative to response example

Recent Discussions

How do I change password and Username on every call in a Test Case in SoapUI?

Content-Length calculation wrong when posting UTF-8 content

Error exception in phase 'semantic analysis' with java 21

Generate positive long integer?

How to test gi forms used in Intalio BPM process.