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
7 years ago

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