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
richie's avatar
richie
Community Hero

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
    • nmrao's avatar
      nmrao
      Champion Level 3
      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
      • richie's avatar
        richie
        Community Hero
        6 years ago

        hahahaha!

         

        Perfect!

         

        thanks man!

         

        richie