Forum Discussion
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.
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.
- nmrao9 years agoChampion Level 3And 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.
- dief1239 years agoOccasional Contributor
I have this REST Service call ‘Spreadsheet into Composition’ that I feed with an Excel spreadsheet DataSource2. I added the Groovy Script ‘Convert NULLS’ inline. Below is the Groovy Script.
“Convert NULLS – Groovy Script”
def dataSource2GlobalPartnerSBCId = context.expand( '${#TestCase#DataSource2#GlobalPartnerSBCId}' )
def globalPartnerSBCId = context.expand( '${#TestCase#GlobalPartnerSBCId}' )
def nullValue
if ("null" == dataSource2GlobalPartnerSBCId || !dataSource2GlobalPartnerSBCId) {
context.testCase.setPropertyValue ('globalPartnerSBCId', nullValue)
}
log.info context.testCase.getPropertyValue('globalPartnerSBCId')
Can you tell me why the field ‘'globalPartnerSBCId'’ in my JSON is not getting set properly to NULL?
JSON: the excel spreadsheet has a value = NULL.
{"SBCCommunicationDetails": [{
"CompassionSBCId": "C0028902042",
"GlobalPartnerSBCId": "NULL",
"SourceSystem": "SDL",
Related Content
- 4 years agompartyka
- 8 years agoJBARRETT5S
- 2 years agovericomms
Recent Discussions
- 19 hours agodipsthorat
- 23 hours agoisbiat
- 2 days agoarmygrad