Jmeter extracting JSON format inside an Array

Question

I would like to seek an assistance how can I extract the value USDT on this sample response. Your response is highly appreciated. Currently this is how I extract my USDT using JSON Path tester $..currency[0]. I want to make it flexible without using number instead contains. is there's a way to simulate this? Thank you so much in advance

{
    "uid": "123-321",
    "period": "25_minutes",
    "level": "symbol",
    "values": [
        1.3211,
        1.2212
    ],
    "rank_by": "volume",
    "currency": [
        "USDT",
        "SGD"
    ],
    "measurements": [
        0.42,
        0.15
    ],
    "num_instruments": 20,
    "asset_classes": [
        "All"
    ],
    "version": "1.0.0",
    "timestamp": "2022-05-30T03:53:09"
}

Sample response I extracted:

Dmitri T · Accepted Answer · 2022-05-30 07:03:37Z

2

If you're uncertain about the order of currencies in the response you can consider

Switching to JSON JMESPath Extractor
Sorting the array alphabetically
Slicing the array to return only last match (USDT will be "lower" than SGD)

answered May 30, 2022 at 7:03

Dmitri T

169k5 gold badges91 silver badges149 bronze badges

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

1 Comment

Jyoti Prakash Mallick Over a year ago

nice dimtri, but what if YUN will be there ?

Jyoti Prakash Mallick · Accepted Answer · 2022-05-30 06:42:45Z

Dont have clue about JSON extractor, but can be done through the following method,

Add JSR223 Postprocessor as a child of the request which returns above JSON
Put the following code into "Script" area

Script Block:

 def jsonResponse = new groovy.json.JsonSlurper().parse(prev.getResponseData())
    jsonResponse.each { getCurrencyArray ->
            def currencyExpected = "USDT"
              if(getCurrencyArray.getKey() == "currency"){
                        getCurrencyArray.getValue().each { curr ->
                            if (curr.equalsIgnoreCase("USDT")) {
                                vars.put("Cur", currencyExpected )
                                log.info("Cur = " + currencyExpected)
                            }
                        }
              }
    }

With USDT:

With Multiple USDT:

Without USDT:

Akshay G · Accepted Answer · 2022-05-30 11:11:37Z

0

You can use the jsonpath-expression to check if the value exists in the array

$..currency[?(@ == "USDT")]

answered May 30, 2022 at 11:11

Akshay G

2,3501 gold badge19 silver badges35 bronze badges

Collectives™ on Stack Overflow

Jmeter extracting JSON format inside an Array

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related