Dynamically compare Rest XML/JSON response and JDBC using groovy array in SoapUI -


in soapui, have jdbc test step returns following data:

<results> <resultset fetchsize="128">     <row rownumber="1">         <id>1</id>         <name>testname1</name>         <description/>         <type>bool</type>         <isproducttag>true</isproducttag>         <islocationtag>false</islocationtag>         <subsection>default sub section</subsection>         <section>default section</section>         <subgroup>default sub group</subgroup>         <group>default group</group>     </row>     <row rownumber="2">         <id>2</id>         <name>testname2</name>         <description/>         <type>bool</type>         <isproducttag>true</isproducttag>         <islocationtag>false</islocationtag>         <subsection>default sub section</subsection>         <section>default section</section>         <subgroup>default sub group</subgroup>         <group>default group</group>     </row>     </row> </resultset> 

i have rest api xml response contains following data:

    <arrayoftaginfo>    <taginfo id="1" name="testname1" type="bool" isproducttag="true" islocationtag="false" subsection="default sub section" section="default section" subgroup="default sub group" group="default group"/>    <taginfo id="2" name="testname2" type="bool" isproducttag="true" islocationtag="false" subsection="default sub section" section="default section" subgroup="default sub group" group="default group"/> </arrayoftaginfo> 

i able compare(assert) both database values , response values (response can in xml or json depending on request accept header) using groovy arrays if possible data returned database can large.

can help?

if have soapui-pro, should able accomplish no groovy.

  1. make rest call retrieve data.
  2. start datasource step parses xml.
  3. make jdbc call select correct id of row want verify. make assertions in here.
  4. loop #2.

Comments