Forum Discussion

dief123's avatar
dief123
Occasional Contributor
9 years ago

Get NULL from Excel spreadsheet used for Datasource in SoapUI NG Pro?

We have operational JSON and several fields are set to variables to be populated with the values from an Excel spreadsheet used as a Datasource.   My question is how do I enter a NULL into the Exc...
JustinM89's avatar
JustinM89
Contributor

Your question was answered in the previous thread, you need to use a Groovy script.

dief123's avatar
dief123
Occasional Contributor
9 years ago

We do not want to use a groovy script and we have no groovy scripts developed for any reason.

 

We simply want to use a Spreadsheet as a Datasource and have the tool read the data into the JSON like

it is designed to do.

  • JustinM89's avatar
    JustinM89
    Contributor
    9 years ago

    It is doing what it's designed to do. When you type "Null" in your Excel sheet, it's treating it as a string; it has no way of knowing you literally want Null. Now you have a reason to develop a Groovy script.

     

    • dief123's avatar
      dief123
      Occasional Contributor
      9 years ago

      And how would you specify numerical values?  i.e. 12345 in the Excel spreadsheet such that

      it populates the JSON with "field": 12345,

       

       

      • nmrao's avatar
        nmrao
        Champion Level 3
        9 years ago

        It is recommended - no cross posts. For now answering, for further questsions if any, please use new topic.
        1. It is possible to choose data types in excel for each column.

        2. Since you know the data type of json element is a number, avoid double quotes while specifying value.
        For eg:
        {
        "age" : ${DataSource#age}
        }