JMeter JSON path extract value without array brackets []

Question

I need the value out of an array, not the array brackets[ ]. Here is the JSON response I am trying to work with:

{
:   "@rpc":"1.0",
:   "@types":
:   [
:   :   "com.model.chart.PieChart",
:   :   "com.model.chart.PieChartData"
:   ],
:   "@data":
:   {
:   :   "@type":0,
:   :   "chartData":
:   :   [
:   :   :   {
:   :   :   :   "@type":1,
:   :   :   :   "data":0.0,
:   :   :   :   "name":"Yes"
:   :   :   },
:   :   :   {
:   :   :   :   "@type":1,
:   :   :   :   "data":13.0,
:   :   :   :   "name":"No"
:   :   :   }
:   :   ],
:   :   "subTitle":"Over Time Period",
:   :   "dataName":"MyData",
:   :   "title":"MyData Requirement"
:   }
}

I am trying to get just the data for the yes and no. So for no, I just want to get 13.0 but I continue getting [13.0] with the array brackets. Here are the values of JSONPath Expressions I have tried:

[email protected]..[?(@.name=='No')].data returns [13.0]

[email protected]..[?(@.name=='No')].data[0] returns nothing

[email protected]..[?(@.name=='No')][0].data returns nothing

[email protected][0]..[?(@.name=='No')].data returns nothing

I am using version 2.3 of the JSON plugin in my jmeter v 3.0. Any help is greatly appreciated.

Dmitri T · Accepted Answer · 2016-09-14 04:53:11Z

1

Option 1: looking into the Debug Sampler given you use data as a reference name and receiving [13.0] you can get 13 without brackets as ${data_1}
- Option 2: since JMeter 3.0 you have JSON Path PostProcessor which behaves a little bit differently and returns the data without square brackets:

answered Sep 14, 2016 at 4:53

Dmitri T

169k5 gold badges91 silver badges149 bronze badges

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

Comments

JmeterUser123 · Accepted Answer · 2017-06-04 15:54:57Z

1

I came across the same issue and using JMeter (version 3.2), I didn't get the square [] brackets. However, make sure you use "JSON Extractor" and not "jp@gc - JSON Path Extractor."

answered Jun 4, 2017 at 15:54

JmeterUser123

112 bronze badges

Collectives™ on Stack Overflow

JMeter JSON path extract value without array brackets []

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