Get SQL query results as variables

Product Forums Katalon Studio
,
1

Hello,
I’m using this tips https://docs.katalon.com/katalon-studio/docs/get-sql-query-results-as-variables.html for my project.

Like this :
//get data
def data = findTestData(‘Data Files/WhoAmI data’)
// Get specific data (column, row) as a variable
def version = data.getValue(1, 1)

But that didn’t work.

2018-12-28 14:35:15.178 e[34mINFO e[0;39m e[36mc.k.katalon.core.main.TestCaseExecutor -e[0;39m e[39mSTART Test Cases/ApplicationConfiguration/ApplicationConfiguratione[0;39m
Test Cases/ApplicationConfiguration/ApplicationConfiguration
[:]
2018-12-28 14:35:16.196 e[1;31mERRORe[0;39m e[36mc.k.katalon.core.main.TestCaseExecutor -e[0;39m e[31m❌ Test Cases/ApplicationConfiguration/ApplicationConfiguration FAILED.e[0;39m
e[31mReason:e[0;39m
e[31morg.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:e[0;39m
e[31mfile:/D:/_GIT/ecs-repository-dotnet-api/Ecs.Repository.IntegrationTests/Scripts/ApplicationConfiguration/ApplicationConfiguration/Script1545140302715.groovy: 9: unable to resolve class com.kms.katalon.core.testdatae[0;39m
e[31m @ line 9, column 1.e[0;39m
e[31m import com.kms.katalon.core.testdatae[0;39m
e[31m ^e[0;39m
e[31me[0;39m
e[31m1 error

What can I do ?

Thanks

2

The used class is incorrect by its class’s name: com.kms.katalon.core.testdatae. Please find and replace this line in the script with this: com.kms.katalon.core.testdata (remove ending e)

4

There is not “e” at the end, look :
import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase
import static com.kms.katalon.core.testobject.ObjectRepository.findTestObject
import static org.junit.Assert.*

import com.kms.katalon.core.model.FailureHandling as FailureHandling
import com.kms.katalon.core.testobject.ResponseObject as ResponseObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI
import com.kms.katalon.core.testdata

// check if api is available
// call test case using WebUI Class
WebUI.callTestCase(findTestCase(‘ApplicationConfiguration/CanIPingApplication’), [:], FailureHandling.STOP_ON_FAILURE)

//get data
def data = findTestData(‘Data Files/WhoAmI data’)
// Get specific data (column, row) as a variable
def version = data.getValue(1, 1)

// check BDD parameter from api
def response = ((WS.sendRequestAndVerify(findTestObject(‘ApplicationConfiguration/WhoAmI’))) as ResponseObject)
WS.verifyElementPropertyValue(response, ‘value.databaseVersion’, version)

The came from copy/past.

Test Cases/ApplicationConfiguration/ApplicationConfiguration
[:]
2018-12-28 14:35:16.196 ERROR c.k.katalon.core.main.TestCaseExecutor -:x: Test Cases/ApplicationConfiguration/ApplicationConfiguration FAILED.
Reason:
org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
file:/D:/_GIT/ecs-repository-dotnet-api/Ecs.Repository.IntegrationTests/Scripts/ApplicationConfiguration/ApplicationConfiguration/Script1545140302715.groovy: 9: unable to resolve class com.kms.katalon.core.testdata
@ line 9, column 1.
import com.kms.katalon.core.testdata

Thanks