Extracting Json response using Json extractor on Jmeter

Question

Is there's a way I could extract the highest id: "15" of bld-appliance-1 using Json Path expression. Currently if use this Json expression "[?(@.name == 'bld-appliance-1')]..id" it returns me 3 result. I'm also aware I could use Match No but my catch here is the response is DYNAMIC I don't know if the 1st, 2nd or 3rd and etc is the highest id upon invocation. Your response is highly appreciated. Thank you so much.

Sample Response:

[{

    "id": "5",
    "name": "bld-appliance-1",
    "hostName": "bld-appliance-1"
},

{
    "id": "10",
    "name": "bld-appliance-1",
    "hostName": "bld-appliance-1"
},

{
    "id": "15",
    "name": "bld-appliance-1",
    "hostName": "bld-appliance-1"
},
{
    "id": "20",
    "name": "test-appliance-1",
    "hostName": "test-appliance-1"
}, {
    "id": "25",
    "name": "uat-appliance-1",
    "hostName": "uat-appliance-1"
}

]

Dmitri T · Accepted Answer · 2023-04-16 15:22:26Z

0

You can do it using JSR223 PostProcessor and the following Groovy code:

def id = new groovy.json.JsonSlurper().parse(prev.getResponseData()).findAll {entry -> entry.name == 'bld-appliance-1'}.collect{entry -> entry.id as int}.max()

in case you need to store the result into a JMeter Variable you can add the next line:

vars.putObject('id', id)

More information:

answered Apr 16, 2023 at 15:22

Dmitri T

169k5 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extracting Json response using Json extractor on Jmeter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related