Jmeter extracting fields/parsing JSON response

Question

I have following JSON format in response body

[
    {
        "Name" : "Prashant",
        "City" : "Sydney"
    },
    {
        "Name" : "Yogi",
        "City" : "London"
    }
]

What is the better way for checking if this array has any records and if yes give me "Name" for first array index. I am using jp@gc JSON extractor plugin for jMeter.

Is it possible to parse this using a plugin or do I need to do it using regular expressions?

Answer 1

Using Ubik Load Pack JSON plugin for JMeter which is part of JMeter since version 3.0 (donated plugin) and called JSON Extractor, you can do it:

Test Plan overview:

ULP_JSON PostProcessor:

If Controller:

And here is the run result:

So as you can see it is possible with plain JMeter

If you're looking to learn JMeter, this book by 3 developers of the project will help you.

Answer 2

I am not sure about your plugin but if it supports JSON path expressions it should be possible.
Try with this expression: $.[0].Name.

This is the plugin I use: http://jmeter-plugins.org/wiki/JSONPathExtractor/ and given expression works with it.

You can find more about JSON Path expressions here: http://goessner.net/articles/JsonPath/index.html#e2.

Answer 3

Working with JSON in JMeter is not quite easy as JMeter was designed long ago before JSON was invented. There are some extensions however that make life easier:

http://www.ubik-ingenierie.com/blog/extract-json-content-efficiently-with-jmeter-using-json-path-syntax-with-ubik-load-pack/

Answer 4

We can add a regular expression extractor for fetching the value from the response.

Like This: