Forum Discussion
what is best way to set a field to null using JSON in a REST call?
something other than this?
"field": null,
- nmrao9 years agoChampion Level 3
Use groovy script to make that property null.
For example, there is a test case property say property1 with value either "null" or ""
And use ${#TestCase#test} in your REST request
NOTE: You don't need to assign value to test1 variable, you might already have it as property in DataSource step, so use that property.
- dief1239 years agoOccasional Contributor
That is exactly how I need to set the field to null:
"field": null
My question is how can I bring this NULL into the field from an Excel spreadsheet as a Datasource in SoapUI?
How do I specify the null in the excel spreadsheet so it fills the field variable with the word NULL and
not "field": "NULL"?
- nmrao9 years agoChampion Level 3
Have groovy script after the DataSource step.
For the first line replace it with below line, hoping that it works because never tried:
def test1 = context.expand('${DataSource#YourFieldPropertyInDataSource}')
and let the rest of the code as it is, shown in the earlier reply and see.- dief1239 years agoOccasional 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.
Related Content
- 5 years agompartyka
- 8 years agoJBARRETT5S
- 2 years agovericomms