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

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


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

CSV Example Structure

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

    enter image description here

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

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

    JMeter HTTP Request

  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:

    enter image description here

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


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

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


CSV data can be converted to JSON via a POJO using Jackson. If a POJO is not already defined or required, you can always use the Java Collection classes to store parsed data and later convert it to JSON. http://www.novixys.com/blog/convert-csv-json-java/ is a good reference on how to convert csv to java.You can check the following links too.1. directly convert CSV file to JSON file using the Jackson library2. Converting an CSV file to a JSON object in Java