Testing RESTful services JSON

[kamahade]

Hi all,
We have bunch of RESTful services. All are of type GET. We have reference data in Excel format which contains data we expect in RESTful GET response.

We do not know how to compare the GET method response with the data in Excel sheet. Adding assertions ( contains, NOT contains) type for each node in response XML is NOT a wise solution.

We would like to automate that comparison. Any idea will be useful

[KeyofSea123]

I know that this is 2 years old but it didn't received any responses.

We have done this for SOAP and REST using Groovy script. I'm pretty new to this but I'd be happy to share what I know.

Trish