Run Collection to use data files specified at Folder level

[CharlieSnowCode]

Run Collection to use data files specified at Folder level

[rangav]

I just now tested the using the same request body and it worked for me

• used the same script and csv file
• script is used in collection settings pre-run scripting

---

You need to increase the iterations count in run collection view

[rangav]

@CharlieSnowCode Thanks for the feedback. Currently, it's not possible. I will review it.

Alternatively, you can use scripting to read custom data files at the request level and set variable values.

Could you please try the scripting option and let me know your feedback?

[CharlieSnowCode]

I'll give it a try, could you help me get started? If each data file has 5 rows of values, how would I iterate through them? Where would the script be, in the PreRun Scripting or a custom filter file? If the file would be loaded by a custom filter, same question - how to iterate over the sets of values?

[rangav]

• Copy the below script to your folder settings - PreRun Scripting and modify as needed
• change the filepath and the variable name to your defined name

var fileData = await tc.readFile("thunder-tests/test.csv");
var papaparse = require('papaparse');

var options = { delimiter: ',', quoteChar: '"', escapeChar: '"', header: true };
let csv = papaparse.parse(fileData, options).data;
console.log(csv);

var iteration = tc.info.currentIteration;

var iterationCsvData = csv[iteration];
if(iterationCsvData){
  console.log(iterationCsvData);
  var name = iterationCsvData["name"];
  console.log("name", name);

  // set variable using request scope so the value is not saved to active env file
  tc.setVar("name", name, "request");
}

sample csv file - test.csv

name,score
mike,444
john,555

[CharlieSnowCode]

I've attached the (Pre run) script and the .csv I'm using, a snapshot of the (Restful Booker) Request and of the output. It seems like the script sees the file, but the Request is only executed once and none of the values are populated.
preRunScript.txt
BookerDataGood.csv

Output.txt

[CharlieSnowCode]

Very interesting, I created a Collection and copied the script to it (I was using a folder inside an existing Collection which still doesn't work). Then increased the Iterations to 3 and it worked. Many thinks for your reply.
I would however still request the original feature be implemented, as this solution will have us creating 2 dozen Collections - which can't be executed from the UI all at once. I'm sure they can be from the CLI, but the command would be a large paragraph.

[rangav]

For advanced use cases we recommend using scriping or cli is the best solution currently.

[rangav]

Closing this issue as you can achieve the functionality using scripting