Using comma separated JSON(CSVSON), JSON PATH, EXCEL FUNCTION and JSON Object.
Add your JSON expected response in the ResponseContent column. It helps to perform contract testing as well.
Add all key and value with comma separated values under the ResponseByFields column in the excel. Idaithalam will validate specific fields in the response using key value pairs. Key is your JsonPath and values is Expected value.id=[petId];name=[petName]; <json-path>=<value>
Compare the API response with given CSV. CSV would be converted as JSON and compared with the Actual Response.
Add following entry in the Csvson column
Example:
|ppu,name,toppings,id,type | |d~0.55,Cake,i~5001\|i~2001\|,0001,donut |