Forum Discussion

avidCoder's avatar
avidCoder
Super Contributor
7 years ago

Re: Get the id of a parent element by a sub-child value of Json response using groovy

mpw83  - This is how you can go with it :-

 

import groovy.json.JsonSlurper

def json = '''{
   "items" : [
      {
         "id" : "48223",
         "name" : "LAI-00151007",
         "amount" : "25050.0",
         "interest_rate" : "25.99",
         "term" : "60",
      },
      {
         "id" : "48262",
         "name" : "LAI-00152581",
         "amount" : "44225.0",
         "interest_rate" : "18.9",
         "term" : "36",
      }
   ],
   "total_count" : "13"
}'''

def jsonSlurper = new JsonSlurper()
def obj = jsonSlurper.parseText(json)

obj.items.each{
	if(it.name == 'LAI-00152581'){
		log.info it.id
	}
}

nmrao  - You can also suggest better code.

3 Replies

  • nmrao's avatar
    nmrao
    Community Hero
    7 years ago

    Thats ok avidCoder .  It takes time to optimize. But,yes can simplifed as below entire script:

     

    def json = new groovy.json.JsonSlurper().parseText(context.expand( '${GetLoansList#Response}' ))
log.info json.items.find{it.name = 'LAI-00152581'}.id
  • nmrao's avatar
    nmrao
    Community Hero
    7 years ago

    Thats ok avidCoder .  It takes time to get into optimization. But,yes it can simplifed as below entire script:

     

    def json = new groovy.json.JsonSlurper().parseText(context.expand( '${GetLoansList#Response}' ))
log.info json.items.find{it.name = 'LAI-00152581'}.id