How to automate webservices with dynamic response using SOAP UI ?

Hi all,

Currently I am facing an challenge in automating the web services using SOAP UI. The response of the web service request, that is being tested,  is not going to be same all the time because of the daily batch job runs and the DB refresh that will be happen at frequent.

So currently we are hitting the DB with few SQL queries (through groovy scripting) and then validate the response against the SQL result values.

The coding time taken is almost equivalent to the development effort and hence thought of using some techniques to make the SOAP response static, to bring down the coding time.

Kindly suggest us a solution for the above mentioned issue.

Thanks in advance !