For jmeter post request, how can I generate input json from csv file?

Question

I am trying to make a post rest call to my service. My sample input json file is,

{ "$id": "1", "description": "sfdasd" }

I have one csv file which contain a bunch of id and description, So is there a option where I can convert csv file to json objects and pass them to post call?

Answer 1

Assuming your CSV file is called test.csv, located in JMeter's "bin" folder and looks like:

1. Add CSV Data Set Config to your Test Plan and configure it as follows:

   

2. You can inline the defined JMeter Variables directly into your request body like:

   {
     "$id": "${id}",
     "description": "${description}"
   }
   

   

3. So when you run the test the variables placeholders will automatically be substituted with the values from the CSV file in the HTTP Request sampler:

   

See Using CSV DATA SET CONFIG article for more information on JMeter tests parameterization using CSV files.

Answer 2

Json is just text. Send as is with the variable id taken from csv:

 { "${id}": "1", "description": "sfdasd" }