Pass NULL values from the datasheet

Product Forums Katalon Studio
,
1

Hello,

I’m trying to pass the NULL value to a variable in the API test using the Excel data sheet. Currently, it assumes the value as string “NULL” instead of NULL object. Can anyone help?

Thanks!

2

When you read the string null, create your object instantiating it to NULL.

3 
String var1
String sheetData
sheetData = 'NULL'
# or sheetData = 'some sensible data'

# Normal ternary operator 
var1 = (sheetData != 'NULL') ? sheetData : null
4

Thanks a lot! That worked.