JMeter Beginner Tutorial 15 - How to read data from CSV file (Parameterisation)
Вставка
- Опубліковано 9 лют 2025
- more from Raghav - automationstep...
Step 1 : Add config element - CSV Data Set Config
Step 2 : Add details in CSV Data Set Config
Step 3 : Update value fields: ${variable_name}
Step 4 : Run and validate
----------- PERFORMANCE TESTING -----------
JMeter Beginner - bit.ly/2oBbtIU
JMeter Intermediate - bit.ly/2oziNVB
JMeter Advanced - bit.ly/2Q22Y6a
JMeter Tips & Tricks - bit.ly/2NOfWD2
Performance Testing - bit.ly/2wEXbLS
_______ ONLINE COURSES TO LEARN _______
Visit - automationstepb...
----------- UI TESTING -----------
Selenium Beginners - bit.ly/2MGRS8K
Selenium Java Framework from Scratch - bit.ly/2N9xvR6
Selenium Python - bit.ly/2oyMp5x
Selenium Tips - bit.ly/2owxc50
Selenium Builder - bit.ly/2MKNtlq
Katalon Studio - bit.ly/2wARFdi
Robot Framework - bit.ly/2Px6Ue9
----------- API TESTING -----------
Web Services (API) - bit.ly/2MGafL7
SoapUI - bit.ly/2MGahmd
Postman - bit.ly/2wz8LrW
General - bit.ly/2PYdwmV
----------- MOBILE TESTING -----------
Mobile Playlist - bit.ly/2PxpeUv
----------- CI | CD | DEVOPS -----------
Jenkins Beginner - bit.ly/2MIn8EC
Jenkins Tips & Trick - bit.ly/2LRt6xC
Docker - bit.ly/2MInnzx
----------- VERSION CONTROL SYSTEM -----------
Git & GitHub - bit.ly/2Q1pagY
----------- JAVA -----------
Java Beginners - bit.ly/2PVUcXs
Java Tips & Tricks - bit.ly/2CdcDnJ
----------- MAVEN -----------
Maven - bit.ly/2NJdDRS
----------- OTHERS -----------
Redis- bit.ly/2N9jyCG
Misc - bit.ly/2Q2q5xQ
Tools & Tips - bit.ly/2oBfwoR
QnA Friday- bit.ly/2NgwGpw
Sunday Special - bit.ly/2wB23BO
Ask Raghav- bit.ly/2CoJGWf
Interviews - bit.ly/2NIPPxk
All Playlists - bit.ly/2LSiezA
----------- Follow -----------
Facebook - / automationstepbystep
Twitter - / automationsbs
UA-cam - / automationstepbystep
Never Stop Learning
Raghav
Check online courses & training - automationstepbystep.com/
can you explain this concept with stepping thread group?
I must say to thank you for all your free and handy tutorials of Jmeter. Before 4 to 5 years I had automation skill along with Jmeter. I am working in a big MNC right now and in these 5 years MNCs never ever given me chance to continue my this skill and I forgot about it. You are helping me to get that confidence back and making me able to say them, Hey give me some automation work or Good Bye !!
Happy Guru Purnima 'The Teacher' :)
Deepak, I am so glad that this is helping you. Thanks for your message and Keep Learning. All the best.
Who does not like this. Your explanation is awesome
Thanks Venkata
hey Raghav, great tutorials loved it. Very simple explanation.
Thank you Raghav, your explanation is very good
awesome teaching thanks very well understood and practiced
You are welcome Elsie
Thanks for your Jmeter videos 👍
Glad you like them!
Nice explanation 😄
Thanks
Raghav, this session is great and your presentation as well. Can you please make a session on Beanshell post processor and how to export data from response json to csv file. Thanks in Advance
sure Akhil, will make it.
Raghav great tutorial.
thanks for watching.
Thanks a lot! You helped a lot, again!
You're welcome Patrycja
Great tutorial bro helped me a lot
Great to know Sai
Hi thanks for the video
I have one doubt as you mentioned that 3 rows are there so we took 3 iterations,
what if we take the iterations as infinite then it will repeating again again right.
Like 1,2,3 then 1,2,3... and so on infinitely right?
Gautam
Yes, you're correct. When you set the iterations to "Infinite" in the JMeter CSV Data Set Config, it will continuously repeat the rows in the CSV file, effectively creating an endless loop.
Here's a detailed explanation of how it works:
1. CSV Data Set Config Setup:
- You add a CSV Data Set Config element to your test plan.
- You specify the path to the CSV file containing the data rows.
- You set the "Recycle on EOF?" option to "True" (this is the default).
- You set the "Stop thread on EOF?" option to "False."
- You set the "Number of threads" (virtual users) to your desired value.
- You set the "Loop Count" to "Infinite."
2. Iteration Process:
- JMeter starts reading data from the CSV file, feeding it to each virtual user.
- When it reaches the end of the CSV file (EOF), it rewinds to the beginning and starts reading again, continuously repeating the rows.
- This cycle continues indefinitely, as long as the test is running and the "Loop Count" is set to "Infinite."
@@RaghavPal got it, thanks for reply.
Hi, You created new videos related to Rest and SOAP in Octrober 2020 so this tutorial num 15 is not making sense for me. Please guide me in this confusion.
Hi, I created new videos for API testing on JMeter as the old videos on that were outdated as JMeter does not have separate API sampler now.
Thank you so much it is working for me. Really appreciated.
You're welcome Vishal
Thanks for the Jmeter classes very useful
Can I know if we can have multiple excel sheets and access them?
Hi Nagma, you can, you can create multiple csv data set config for that, and add the data set config as a child of the request where you want to use the data
Hi Raghav, Do I need to parameterize login credentials(giving say 20 username and password in csv file, so that each login attempt will be from different user) when I do load testing for an application?
Hi Anila, it depends, usually people do this to get a realistic scenario. If the same user logs in there may be a chance of cache and memory built up, but that can be taken care by using Cache and cookie manager
@@RaghavPal Thanks Raghav. Cookie and cache can be managed by config elements right? But do we need to take care of SSO while attempting different logins? How can I give variable names like in this video?
Could you do a quick video on that? Please.
Hi Anila, although I will plan more sessions related to this. For now you can check - www.blazemeter.com/blog/how-load-test-saml-sso-secured-websites
@@RaghavPal Thank you so much Raghav. Much appreciated! Thanks for your fantastic tutorials.
Usted me ayuda en todo lo que necesito saber !!!!!
Muy bienvenido Camilo
Graciasss mil gracias amigo, se que me ayudaras mucho para el proyecto de grado!!@@RaghavPal
Muy bienvenido
Great tutorial, Is there in other tutorial to read (Array)data from CSV file (Parameterisation)? Please suggest
Not yet Pratiksha
Nicely Explained. Keep up the great work.
Thanks Sameera
Hi Raghav can you please share the link of the previous video as the 9th video i see in the playlist doesnt have weather information as mentioned in this video, Thanks!
Hi Himanshu, I believe this refers to the API web services video, I have added it as tutorial 11. I had earlier removed it as it became outdated with the new changes in JMeter, Now I have added it again and also updated the description. Pls check - ua-cam.com/video/eaU7951fNuQ/v-deo.html
Thanks a ton brother .... God bless you
Thanks for the wishes Noor
This video is so helpful and easy to understand. I want to know is there any way to pass multiple values in HTTP header manager through CSV?
Hi Aashi, can check this stackoverflow.com/questions/19541133/jmeter-use-csv-for-setting-http-header
@@RaghavPal Thanks for reply, it's working, already tried.
Hi Raghav, You are a great tutor. Thanks for your help. I request you to please add the notes that you prepared while teaching us if you have it. Sorry if I am bothering you
Hi Kalyan, I am glad it helped. Untill now i have been writing the steps down on a notepad as shown in the videos and i also copy the same in the description of the video. Will try to add more description for everyone's help. Keep Learning.
Hello Raghav sir,
You are referencing about "Tutorial 9 Testing Web Services Api" ... but I can not able to find it in your playlist and I think you have replaced that video with new SOAP and REST service testing videos.
so my question is can I know which URL you are using for REST-RPC, Soap-RPC and HTTP request ?
Thank you for this tutorials man ... You have been doing good job ! #BlessingsFromCanada
Hi Kishan, yes as that video was obsolete I updated it with the latest API testing videos. You can check this - ua-cam.com/play/PLhW3qG5bs-L9sCVY1c_vox9blIrIzwEEb.html
@@RaghavPal Thank you for quick reply ... Appreciate it !
Thanks Raghav for educating us with your excellent videos.........I tried the above video in jmeter5.1 same like you but I have getting issues particularly the city name is not taken from the csv file. I checked in Google the reason for that.In "CSV Data Set Config" section if I don't give anything at Variable Names(comma-delimited) I have been getting this issue if I give the column names for which I want to pass the parameters this issue is not coming. I watched your current video many times even then also the issue didn't solve until I give column names for which I want to pass the parameters. Can you please help to understand it version specific issue or anything else as I see most of the features in your videos not available in 5.1.......please clarify
Hi Kiran, hope you have not missed any steps. I have not yet checked with ver 5.1. You can try with an older version to ensure if its version issue
Thanks a lot! Raglav, your video helped me to solve my issue by using this config element )
Glad to know this Tatsiana
Great tutorial. Thx a lot
You're welcome Abdallah
Iam following automation and jmeter as well .I am implementing in our office with that skills .thanks Aditya... one question related to jmeter .my application will generate one token when we login to that ,so for performance testing how can we extract the token and how can we do load test for that ..
Hi Abhi, pls check regular expression extractor video ua-cam.com/video/7-NcyZuUQnw/v-deo.html
Bro excellent tutorials bro we expect more tutorials on selenium webdriver, jira....
will add more videos soon
Very useful video. Thank you!
You're welcome
Thank you, Raghav. Is there a way to read the data from CSV in non-GUI mode. If not, how can we use multiple values for a single parameter when we run from command line.
Hi Rajashekhar, if you have configured to use data from csv, it will work even from commandline. Pls try and see if you get any issues. You can check this too for help - stackoverflow.com/questions/38082400/passing-csv-data-set-config-file-as-parameter-to-jmeter/38085980#38085980
@@RaghavPal Thanks again Raghav. The link you shared helped. I really appreciate it!!
Hi, Raghav Hope you doing well !! I have a query can you please tell that how can I add or fetch users to my API call from an excel file.
Hi Dishant, try to use excel in the same way we have used csv. Also see some online examples stackoverflow.com/questions/48987834/reading-content-from-excel-using-jmeter
Hi Raghav ,Suppose for multi user load test I want to login with different usernames & passwords from CSV file then what values should be under "Variable names " box ? I should left it blank ?
Hi Princeton
In JMeter, when you want to use different usernames and passwords from a CSV file for a multi-user load test, you need to specify the variable names that correspond to the columns in the CSV file.
Here's what you should do:
1. Create a CSV file with columns for usernames and passwords, for example:
```
username,password
user1,password1
user2,password2
user3,password3
```
2. Add a CSV Data Set Config element to your Test Plan in JMeter.
3. In the CSV Data Set Config element, set the "Filename" field to the path of your CSV file.
4. In the "Variable Names" field, you should enter the names of the variables that correspond to the columns in your CSV file. For example, if your CSV file has columns named "username" and "password", you should enter `username,password` in the "Variable Names" field. Make sure the names match exactly (case-sensitive).
5. In your HTTP Request, use the variable names in the format `${variable_name}` to refer to the values from the CSV file. For example, if you want to use the username and password values from the CSV file, you can use `${username}` and `${password}` in the appropriate fields of the HTTP Request.
By setting the correct variable names in the "Variable Names" field, JMeter will automatically read the values from the CSV file and assign them to the corresponding variables during the load test. Each thread/user will then use a different set of credentials from the CSV file.
Hi Raghav, My json body has around 50 input fields. Each time I only have to change one filed. So as per the video should I create parameters for all my input fileds.
Hi Saichandra, I may have not got your scenario completely, but its as per your need. Whatever value you want to get from csv you can do that and if you want to hardcode some values that is okay, you can give it directly in your test.
for who does not work with him , please change in "CSV Data Set Config" the 4th option "Ignore First Line" to true (for new version 5.0 of jmeter)
Thanks for adding this info Bilal
can I contact you please?
Hi Bilal, you can put your message here or email me raghav.qna@gmail.com
Hi Raghav bro,
I need a help from your side. Created CSV data set config for login modules only. in CSV file mentioned two users. It's logged in successfully displayed in jmeter but in the data base entries are not inserted into user log table. Without using CSV the values are inserted into corresponding table while running in jmeter.
Hi Sasshi Kumar, that ideally should not be the case, But I found something similar here stackoverflow.com/questions/33133263/jmeter-csv-data-parameterize-in-script-but-not-updated-in-system-database
@@RaghavPal thank you so much ..... Brother....
Thank you so much I really truly appreciate your tutorials. I am walking through them since I am new to this and do it for my job. I am not finding the Tutorial #9 at all that you created the test from, the list has changed or it is not avail any longer? Can you point me in the correct direction so I can follow this video, I really need to know how to pull data from CSV for my tests. Thank you
Hi Jennifer, thanks for your message.
Pls check the complete playlist here - ua-cam.com/video/eaU7951fNuQ/v-deo.html
Excellent session. loved it. Sir, can we have a session on how to write to CSV file using Jmeter, please.
Hi Vikas, thanks for the message. Usually we can export results in csv, Is there any specific use case for your example
Hi Raghav, please share some details to add user defined variables in user.properties file in jmeter
I will do a session on this soon Divya
Hi Raghav,
I have question regarding report which would be generated from different CSV data then how to identify those from report.
Hi Prishani, you can use the __CSVRead() function and can try some functions to get this added in reports. Not a usual thing that we do so will need to do some work for this
hey raghav, first of all excellent tutorial on jmeter. I had a query. i need to test an rest api which creates an element in db taking 5 parameters . In return it throws the id of resource created. Similarly i have to test equivalent delete api which just takes the id. How to go about it using jmeter ? Do i have to manually enter values in csv ? How would u do it ?
Hi, you can use correlation to pass values from one request to another. Watch - ua-cam.com/video/7-NcyZuUQnw/v-deo.html
Hello sir thank you for the tutorial. I have a similar question I found on stackoverflow
I am a JMeter new user. I have the following scenario - To search for a Name in search text box. Parameterized the Name in CSV. But while searching instead of entire name being passed as parameter i.e. ${Name}, I need to pass each character of ${Name} to individual HTTP Request, say for request 1, parameter is N, Request 2 - Parameter a and so on and the search result is displayed for the last request when N, a, m, e have all been passed. How do i handle this using Jmeter?
Hope you can help me on this. Thank you so much!
Hi Jaybee, you will either need to provide data from CSV in the same way as you need or use some scripting sampler to fragment the text and give as parameter
@@RaghavPal thank you for the response, sir. May I ask if you have a tutorial on scripting sampler?
Not yet, I will plan to add
If I am using Stepping Thread Group, there is no option like loop, so if i want to parameterise request do i have to add threads same as number of parameters. I mean 2 threads for 2 parameters?
Thank you, Raghav. All of your tutorials, as usual, are really informative and helpful and great.
I have an issue in Jmeter 3.3 when I add Add config element - CSV Data Set Config to thread Group then the test plan is not running (nothing to see in the tree) .
When I remove the CSV Data Set Config element than by run of the test plan is again the response to see in the tree.
is it a new BUg in Jmeter 3.3.? do you know something regarding this.
Hi, can you check the logs. There might be some issue.
Thanks Raghav, it was an issue with excel. instead of comma I changed it to the semicolon and was working fine
You are helping us so much .Thanks alot :)
You're welcome Abhishek.
Hi Raghav do you have any video where we can test login with multiple users using the blazemeter script? thank you for replying to all the queries your videos are helpful!
Hi Himanshu, I have shown how to record a jmx script using blazemeter chrome extension here - ua-cam.com/video/zn1DSUZ6t64/v-deo.html
As of yet, I do not have a video to show multiple user working with blazemeter tool
Hi Raghav thanks for your prompt reply I have followed that video and it works for me but I was thinking if I could test for 10-15 different users how can I do that with blazemeter script
I will plan a session on this
Thank you Raghav. All of your tutorials are really informative and helpful. I have one request. Can you also come up with Selenium Web Driver 3.0 tutorials?
Yuvraj i am glad you found it helpful. I will soon be starting a series on Selenium and will cover Se web driver 3.0 also.
Automation Step-by-Step - Raghav Pal x
Please watch this - Selenium Beginner - ua-cam.com/play/PLhW3qG5bs-L_s9HdC5zNshE5Ti8jABwlU.html
Nice presentation!
Hi Raghav, I have question. I am using csv config where I want to pass a variable name in the Filename. So, I have created a user define variable as filename = ${__P(filename, default_filename)}. But it is not recognized in CSV_config when used as ${filenamr}. I tried __P and __property also
Hi, Pls check the spelling ${filenamr}
Hi Raghav , its not reading my csv file , instead of value taking the variables. Please help for the issue.
If you are giving headers in your csv file, then don't provide variables name in csv data set config element. It will directly be taken from csv file.
If you provide the variables, then the first row will also be considered as values.
Good tutorial.
I have POST operations, instead of sending payload in HTTP Requests as body data, I need to send as files so that each files will have different types of payload. Do you have video for this setup?. I mean I have to use __FileToString(... __eval...)
Hi Kasim, not yet, you can get some help here stackoverflow.com/questions/39037049/how-to-upload-a-file-and-json-data-in-postman
Thanks Raghav. Tutorial is very handy and helpful.
I have a question we are passing the complete Json file as input parameter How we can do that ? I want to create scenario where I CSV will feed data to all the threads with the dynamic data. Can this be achievable?.
hi Ankit, you can try to write a Bean Shell script to get your values from file and then run your test.
What's tutorial that you taught about reading excel to insert Database
Did not get you..
Hi Raghav , i was using special characters to read data from CSV file which i used to Login to account. And it looks like special characters are not taking (example- @ and #). any idea why ? Thanks in advance
Hi Saikat, you can change the encoding, Check blog.e-zest.com/how-to-read-special-characters-from-csv-in-jmeter
Great learning.. But I have a doubt..
I want to execute each iteration with a different column value.. in while controller.. can you tell how can I do it?
Hi Sanket, I will need some details, Let's say in your csv file you have a column "username" and in your requests you have a variable called "username"
Now when you parameterize using csv, on execution, it will take values from username column. and will take the next row in each iteration, So you can add the values you need in the new rows. Now what exactly from here do you need
@@RaghavPal
So I have columns username1 username2 and username3
Now in while controller (which will run thrice) I want to use username1 in the first loop,
Username2 in second loop and username3 in the third loop.
Also I just noticed while controller runs just once every thread.
So if we use loop 10 with thread 1 it will just go inside while controller only once.
I believe username1, 2 and 3 are all used in the same place in request, if that is true, you can keep a single column and add all the values in sequence
How do I make each Vuser take an unused (unique) data value from the text file on the first iteration and keep the same value for all iterations and occurrences?. Thanks.
Hi Samuel, you can see the settings in CSV data set config
You can also use functions for this
Hi Sir, Thanks for your videos. I want to substitute (example 10 unique data) in my single request like each occurrence in LoadRunner, is there any way to achieve the same in JMeter, please assist it.
Vinay
Yes, there are a few ways to substitute different data in a single request in JMeter.
One way is to use the *CSV Data Set Config* element. This element allows you to specify a CSV file that contains the data that you want to substitute. The CSV file should have one row for each data point, and the columns in the file should match the names of the variables in your request.
To use the *CSV Data Set Config* element, you need to add it to your test plan and then configure it with the path to the CSV file. You can also specify the delimiter that is used in the CSV file, and the number of rows that you want to read.
Here is an example of how to use the *CSV Data Set Config* element:
```
```
In this example, the CSV file is called `data.csv` and the delimiter is a comma. The `numberOfLines` attribute is set to 10, which means that the element will read the first 10 rows of the file.
The data in the CSV file will be substituted into the variables in your request. For example, if your request has a variable called `username`, the value of the `username` variable will be replaced with the first value in the first row of the CSV file.
Another way to substitute different data in a single request is to use the **BeanShell PostProcessor** element. This element allows you to execute a BeanShell script before or after a request is executed.
The BeanShell script can be used to read data from a file, generate random data, or perform other operations. The data that is generated by the BeanShell script can then be substituted into the variables in your request.
Here is an example of how to use the *BeanShell PostProcessor* element:
In this example, the BeanShell script is stored in the `script` attribute. The `script` attribute can contain any valid BeanShell code.
The BeanShell script can be used to read data from a file, generate random data, or perform other operations. The data that is generated by the BeanShell script can then be substituted into the variables in your request.
I hope this helps
Hi raghav, this series is by far the most clearest video series for a Jmeter beginner. One question, is it possible to configure each concurrent user(thread) is using different data from the csv file? Eg each user has unique login id and password for a login action?
Hi Jameela, Pls see if this is what you need - www.blazemeter.com/blog/csv-data-set-config-in-sharing-mode-made-easy/
Hi Raghav, what is the concept of data pool. if i need to run my login-logout script for more than one user, then where all places i need to replace user ID and password with variables. and what should be th search criteria for that.
I started to learn Jmeter few days back. started with your tutorials. These videos are really helpful.
But i'm running through issues when i'm trying to work on actual scripts. Thanks!
Hi Ramandeep, you can parametrise your data in csv file and then in your HTTP Sampler request you have section for Parameters, Here you can replace with the variable names.
Hello Raghav, I am interested to know how I can parametrise variable information (not static one, like the one in a csv file). I managed to connect to the DB using a JDBC connection configuration, but how can I use the variable that stores the constantly changing IDs from the database?
Hi Raluca, in the JMeter playlist there are videos for JDBC and variables handling. Please check if you are able to get help from that.
ua-cam.com/play/PLhW3qG5bs-L-zox1h3eIL7CZh5zJmci4c.html
Hi Raghav, thanks for the tutorials. How can I capture parameters dynamically on Jmeter? do you have any video on it? Thanks.
Hi Deepan, what exactly is meant by capture parameters dynamically. You can check all JMeter videos here - automationstepbystep.com/online-courses/
Thanks Raghav, I have a situation to pass multiple row values in single request. I am using random csv data set config. If I just use parameter name it uses same row value twice. How to make it chose different row. Something like [{$city, $email}, {$city,$email}].
Hi Nithya, usually once you refer it take one of the random values from csv and will use that value unless you refer the same parameter again.
If you like I can check your setup. Can upload your setup image here imgbb.com/upload and send me the link
Hi,
Thanks for the tutorial. Quick question- if I want to run this from an EC2 instance then the file needs to be hosted on that box? is there a way for us to specify to get the file from an S3 bucket? Thanks!!
Hi, yes you can do that, You will need to add a script for that. stackoverflow.com/questions/45084164/s3-access-in-a-jmeter-script
You can also use jenkins and then can get the file from s3 or any source code repository before starting JMeter test
Thanks for the sessions Raghav, I have a question like - If we have multiple thread groups in a Plan, Can we pass data from csv file as one row to one thread group and next row to another thread group and so on? Can we do that ?
Hi Naresh, thanks for watching, just is if you need something similar to what is explained in this post - www.blazemeter.com/blog/csv-data-set-config-in-sharing-mode-made-easy
Thanks a lot :)
Could you help me please: I work with the SOAP web service:
How to manage a csv file with 3 columns and each column represents a variable in a SOAP request?
Hi Ameni, you can create the variables as per the column headers and then follow the same process. it should work
Raghav,Could you please make a session on how to do Parameterisation for Web application testing for example like i need to perform load with different user
Hi Ullas, i will make it but can take some time
hi Raghav,not an issue I have done this not an issue
hi raghav .. how can i check a senario where can i download Files in load testing can u please help in this regard with example
hi Raghav, i will try to upload a video with example soon on this.
HI Raghav , here is your video - How to test File Download - ua-cam.com/video/Tzqd1xSPc3s/v-deo.html
Thank you for this tutorial
You're welcome Omar
Thanks bro for the video. I have one issue with this. For me the jmeter has taken only the first row of csv file, though I have given multiple iteration.Could you please help me?
Hi Faiz, that should not be the case. Pls re-check if you have missed any steps.
@@RaghavPal iam using jmeter 5.1.1. is there any thing else to do in this version?
I believe not, although I will check.
@@RaghavPal thank you so much bro.
hi raghav
I have to use Body Data as a Parameterized value
and it shows me error like this
2017-05-18 17:16:37,262 INFO o.a.j.s.FileServer: Stored: Inputdata.csv
2017-05-18 17:16:37,262 ERROR o.a.j.t.JMeterThread: Test failed!
java.lang.IllegalArgumentException: File Inputdata.csv must exist and be readable
I have both input and csv file in the same directory
Can you please help me with this
Hi Abishek, looks like issue with JMeter reading your csv file. Ensure these.
location of csv file is accessible by JMeter
csv file is properly created and formatted
The 1st line says FileServer Stored : file Name
So I guess this means its properly created
Checked the Jmx file its all Ok
Not able to figure that out
any information in the logs.
Hello Raghav,
I am looking for your help on JWT token. How do Generate JWT token using Jmeter?
I have used JWT Pre-Processor and it did not help me.
Thank you in advance for your help
Haresh
Before we dive into generating a JWT token, can you please provide more information about the token you need to generate? Specifically:
* What is the algorithm used for signing the token (e.g., HS256, RS256)?
* What are the claims or payload elements required in the token (e.g., username, email, expiration time)?
* Do you have any specific headers or custom fields that need to be included in the token?
Choose the Right Approach
Since you've already tried the JWT Pre-Processor, we can explore alternative approaches. We can use either:
* A Beanshell Pre-Processor
* A JSR223 Pre-Processor (with Groovy or JavaScript)
Both of these options allow us to write custom code to generate the JWT token.
Step 1: Write the JWT Token Generation Code
Let's use a Beanshell Pre-Processor as an example. We'll use the `java-jwt` library to generate the token.
Add a Beanshell Pre-Processor to your JMeter test plan and paste the following code:
```java
import io.jsonwebtoken.Jwts;
import io.jsonwebtoken.SignatureAlgorithm;
// Set your secret key (replace with your own)
String secretKey = "your_secret_key_here";
// Set the payload claims (replace with your own)
String username = "johnDoe";
String email = "johndoe@example.com";
long expirationTime = 3600000; // 1 hour
// Create the JWT token
String token = Jwts.builder()
.setSubject(username)
.claim("email", email)
.setExpiration(new Date(System.currentTimeMillis() + expirationTime))
.signWith(SignatureAlgorithm.HS256, secretKey)
.compact();
// Store the token in a variable
vars.put("jwtToken", token);
```
This code generates a JWT token with the specified claims and signs it with the provided secret key using the HS256 algorithm.
Step 2: Use the Generated Token in Your Request
Now that we have generated the JWT token, we need to include it in our request. You can do this by adding a `Header Manager` to your request and setting the `Authorization` header to `Bearer ${jwtToken}`.
That's it! Run your JMeter test, and the JWT token should be generated and included in your request.
-
@@RaghavPal using HS256
Also, I have signature string and
Header:
{
"alg": "HS256",
"typ": "JWT"
}
and 7 values in payload e.g.:
{
"string_1": "Value_One",
"String_2": "Value_Two",
-----
:String_7": "Value_Seven"
}
ok
Thankyou Raghav, all your videos are really helpful.I came across an scenarion to read data from csv file using csv data set config but in the csv file values are written in double quotes like 3,290,"15,000" . I am able to get value from csv file for 3 and 290 but got stuck for "15,000" ?I need your help.I am writing xpath assertion for xml request like ()for eg..//program/@programid='{$programid}) but facing issue for the data point "15,000"
Hi Manas, this should help you - stackoverflow.com/questions/40271781/jmeter-wont-read-list-of-quoted-csvs-from-a-csv-file
Thanks , it worked for me . I just tweak set Allow quoted data to true in CSV data set config
Great to know this Manas
Hi Raghav, I am getting this error: java.net.URISyntaxException: Illegal character in query at index 50: api.openweathermap.org/data/2.5/weather?q=${city}&appid=${appid} and I use Numbers for generating the file. What should I do to avoid this error?
Looks like the values are not getting referred from your csv. Check the logs. (button at top right) ua-cam.com/video/ZkRYdHYH2N8/v-deo.html
Thank you Raghav, the logs showed what was wrong and installing Table Tool also helped.
Thank you Raghav, good tutorial...you have personal classes?
Hi JD, thanks for watching. Yes, I give classes morning 6 to 7 IST. You can connect on raghav.qna@gmail.com
Hi Raghav Pal, thank you for this informative videos. These videos shows how to test web pages. Can you please share how to test Mobile applications using Jmeter.
You're welcome Keerthiraj. Pls check here - ua-cam.com/play/PLhW3qG5bs-L_Eosy1Nj1tKHC5jcBAVkPb.html
Other courses - automationstepbystep.com/909-2/online-courses/
Thanks for your Videos Pal, I have beginner learning Jmeter watching your videos. can you please explain how to select CSV data to take sequentially when we are running for Multiple user test
Hi Sudhakar, you can use critical section controller. Pls check is this what you need - stackoverflow.com/questions/51298120/i-want-to-fetch-the-data-from-csv-in-sequential-order-in-jmeter-what-should-be-d
thank you bro
Most welcome Mao
Hi Raghav ,I have to implement j meter in my project i.e. chat bot application how could I implement could you please help me out?
Hi Sharad, not much exp with Chatbox. Pls try online help
stackoverflow.com/questions/56426571/how-to-measure-performance-testing-for-chat-bots-using-jmeter-or-any-tool
www.blazemeter.com/blog/5-ways-to-load-test-popular-chat-plugins-with-jmeter/
H i Raghav, I tried with xlxs format file but it is not showing results in view results tree while execution ,Can you please help?
Hi Vedant, pls check the logs.
Hi Raghav, i would like get more details about your Tutoring lessons, how do i contact you ?
Hi Sabbir, you can find my email in the about section of this channel.
Hi Raghav, Very helpful videos. I am using JMeter 3.0 and testing with sampler SOAP/XML-RPC Request, I am trying pass parameter from Csv file as ${XYZ}, but it’s reading it as ${XYZ} instead of value. Please advise.
Hi Shiva, in case you have given headers in your csv file, do not give any values in the Vairables Name field of CSV Data Set Config
hi Raghav, This session is grate and your presentation is good... but i have a small doubt ,I have to register In account ex:FB then i want to pass all parameters from csv file .It is possible As like above video.
Hi Rafi, yes you can parametrise any test.
Hi Raghav, but how to configure parameter present in csv , while running scripts in jenkin
Hi Neelima, you can create a parameterized job in jenkins
Can you please create video on parameterization on some application in which you have to supply multiple username and passwords?
Hi sure, I will do a session
Hi Raghav,
Thanks for the video. Could you please prepare a video on how to do performance testing with 50 different concurrent users using csv? This should include end to end flow of the app.
I will plan Sumit
It is possible to set variable "http request" type by csv-file? For example GET, PUT, UPDATE and so on
When using JMeter with a CSV Data Set Config, you can indeed set the HTTP request type dynamically based on values from your CSV file. Let's explore how you can achieve this:
1. CSV Data Set Config:
- The CSV Data Set Config element in JMeter allows you to read lines from a CSV file and split them into variables.
- By default, it assumes that the CSV file is comma-separated (CSV), but you can customize the delimiter.
2. Scenario:
- Suppose you have a CSV file with columns like `RequestType`, `Endpoint`, and other relevant data.
- You want to dynamically set the HTTP request type (GET, PUT, etc.) based on the `RequestType` column from the CSV.
3. Steps:
- Here's how you can achieve this:
1. Create Your CSV File:
- Your CSV file should include columns like `RequestType`, `Endpoint`, and any other relevant data.
- Example:
```
RequestType,Endpoint
GET,/api/resource1
PUT,/api/resource2
POST,/api/resource3
```
2. Configure CSV Data Set Config:
- Add a CSV Data Set Config element to your JMeter test plan.
- Specify the path to your CSV file.
- Set the delimiter to match your CSV file (e.g., semicolon `;` in your case).
3. Use Variables in HTTP Request:
- In your HTTP Request sampler, use variables for the request type and endpoint.
- Example:
- Set the HTTP Method field to `${RequestType}`.
- Set the Path field to `${Endpoint}`.
4. Run Your Test:
- JMeter will read the values from the CSV file line by line.
- For each iteration, it will set the `RequestType` and `Endpoint` variables accordingly.
- Your HTTP requests will use these dynamically set values.
4. Example:
- Suppose your CSV file contains the following lines:
```
RequestType,Endpoint
GET,/api/resource1
PUT,/api/resource2
POST,/api/resource3
```
- During execution, JMeter will use the values from the CSV to make requests like:
- GET: `/api/resource1`
- PUT: `/api/resource2`
- POST: `/api/resource3`
Remember to adjust the column names and structure according to your specific use case. With this approach, you can dynamically set the HTTP request type based on values from your CSV file.
Hi, I have Thread Group with three requests (login, do some process, logout) I'm passing data's(1500 data) from csv config file for login and do some process request. It is working fine if i give thread count as 1500, but i want to run the thread group in loop for infinite time were after reaching 1500 data in csv file again it should continue from the first row. I tried a lot but it is not working.For Login, after reaching 1500 data it again starts from 1st but for the next request after reaching 1500 data it takes empty data from csv file even though i have set true for recycle EOF. Can you just give me a solution. Thanks
Hi Pavithra
here are the steps on how to run a JMeter thread group in a loop for infinite time:
1. Add a **Loop Controller** to your thread group.
2. Set the **Loop Count** to **Infinite**.
3. Add a **While Controller** to your thread group.
4. Set the **Condition** of the While Controller to **${__loopIteration} < ${totalIterations}**.
5. Set the **Total Iterations** of the While Controller to the number of rows in your CSV file.
6. Add your requests to the thread group.
7. Set the **Variable Names** of your requests to the column names in your CSV file.
8. Set the **Data Set Config** of your requests to the CSV file that contains your data.
9. Set the **Recycle on EOF** of your requests to **True**.
Once you have completed these steps, your thread group will run in a loop for infinite time. The first time the thread group runs, it will iterate through all of the rows in your CSV file. Once it reaches the end of the file, it will start from the beginning again. This will continue indefinitely
what if I want to simulate 2 users? i want first row to simulate user 1 and 2nd row of csv to simulate user 2. At the moment you have 1 user doing both requests.
Hi Nuril, this should help you - dzone.com/articles/how-to-pick-different-csv-files-at-jmeter-runtime
If i have integer values like No of Month in csv file and it contains all integer values in it and i want to pass dynamically in Body Data tab of particular HTTP request for integer values then how to do it
HI Gavin, the process should remain same, can check this stackoverflow.com/questions/50933586/jmeter-read-data-numbers-from-csv-file-in-jmeter
Thank you raghav!!! Your videos are really helpful. I tried the same and it is reading 2nd row first, followed by 3rd row and then reading the data from 1st row. could you please let me know the reason for this.
Hi Janardhan, can you check if you are selecting all correct values in csv data set config
I selected recycle eof as true.
if I select that value as false and if file has 1 row of data, my request is failing and it shows request as Eof
I selected recycle eof as true.
if I select that value as false and if file has 1 row of data, my request is failing and it shows request as Eof
Does your csv file has headers? Also check if you get any information in the logs.
Hi Raghav,
I have a query. I am reading multiple users from a CSV wherein when I check the response of the api calls for login, each username and password is reflected correctly. But after logging other API calls are not getting called wherein the user is doing some other activity after logging in. let me explain you the flow which is under one thread group:
1. User logs in (Transaction controller 1)
2. He opens a course.(Transaction controller 2)
3. He attempts an assessment.(Transaction controller 3)
4. he logs out.(Transaction controller 4)
The users are read successfully from the CSV as I can see it in the request. Session Ids are also different for each user. But the response data for step 3 does not get updated.
Can you please suggest me a solution?
For one user the script runs fine.
Hi Nishu, can you check the logs. will get some information there
I can see this in the log as warning "java.io.FileNotFoundException: C:\Program Files\apache-jmeter-3.2\backups\OpenCourseMultiTest-000001.jmx (Access is denied)"
Is this your test script file. Or being used in some other way.
its my test script
Can you check the permissions on this file. Hope path and names are all correct.
Hello Raghav facing some issue while accessing csv file as below
jmeter.threads.JMeterThread: Test failed! java.lang.IllegalArgumentException: Could not read file header line for file Data.csv
Harshal, are you running from command line. (if yes send me the command). Also check below links:
stackoverflow.com/questions/13228918/jmeter-doesnt-accept-csv-input-file
stackoverflow.com/questions/10818221/jmeter-csv-data-set-config-failing-to-find-csv?lq=1
Thanks Raghav Issue resolved
Reghav, Can we use Selenium script for Jmeter to perform Load testing ??
hi Bhushan, the answer is yes. In fact there is a webdriver plugin for JMeter. Can check that.
Hi
If i want run only one iteration and with 3rd row testdata then how can i do that?
Hi
To run only one iteration and with 3rd row test data in JMeter, you can do the following:
1. **Open the JMeter test plan.**
2. **In the `Test Plan` element, right-click and select `Add` > `Sampler`.**
3. **From the list of samplers, select `HTTP Request`.**
4. **In the `HTTP Request` dialog, enter the URL of the web page that you want to test.**
5. **In the `Test Data` tab, select the `3rd row` from the `Data Set` list.**
6. **In the `Iterations` field, enter `1`.**
7. **Click `Save`.**
Once you have made these changes, JMeter will only run the HTTP Request sampler once, and it will use the data from the 3rd row of the test data set.
Here is an example of how to do this in JMeter:
```
HTTPSamplerProxy sample1 = new HTTPSamplerProxy();
sample1.setUrl("www.example.com/");
sample1.setMethod("GET");
sample1.setTestData("3rd row");
sample1.setIterations(1);
```
Once you have added this code to your JMeter test plan, you can run the test by clicking on the `Run` button. The test will only run once, and it will use the data from the 3rd row of the test data set.
I hope this helps
Hi Raghav..
1.how can we randomise the parameters added in the CSV ? Say if I have 10 credential values in param list and I want random of that to be chosen in each run?
2. If I add parameters in the path of a request,it's failing with Illegal character in path at index ...path/${Param} at java.net.URI$Parser.fail(Unknown Source)
Hi Swarnendu, this can help stackoverflow.com/questions/18479960/random-selection-from-csv-file-in-jmeter
Just as a heads up, the video does not show Raghav use the variable for appid when he modifies REST-RPC-Request. He uses the city variable but leaves appid hard coded. I'm sure he meant to change both.
Dear Raghav,If u r reading it.....can u please dedicate some time to modify this video and show this feature on a webservice test using HTTP request now that SOAP request desnt exist in Jmter. I am running into lot of issues in my current project.
Appreciate your help on this.
Hi, I will do, I will plan to update the required videos
Hi Raghav,
Really great videos! Thank you so much for sharing! I would like to know, how can we insert response assertions to check our results.
In this video, we have used 2 loop so we will get two different results.
1. now if I want to use response assertion 1 for first value which is coming from csv.
2. And response assertion 2 for second row value from csv.
How to do this? Could you please help me ?
Hi Pradyumna, Can you not add the assertions in diff columns of same row. It will be easier that way
@@RaghavPal Hi Thanks for your prompt response.
As per your suggestion, I should add variable in my request then same variables should mention in (Jmeter variable Name to use) field in response assertion. am I right?
but what I want to achieve is that, there are total 5 rows in csv for first 3 values when executed in database it should get updated and I get the status as updated but for last 2 values I should get error code
Hi Pradyumna, I may get more information about your scenario if I take a deeper look. But for general, The way parameterization works is you create variables and refer the variables from an external location. If the variables is provided multiple values, the test runs multiple times with each row or set of data, Now this is the standard way. You can write scripts to do this in a diff way as required.
@@RaghavPal Thank you so much Raghav! Now I am able to validate it by adding Beanshell Assertion but while exporting results and I still believe that I am not using the jmeter options properly. can you please help me?
Please let me know if you need any further information, I will share with you
Happy to know that Pradyumna. I will suggest that you first check the required information online As I might not get enough time to go deeper into the setup
Hello Raghav, thanx for the nice tutorial, I have one query, as I am using api where 2 input is treated as 1 i.e samples.openweathermap.org/data/2.5/weather?q=London,uk , as u can see here in q we r giving London,uk together so in my csv also I have created a column called city and writing there London,uk but it's not picking it together, it only accept London from there that's why getting error.
Question is how & what configuration need to be done so that it act as single parameter.
Hi Abhishek, treat them as 2 separate parameters, and in JMeter you can also give them separately in the parameters section.
thanx Raghav, it works now...