How to retrieve the JSON value from multiple array response data using regular expression extractor in jmeter?

Question

{
    "response":
    {
        "responseData":
         {
             "createdDate":"2016-04-23 14:39:35",
             "modifiedDate":"2016-04-23 14:39:35",
             "catalogID":1009
         }
    }
}

Here is sample JSON data for reference. I need to extract the value of catalogID=1009. How to extract the value of catalogID?? can anyone please share your idea???

What is the regular expression to retrieve the catalogID??

jmeter allows jsonpath..use that only..its much better option than regex — rock321987
– rock321987, Commented Apr 23, 2016 at 9:33

Dmitri T · Accepted Answer · 2016-04-23 10:35:37Z

2

Use the following regular expression extractor configuration:

Reference Name: variable name of your choice, i.e. catalogID
Regular Expression: "catalogID":(\d+)
Template: $1$

Refer extracted value as ${catalogID} where required.

Few tips:

You can use View Results Tree listener in RegExp Tester mode to test your regular expressions against real response:

See How to debug your Apache JMeter script article for more details.
There is JSON Path Extractor available via JMeter Plugins which allows using JSON Path language (more handy than regular expressions when it comes to JSON), for example the relevant query to get "catalogID" will be as simple as:
```
$..catalogID[0]
```
There is also an online JSON Path Expression Tester

answered Apr 23, 2016 at 10:35

Dmitri T

169k5 gold badges91 silver badges149 bronze badges

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

1 Comment

tsr_qa Over a year ago

Thanks for ur effort but not working for this Regular Expression: "catalogID":(\d+) . I need to extract inside the array data. can u pls tell me the purpose of template ? and please add the screenshot for regular expression extractor page. I want know how ur gave the reg exp.

rock321987 · Accepted Answer · 2016-04-23 09:47:34Z

0

If you want to use regex, use

"catalogID":(.+?)

or

"catalogID":(\d+) <-- For only digits

You can also install the plugin JSONPath for jmeter and use this instead

$.response[0].responseData[0].catalogID

More info

edited Apr 23, 2016 at 9:47

answered Apr 23, 2016 at 9:41

rock321987

11.1k1 gold badge34 silver badges44 bronze badges

5 Comments

tsr_qa Over a year ago

I had used this "catalogID":"(.+?)" reg exp but it was not retrieve the value(1009). Json path extractor is not recommended in my organization.

rock321987 Over a year ago

@tsivarajan why are using quotes??There are no quotes in input after :

tsr_qa Over a year ago

i had tried both ways with quotes and without quotes. but its not working. Verify this link (eclipsesource.com/blogs/2014/06/12/…) in here they r using quotes.

rock321987 Over a year ago

@tsivarajan i think they are using quotes because there is quotes in input they have shown..try to capture any other thing and see if it works

tsr_qa Over a year ago

but i need to extract string as well as integer. can u pls share if u find any solution?

tsr_qa · Accepted Answer · 2016-04-23 11:59:00Z

0

I have found the solution for this question.

Here you want to extract the integer value means then use this requalar expression like "catalogID":(.*?),

String means "catalogID":"(.*?)",

Lets do it!

answered Apr 23, 2016 at 11:59

tsr_qa

6433 gold badges10 silver badges28 bronze badges

3 Comments

rock321987 Over a year ago

This is exactly what I had written in my answer and told you to do in comments and why ,?

tsr_qa Over a year ago

but u didn't mentioned , (comma). It will show error message without give the ,(comma). I don't no why its required.

rock321987 Over a year ago

its weird because the other answer also does not have ,

Collectives™ on Stack Overflow

How to retrieve the JSON value from multiple array response data using regular expression extractor in jmeter?

3 Answers 3

1 Comment

5 Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

5 Comments

3 Comments

Related