I see. If I were you, in this case, I would write a python script to process the data so that each row contains 100 unique address information, and each row is the complete json body of a request. As you said, your 500 rows of data are just five requests...
在 2018/12/19 14:08,“Nayak, Soumya R.”<[email protected]> 写入: Thanks Dong for the reply. If it is the case of 100 array of variables in JSON. Like as shown in the below JSON requests - Address_1, City_1, State_1, Zip_1 etc. My CSV is having four columns of Address, City, State and Zip and has 500 rows for the data. Please scroll down to see. How to handle in this scenario. I am creating the CSV file taking data from the database Below is the sample JSON :-- { "username": "", "password": "", "addresses": [ { "streetAddress": "Address_1", "city": "City_1", "state": "State_1", "postalCode": "Zip_1" }, { "streetAddress": "Address_2", "city": "City_2", "state": "State_2", "postalCode": "Zip_2" }, { "streetAddress": "Address_3", "city": "City_3", "state": "State_3", "postalCode": "Zip_3" }, . . . So on Upto 100 addresses. CSV Structure Address City State Zip Abc pqr xxx 12345 Def aaa ooo 334455 Regards, SOumya -----Original Message----- From: 贾国动 <[email protected]> Sent: Wednesday, December 19, 2018 11:14 AM To: JMeter Users List <[email protected]> Subject: Re: CSV Data Reading for Multiple Users Sorry I misunderstood you before, I think this will solve your problem: CSV data file as below: variable1, variable2, variable3, ...variable100 value1-1, value1-2, value1-3, ...value1-100 value2-1, value2-2, value2-3, ...value2-100 ... CSV Data Set Config as below: Variable Names(for example): v1, v2, v3, ... v100 Ignore first line: True Then parameterize your request, set the variable as above: ${ v1}, ${ v2}, ${ v3}, ...${ v100} Every request will get a line with 100 variables. hope helpful 在 2018/12/19 13:12,“Nayak, Soumya R.”<[email protected]> 写入: Hi , As per your details below it will not iterate the CSV more than once. That is fine but my requirement is how each thread picks up 100 rows at a time to parameterize the 100 variables in JSON request. As far as I know each thread picks up one row , but how we can pick up 100 rows at one time with each thread and that too all threads picking up 100 unique records. Thanks, Soumya -----Original Message----- From: 贾国动 <[email protected]> Sent: Wednesday, December 19, 2018 10:38 AM To: JMeter Users List <[email protected]> Subject: Re: CSV Data Reading for Multiple Users On your CSV Data Set Config element, set as below: Resycle on EOF: False Stop thread on EOF: True hope helpful 在 2018/12/19 11:09,“Nayak, Soumya R.”<[email protected]> 写入: HI Team, I have a requirement where in let's say I have 500 rows of data in a CSV file. I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file. When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it. For 500 records in CSV --- Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario? Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter. Thanks in advance. Regards, Soumya ****************************************************************************************** This message may contain confidential or proprietary information intended only for the use of the addressee(s) named above or may contain information that is legally privileged. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message and any copies immediately thereafter. If you received this email as a commercial message and would like to opt out of future commercial messages, please let us know and we will remove you from our distribution list. Thank you.~ ****************************************************************************************** FAFLD --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
