How to get array number with groovy script in SoapUI?

Question

I want to assert the value of a property in Json response with the use of Groovy script in SoapUI. I know a value for name but I need to know on which position the id is.

json response example:

{  
   "names":[  
      {  
         "id":1,
         "name":"Ted"
      },
      {  
         "id":2,
         "name":"Ray"
      },
      {  
         "id":3,
         "name":"Kev"
      }
   ]
}

Let's say I know that there is a name Ray, I want the position and the id (names[1].id)

Do you want to find the `id` value if the name is `Ray`? – Rao Jun 23 '16 at 15:44 — Rao, Jun 23 '16 at 15:44
Don't worry, added my answer, please check. – Rao Jun 23 '16 at 16:04 — Rao, Jun 23 '16 at 16:04

Rao · Answer 1 · 2016-06-23T16:03:40.797

1

Here is the script to find the same:

import groovy.json.*
//Using the fixed json to explain how you can retrive the data
//Of couse, you can also use dynamic value that you get 
def response = '''{"names": [ { "id": 1, "name": "Ted", }, { "id": 2, "name": "Ray", }, { "id": 3, "name": "Kev", } ]}'''
//Parse the json string and get the names
def names = new JsonSlurper().parseText(response).names
//retrive the id value when name is Ray 
def rayId = names.find{it.name == 'Ray'}.id
log.info "Id of Ray is : ${rayId}"

//Another way to get both position and id
names.eachWithIndex { element, index ->
  if (element.name == 'Ray') {
    log.info "Position : $index, And Id is : ${element.id}"
  }
}

You can see here the output

edited Jun 23 '16 at 16:03

answered Jun 23 '16 at 15:53

Rao

20,781
11
57
77

@trans, did you get chance try? – Rao Jun 24 '16 at 15:05
this might throw null pointer exception in case there is no match in the comparison with "Ray" – Rami Sharaiyri Feb 13 '18 at 18:53

How to get array number with groovy script in SoapUI?

1 Answers1