Question about match more than one row from DB2 table with Rest webservice response
Is there any option in SOAtest to match more than one row from DB2 table with webservice response ( I have put multiple assertions to achieve this , but the problem I would see is if DB2 returned rows increased in future)
i was able to match one row from DB2 table with rest service response -
Current scenario –
Number of DB2 rows count - 3 rows and 2 columns = 6 values
Service response count - 3 * 2 = 6 values
Total assertions – 6 assertions to match values
Future possible scenario – let say we have inserted more rows and DB2 table count become 10 rows
Number of DB2 rows count - 10 rows and 2 columns = 20 values
Service response count - 10 * 2 = 20 values
Total assertions – 6 assertions ( since we have automated above test case with 6 assertions only)
Problem – only first 3 rows compared and reaming 7 rows skipped – I want compare all 20 values without adding insertions.
We can automate this by writing custom script or cucumber , but– is there any option to automate this kind of scenario in soatest ?
Spent considerable amount of time to find out option in SOAtest – nothing worked out