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

Question

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.
&nbsp;
"result":[{
     "location": "Sydney",
     "minStudentAge": 13,
     "schoolType": "Business",
     "rating": 5,

},
        {
     "location": "Sydney",
     "minStudentAge": 16,
     "schoolType": "Business",
     "rating": 3,

},
        {
     "location": "Sydney",
     "minStudentAge": 18,
     "schoolType": "Business",
     "rating": 1,

},
        {
     "location": "Sydney",
     "minStudentAge": 16,
     "schoolType": "Business",
     "rating": 2,             }
      ]
So every node is having a value named "Rating" and i need to validate whether the return json contains data on correct order. Rating top (5) should be at the top of the list and rating low (1) should be at the bottom of the list.
&nbsp;
I did somthing&nbsp;like this,&nbsp;
&nbsp;
import com.eviware.soapui.support.XmlHolderimport net.sf.*;import net.sf.json.*;import net.sf.json.groovy.*;
def groovyUtils = new com.eviware.soapui.support.GroovyUtils(context)
//Getting response from methodsdef response = context.expand( '${Schools#Response}' ).toString()
&nbsp;
&nbsp;
But after this what should i do?

jhunt · Accepted Answer

Hi, It just looks like you didn't put in the correction I mentioned in my second post above.Attached is a project with a working example.

jhunt · Answer

Use JsonOutput like this:
import groovy.json.JsonOutput

Map mySomething = ["abc": "def"]
String j = JsonOutput.toJson( mySomething ) assert j == '{"abc":"def"}'
As for with and it:
&nbsp;
String x = "abc"x.with {&nbsp;&nbsp;&nbsp;&nbsp; assert it == "abc"&nbsp;&nbsp;&nbsp;&nbsp; assert it == x; &nbsp;&nbsp;&nbsp;&nbsp; assert it.is(x)&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;}
So:
String unsorted = new groovy.json.JsonSlurper() // returns a JsonSlurper .parseText(messageExchange.responseContent)    // call parseText method on the JsonSlurper, returns a type of Map ."result"                                      // call the getAt method on the Map, returns a ListArray in this case
 .with { groovy.json.JsonOutput.toJson( it ) }  // calls toJson with the ListArray as argument, returns a String                                                // String is assigned to variable 'unsorted'
Equivalent to doing this:
String unsorted = groovy.json.JsonOutput.toJson (
    new groovy.json.JsonSlurper()
    .parseText(messageExchange.responseContent)
    ."result"
)

jhunt · Answer

You could use this as a Script Assertion:
&nbsp;
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
&nbsp;
&nbsp;

chathurad · Answer

Thanks for the quick responce , Let me try this.

jhunt · Answer

Hi, did you get a notification for my edit? Should be messageExchange.responseContent instead of messageExchange.response.

chathurad · Answer

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)
&nbsp;
I tryed to execute your code But.
Im getting this error. Any idea?
&nbsp;
This is the exact API.
&nbsp;https://a31k83hfp9.execute-api.us-east-1.amazonaws.com/dev/schools?filterParams=default&nbsp;

Forum Discussion

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

7 Replies

Related Content

Sorting data in JSON response for comparison

Testing for ascending sort

validating REST response against JDBC response

Validating current response against previous response?

How to validate whether an array of objects in the response is sorted by a field ??

Recent Discussions

clone TestSuite fails when there are more project with the same name

Will SOAP UI 5.6.1 work with JDK 8

SOAP Request works in SoapUI, but not in C# code

How to configure Swagger in Paas to use it in Oracle APEX instance.

log4j1.x vulnerability