Get SQL query results as variables

Estimated reading time: 1 minute

Using the built-in data files functionality in Katalon Studio, you can create a data file connecting to my DB and then return the results as a variable with the code below:

//get data
def data = findTestData('Data Files/DB Data')
// Get specific data (column, row) as a variable
String record = data.getValue(3, 4)
//print my variable
println record

References:

Credit to Anthony