How to Read the csv file data one by one and put into variable Using Groovy

Question

Here i am facing One problem that. i want to read the csv file data and one by one put it into a variable and that variable i want to assign a next Http Request let say ids.csv file which consisting of values like this

I am using Jsr223 PreProcessor code:

def csvfile = new File('D:/datas/id/ids.csv')
def lines =csvfile.readLines()
lines.each { String line ->
  vars.put('Id_value', line.toString())
}

If it is wrong, how to do this with simple code?

You are override the value each iteration, how will you get all values in 1 variable? — Ori Marko
– Ori Marko, Commented Dec 28, 2017 at 13:39
here Id_values i want to send it to next http request so on that time it will become empty it will take next iteration — Jhon
– Jhon, Commented Dec 28, 2017 at 13:43

Ori Marko · Accepted Answer · 2017-12-28 13:56:01Z

2

You can emulate JMeter CSV data set which add variables with different suffixes, example in tutorial:

String Filename = vars.get("GETfile");
String fileContents = new File(Filename).getText('UTF-8');
def lines = 0  ;
    fileContents.eachLine { line ->
        lines++;
        vars.put("CSVLine_" + lines, line);
    }
vars.put("GETfileLength",lines.toString()) ;

and then loop the variables using ForEach Controller:

answered Dec 28, 2017 at 13:56

Ori Marko

59.3k26 gold badges157 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitri T · Accepted Answer · 2017-12-28 15:51:23Z

2

You need to add a some form of counter to your JMeter Variables reference names, your current code will create only one Id_value variable with the value of 23336, you need to amend it like:

def csvfile = new File('D:/datas/id/ids.csv')
def lines =csvfile.readLines()
lines.eachWithIndex {line, idx ->
    vars.put('Id_value_' + idx, line)
}

And you will get:

Id_value_0=23333
Id_value_1=23334
Id_value_2=23335
Id_value_3=22336
Id_value_4=23336

More information:

answered Dec 28, 2017 at 15:51

Dmitri T

169k6 gold badges91 silver badges149 bronze badges

1 Comment

Jhon Over a year ago

i just paste the above code and the variable is not passing inside the request it is not taking the values inside the Id_value_ but it is only taking ${Id_value_}. -Http Request --jsr223 preprocessor

Collectives™ on Stack Overflow

How to Read the csv file data one by one and put into variable Using Groovy

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related