Variable reading value as "(Default) payee3 = com.kms.katalon.core.testdata.reader.SheetPOI@5f780a86"

Product Forums Katalon Studio
,
1

In WS script, I read the test data from an excel sheet. In certain script i’m facing issues reading BLANK values from excel.
Katalon version == Katalon Studio - 7.2.1

For Example,
When payee2 is blank in the excel sheet,

One script read as below,
payee2 =

One script read as below,
(Default) payee2 = com.kms.katalon.core.testdata.reader.SheetPOI@299266e2

Actual script:

AddBankInfoResp = WS.sendRequest(findTestObject(‘QA_Requests/AddBankInfo’, [(‘acct1’) : acct1, (‘acct’) : acct, (‘bank’) : bank
, (‘bankAcct’) : bankAcct, (‘branch’) : branch, (‘descr’) : descr, (‘payee1’) : payee1, (‘payee2’) : payee2, (‘payee3’) : payee3, (‘payee4’) : payee4
, (‘payee5’) : payee5, (‘payee6’) : payee6,(‘transit’) : transit ,(‘L_BaseUrl’) : GlobalVariable.G_BaseUrl]))

WS.verifyResponseStatusCode(AddBankInfoResp, 201)

Variable(script)(uploaded)

variable
variable840×402 20 KB

Please let me know if any more details are needed to trouble shoot.

2

@amohan

You should bind value to variable from test suite level.

3

Thank you. Test case level binding was working fine in version 6.2… But looks like it is not supported in Version 7.