CODEWITHSUNDEEP
jmeterperformance-testingload-testing
Raam
Raam

Reputation: 1

JMETER: Need to send all entries in a CSV file to HTTP request body in 'one' request

I'm trying to solve a test data issue in Jmeter. Can anyone of you have a look at below problem statement and advise here please ?

Requirement: Need to send all entries in a CSV file to HTTP request body in 'one' request to the end point.

Example CSV File:

"adsfas123wsf00000wqefqwe52145t10000",
"fdfrgvergq120947r0000dwsfqwaef237sadf",
"wfrqwef7865034r78tkahsefjh6985r7asfdaf",
"qefqwe52145t10000adsfas123wsf00000w",
"wsfqwaef237sadffdfrgvergq120947r0000d"

HTTP Request Body: ["${data}"}]

When the data is substituted, I should be able to get below output.

[
"adsfas123wsf00000wqefqwe52145t10000",
"fdfrgvergq120947r0000dwsfqwaef237sadf",
"wfrqwef7865034r78tkahsefjh6985r7asfdaf",
"qefqwe52145t10000adsfas123wsf00000w",
"wsfqwaef237sadffdfrgvergq120947r0000d"
]

Problem Statement: When I use CSV data set config. file, I'm unable to concatenate all entries into one single request body. My understanding is, CSV data set config. the file is not the right option here.

Did some search in StackOverflow and followed a method to achieve above using JSR223 PreProcessor' and the link is, How to send multiple json body using jmeter?.

Followed the above link and tried added below custom code provided.

def builder = new StringBuilder()
new File('/path/to/plans.csv').readLines().each { line ->
    builder.append(new File(line).text).append(System.getProperty('line.separator'))
}
sampler.getArguments().removeAllArguments()
sampler.addNonEncodedArgument('', builder.toString(), '')
sampler.setPostBodyRaw(true)

Upon running, I get below error message,

Caused by: java.io.FileNotFoundException,
"adsfas123wsf00000wqefqwe52145t10000",
"fdfrgvergq120947r0000dwsfqwaef237sadf",
"wfrqwef7865034r78tkahsefjh6985r7asfdaf",
"qefqwe52145t10000adsfas123wsf00000w",
"wsfqwaef237sadffdfrgvergq120947r0000d" (The filename, directory name, or volume label syntax is incorrect)

If the file is not found, then how come the entries are read and displayed in the log viewer?

Also, how do I link the output of custom code to the request body? Or is it taken care of by the custom code itself?

Upvotes: 0

Views: 2034

Answers (2)

CarlosG
CarlosG

Reputation: 51

Two steps:

  1. Add a User Parameter Pre-processor before the HTTP request:

Name: DATA

User_1: ${__FileToString(/path/to/plans.csv,,)}

  1. Add the following to request body:

${DATA}

Upvotes: 0

Dmitri T
Dmitri T

Reputation: 168197

You have an error in your code, change this line:

builder.append(new File(line).text).append(System.getProperty('line.separator'))

to this one:

builder.append(line).append(System.getProperty('line.separator'))

If you want to send the full contents of the file you don't even need to go for scripting, you can use __FileToString() function right in the "Body data" tab of the HTTP Request sampler:

${__FileToString(/path/to/plans.csv,,)}

enter image description here

And last but not the least if you need to generate JSON from the plain text it might be a better idea to go for JsonBuilder class, see Apache Groovy - Why and How You Should Use It and Apache Groovy - Parsing and producing JSON

Upvotes: 0

Related Questions