Forum Discussion

richie's avatar
richie
Community Hero
6 years ago

Verify a repeating attribute in .json response appears in ascending and descending order

Hi,   I have a GET request that interacts with a database retrieving records based on the URI/Template and Query Parameters in the URI string submitted and the response returned is in .json type....
  • nmrao's avatar
    nmrao
    6 years ago

    richie ,

     

    Does the below helps?

     

    //Define the ordered list which is in the same order of the values as expected
def expectedList = []

def response = context.expand( '${REST Request#Response}' )
def json = new groovy.json.JsonSlurper().parseText(response)

assert expectedList == json.data.Name
nmrao's avatar
nmrao
Champion Level 3
6 years ago
richie,

Not sure what you are expecting here.

The script is sorting to ascending (irrespective of the order in the response).

Any ways, please do below changes:

def response = context.expand( '${REST Request#Response#$[\'data\']}' )

to

def response = context.expand( '${REST Request#Response}' )

Another change is

def getPropertyValues = { prop ->
json.results."$prop"
}

To

def getPropertyValues = { prop ->
json.data."$prop"
}
  • richie's avatar
    richie
    Community Hero
    6 years ago

    nmrao 

     

    OH!

     

    Sorry fella - I thought the script asserted that the response was returned in a certain order - as you can see - there's plenty of the script I can't actually read - I didnt realise the script was actually doing the sorting!

     

    Apologies - that's not what I'm after.

     

    I have a requirement where I'm requesting the data back in either ascending or descending order relative to the queryparm I'm specifying (e.g. /api/1/{namespace}/{table}?_sort=tableAttribute desc)

     

    I thought your script actually ASSERTED the response was in ascending order as this is what I need to verify,

     

    my bad!

     

    richie

    • nmrao's avatar
      nmrao
      Champion Level 3
      6 years ago
      More over, it was not even reading your data at all, forget about sort order. Because that was tailored for original question.

      • richie's avatar
        richie
        Community Hero
        6 years ago
        Hahaha!

        What a dunce.....what can i say? I'm definitely making progress with my groovy, but it's very slow going!

        But actually it's a lot more elegant than using the otb functionality....totally changed my opinion....im trying to do everything with groovy now! ;)

        Nice one!

        richie