# Get SQL query results as variables

**URL:** <https://forum.katalon.com/t/get-sql-query-results-as-variables/16089>\
**Category:** API Testing\
**Tags:** api-testing, katalon-studio\
**Created:** [December 28, 2018, 1:56pm UTC](https://forum.katalon.com/t/get-sql-query-results-as-variables/16089 "2018-12-28T13:56:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexandre\_Damelincou](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Alexandre\_Damelincou](https://forum.katalon.com/u/Alexandre_Damelincou)\
**Post date:** [December 28, 2018, 1:56pm UTC](https://forum.katalon.com/t/get-sql-query-results-as-variables/16089/1 "2018-12-28T13:56:47Z")

</div>

Hello,  
I’m using this tips [https://docs.katalon.com/katalon-studio/docs/get-sql-query-results-as-variables.html](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

---

<div class="post-metadata">

**Author:** ![Zarashima](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/zarashima/32/928_2.png) [@Zarashima](https://forum.katalon.com/u/Zarashima)\
**Post date:** [December 28, 2018, 1:58pm UTC](https://forum.katalon.com/t/get-sql-query-results-as-variables/16089/2 "2018-12-28T13:58:25Z")

</div>

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`)

---

<div class="post-metadata">

**Author:** ![Alexandre\_Damelincou](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Alexandre\_Damelincou](https://forum.katalon.com/u/Alexandre_Damelincou)\
**Post date:** [December 28, 2018, 2:11pm UTC](https://forum.katalon.com/t/get-sql-query-results-as-variables/16089/4 "2018-12-28T14:11:42Z")

</div>

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 -❌ 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