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?

score 20 · Accepted Answer · answered Jul 10 '17 at 05:09

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

Add CSV Data Set Config to your Test Plan and configure it as follows:
You can inline the defined JMeter Variables directly into your request body like:
```
{
  "$id": "${id}",
  "description": "${description}"
}
```
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.

is there a way, to use each line in a file as json request body data directly. (note: each line is a single json object with multiple key values and i dont want to declare each of the variables manually) — Gaudam Thiyagarajan, Apr 29 '20 at 16:15

score 1 · Answer 2 · answered Jul 08 '17 at 02:00

1

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

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

answered Jul 08 '17 at 02:00

Ori Marko

56,308
23
131
233

Where should this be added ? – Resham Wadhwa Sep 20 '20 at 14:32
Inside Body data – Ori Marko Sep 20 '20 at 14:36
The right syntax would be : { "id":${id},"description":${description}" }, this syntax will create the json as you have shown in your comment. That is not the syntax rather the output imo. Also, there won't be a dollar sign before id. – Resham Wadhwa Sep 21 '20 at 08:44

score 0 · Answer 3 · answered Jul 07 '17 at 23:00

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 library 2. Converting an CSV file to a JSON object in Java

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

3 Answers3