Forum Discussion
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.
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.
- dief1239 years agoOccasional Contributor
And how would you specify numerical values? i.e. 12345 in the Excel spreadsheet such that
it populates the JSON with "field": 12345,
- nmrao9 years agoChampion Level 3
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}
}- dief1239 years agoOccasional Contributor
I tried that with no quotes and the JSON service call failed because of syntax errors.