Forum Discussion
dief123
Occasional Contributor
I am not using any groovy scripts and not interested in writing any at this point.
All we need to do is use an Excel spreadsheet as a Datasource. We have operational JSON and
several fields are set to variables to be populated with the values in the Excel spreadsheet.
My question is HOW do I enter a NULL into the Excel spreadsheet so SoapUI NG Pro inserts that
value into my JSON without quotes?
My JSON has "field": "${DataSource#fieldvalue}",
My desired outcome after the DataSource is read in and populates my JSON is:
"field": NULL,
How to I enter the NULL into the Excel spreadsheet so this works? I have tried many variations and nothing works.
nmrao
9 years agoChampion Level 3
And I believe that, the one who reads the data from excel has to parse the data to the right data type. Since the way it is handled is not satisfying for you, then it is to be handled explicitly to meet the needs of the user. I am afraid that if could be handled in excel itself.
Related Content
- 5 years agompartyka
- 8 years agoJBARRETT5S
- 2 years agovericomms