Forum Discussion

richie's avatar
richie
Community Hero
8 months ago

GroovyScript - Extract specific number of attribute values from variable content response

Hey! I've checked my groovy script notes which contains essentially all the groovy script snippets people have ever helped me with over the years - mostly from nmrao if I'm being honest - but I hav...
Scripting
  • nmrao's avatar
    nmrao
    8 months ago

    richie 

    You can quickly try this groovy to understand how this can be achieved in general.

    Follow inline comments:

    def range = 1..10

println "Items in the range: $range"


def startingIndex=0

//Set this value, how many values to be stored 
def endIndex=4

//This is to ensure not to grab more than present in the list
assert endIndex <= range.size(), 'Choose the endIndex less than list size'

//Now get the sub list from original list
def mySubList = range.subList(startingIndex,endIndex)
println mySubList

//In order to save data as custom property, coierce it to String
def mySubListToString = mySubList.join(',')
println mySubListToString //Save this at suite level

//Convert string back to list when needed later
def stringToList = mySubListToString.split()
println stringToList

    If running the above from the ReadyAPI / SoapUI, use log.info instead of println

    Hope you knew how to store mySubListToString into Test Suite custom property.

    Note that all the properties in ReadyAPI are stored as string.

  • nmrao's avatar
    nmrao
    8 months ago

    richie 

    All it needs here is to replace

    def range = 1..10

    with

    def json = new groovy.json.JsonSlurper().parseText(context.response)

    def range = json.data.id.findAll()

    Change endIndex value depending on how many values that you need. 

    In order to store values at test suite level, add below statement at line number 20.

    context.testCase.testSuite.setPropertyValue('MY_SUBLIST', mySubListToString)

     

    And lines #22, 23, 24 are not needed here i.e., script assertion, as those to fetch and convert string to list. Instead use the when you need those values later.

    By the way, first it requires to fetch the MY_SUBLIST value stored at test suite level, so add below statement before using those lines.

    def mySubListToString = context.testCase.testSuite.getPropertyValue('MY_SUBLIST)

    Now it has all code it required with your data to achieve what is mentioned in the original question.

    NOTE: I am referring the line numbers here in this response from my original response's code.

richie's avatar
richie
Community Hero

Ah nmrao  - that is brilliant man - really - I can use this and extend it for loads of stuff I'm working on - and yeah - I remember ReadyAPI groovy log.info rather than other groovy/java println and I'm good extracting to testsuite property and I've been casting between numerics and strings using .toInteger() / .toString() methods on a number of scripts I've been working on in the last week  - it was EVERYTHING else up to that point I was stuffed on. ;) 

again - you are a Life Saver!

cheers,

rich

richie's avatar
richie
Community Hero
8 months ago

Hey nmrao 

Ok - I'm still struggling - if I'm understanding the code correctly - your code starts off as follows via a Script Assertion:

def json = new groovy.json.JsonSlurper().parseText(context.response)
log.info json

def startingIndex=0

//Set this value, how many values to be stored 
def endIndex=4 

assert endIndex <= range.size(), 'Choose the endIndex less than list size' 

//Now get the sub list from original list 
def mySubList = range.subList(startingIndex,endIndex) 
log.info mySubList

//In order to save data as custom property, coierce it to String
def mySubListToString = mySubList.join(',')
log.info mySubListToString //Save this at suite level

so the JSONPATH of the first route_code out of the 4 I care about is  x.json.data[0].route_code

HOW do I match the startingIndex variable (which you've got declared above) to json.data[0].route_code) so that the other 3 route_code values (with values json.data[1].route_code, json.data[2].route_code, json.data[3].route_code) are extracted also?

Your comment on the line declaring the mySubListToString variable is the bit where I save my data as a custom testsuite property - but at this point I've got no data - I haven't yet extracted the x number of route_codes (4 in the case of the above script defined by the endIndex variable) - this is the bit I'm struggling with.

 

Just so you know I'm not just letting you do all the heavy lifting without trying to solve myself - I did try playing around with the following to see if I could get a little further along (or at least increase my understanding) - cos the code below is based on what you've helped me out with before - I was hoping I could edit it to do what I need, but it only logs the first instance of the route_code value - I thought lines 5 & 6 might extract all the route_codes - but I realised I'm not using the it() method - I did try adding .it() in various places but I couldn't get it to work - I really need to buy a groovy for dummies book!

// Log the first route_code
log.info('First (index zero) route_code = ' + json.data[0].route_code)

// Log all route_codes
json.data.every{ prop ->
	log.info('route_code = ' + prop.route_code) 
}

// Log all route_code with index
json.data.eachWithIndex(){ prop, idx ->
	log.info('route_code ' + idx + ' = ' + prop.route_code)
}

Been years since I've used ReadyAPI! when you were helping me with my groovy before and it's really showing!

As always - appreciate your help!

Cheers,

Rich