Forum Discussion

chathurad's avatar
chathurad
Contributor
7 years ago

How to assert or validate the sorting order of a response json data on SoapUI

For a get request im getting a json response and it contain some school data.The schools should be appear by descending order for the school rating number. Somthing looks like this.   "result"...
JHunt's avatar
JHunt
Community Hero

You could use this as a Script Assertion:

 

String unsorted = new groovy.json.JsonSlurper().parseText(messageExchange.responseContent)
 ."result"
 .with { groovy.json.JsonOutput.toJson( it ) }
 
String sorted =  new groovy.json.JsonSlurper().parseText(messageExchange.responseContent)
 ."result"
 .sort { -it."rating" }
 .with { groovy.json.JsonOutput.toJson( it ) }
 
assert sorted == unsorted

 

 

chathurad's avatar
chathurad
Contributor
7 years ago

Thanks for the quick responce , Let me try this.

  • JHunt's avatar
    JHunt
    Community Hero
    7 years ago
    Hi, did you get a notification for my edit? Should be messageExchange.responseContent instead of messageExchange.response.
    • chathurad's avatar
      chathurad
      Contributor
      7 years ago

      No signature of method: groovy.json.JsonSlurper.parseText() is applicable for argument types: (com.eviware.soapui.impl.wsdl.submit.transports.http.SinglePartHttpResponse) values: [com.eviware.soapui.impl.wsdl.submit.transports.http.SinglePartHttpResponse@13ad1457] Possible solutions: parseText(java.lang.String), parse(java.io.Reader)

       

      I tryed to execute your code But.

      Im getting this error. Any idea?

       

      This is the exact API.

       https://a31k83hfp9.execute-api.us-east-1.amazonaws.com/dev/schools?filterParams=default