JMeter populate nested json request body using CSV DataSet

Question

I'm generating http requests in JMeter using CSV dataset. I'd like to generate nested json like the following one:

{
  "name": "some_name",
  "from": {
    "lat": 20.1,
    "lng": 32.5
  }
  "to": {
    "lat": 41.2,
    "lng": 54.8
  }
}

I parametrized http sampler request body looks as follows in JMeter:

{
  "name": "${name}",
  "from": {
    "lat": ${from_lat},
    "lng": ${from_lng}
  }
  "to": {
    "lat": ${to_lat},
    "lng": ${to_lng}
  }
}

Test data set is as follows:

name,from_lat,from_lng,to_lat,to_lng
some_name,20.1,32.5,41.2,54.8

Instead of required json JMeter compose the following:

{
  "name": "some_name",
  "from": {
    "lat": ${from_lat},
    "lng": ${from_lng}
  }
  "to": {
    "lat": ${to_lat},
    "lng": ${to_lng}
  }
}

What do I need to do to make JMeter substitute the from_lat,from_lng,to_lat,to_lng parameters?

Rohit Rohit · Accepted Answer · 2018-05-29T11:41:05

Make sure you set ignore first line only set to true , as you are adding column names in the dataset, here is my CSV config file settings

and the result

You can refer this blog

For more info on CSV config Follow this link