Forum Discussion
what is best way to set a field to null using JSON in a REST call?
something other than this?
"field": null,
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.
- nmrao9 years agoChampion Level 3
Really sorry about it. Suggested what possibly could help in the case mentioned in this question. And there is nothing much effort required too as what you need is already part of the of the earlier reply.
You may ignore the above if it could not be used.Do not have idea about the excel null.
Related Content
- 5 years agompartyka
- 8 years agoJBARRETT5S
- 2 years agovericomms