Jmeter : How to extract first element from json array

Question

I am trying to extract first element from a json array. Below mentioned is json array

   [
    {
        "cohortDefinition": {
            "Key": 1151,
            "id": 1798,
            "srcId": "3526",
            "pcKey": -1,
            "userName": "CHROME_USER",
            "name": "JMeter2017-01-06-1483749546167",
            "Type": "SUBJECT",
            "tool": "CB",
            "count": 32757,
            "extractionStatus": "",
            "dateCreated": "2017-05-10T17:48:45Z"
        },
        "datasource": {
            "id": 2,
            "name": "health",
            "subjectCount": 116352
        },
        "project": {
            "id": 747,
            "name": "Jmeter Project"
        }
    },
    {
        "cohortDefinition": {
            "Key": 1150,
            "id": 1796,
            "srcId": "3525",
            "pcKey": -1,
            "userName": "CHROME_USER",
            "name": "JMeter2016-10-27-1477620919644",
            "Type": "SUBJECT",
            "tool": "CB",
            "count": 32757,
            "extractionStatus": "",
            "dateCreated": "2017-05-10T16:57:11Z"
        },
        "datasource": {
            "id": 2,
            "name": "health",
            "subjectCount": 116352
        },
        "project": {
            "id": 747,
            "name": "Jmeter Project"
        }
    }
]

From above json i would like to extract first value ie. srcId": "3526". I tried doing following expression in Jmeter extractor

$..cohortDefinition.srcId[1]

However it is not working. If anyone know how to do this please do let me know.

Use $..cohortDefinition.srcId in the JSON Path Extractor. myVar_1 will have the first srcId. — NaveenKumar Namachivayam
– NaveenKumar Namachivayam, Commented May 10, 2017 at 22:59
Yes. You need to use myVar_1 in your test plan which will retrieve first srcId. — NaveenKumar Namachivayam
– NaveenKumar Namachivayam, Commented May 10, 2017 at 23:55
Please check this image imgur.com/a/rzA8p and imgur.com/a/8rFfd — NaveenKumar Namachivayam
– NaveenKumar Namachivayam, Commented May 10, 2017 at 23:56

UBIK LOAD PACK · Accepted Answer · 2018-04-12 20:14:34Z

3

After JMeter 3.0, you can use JSON Extractor, see:

https://stackoverflow.com/a/47043204/460802

Before JMeter 3.0:

Please follow the below steps to retrieve srcId.

Add a JSON Path Extractor to your request and configure below values.

Destination Variable Name - myVar

JSON Path Expression - $..cohortDefinition.srcId - this will extract all the srcIDs from the JSON.

Default Value - Not Found or Err

Add a Debug Sampler and View Results Tree to your test plan.
Save it and execute.
In Debug Sampler, you can view all the srcId as shown below.

You can now use myVar_1 and myVar_2 in your test plan using ${myVar_1} ${myVar_2}

edited Apr 12, 2018 at 20:14

UBIK LOAD PACK

34.7k6 gold badges76 silver badges118 bronze badges

answered May 11, 2017 at 3:30

NaveenKumar Namachivayam

1,2103 gold badges29 silver badges42 bronze badges

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

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

No need for Plugin, JMeter has a JSON Extractor that will provide this feature:

Notice:

JSON Path Expression is: $..cohortDefinition.srcId

Match No : 1

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 31, 2017 at 19:28

UBIK LOAD PACK

34.7k6 gold badges76 silver badges118 bronze badges

Collectives™ on Stack Overflow

Jmeter : How to extract first element from json array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related