While trying to fetch JSON data through sheet if any string header is present in all integer values, string header is getting fetched as empty string.
[
{
“Column-1”: “”,
“Column-2”: “”,
“Column-3”: “”,
“Column-4”: “”,
“Column-5”: “”,
“Column-6”: “”,
“ACV”: “QWERRT”,
“rowIndex”: 0
},
{
“Column-1”: “dbStatus”,
“Column-2”: “remarks”,
“Column-3”: “startDate”,
“Column-4”: “endDate”,
“Column-5”: “”,
“Column-6”: “”,
“ACV”: “test1”,
“rowIndex”: 1
},
{
“Column-1”: “”,
“Column-2”: “”,
“Column-3”: “01-01-2022”,
“Column-4”: “01-01-2022”,
“Column-5”: 1,
“Column-6”: 899889889,
“ACV”: “1”,
“rowIndex”: 2
},
{
“Column-1”: “”,
“Column-2”: “”,
“Column-3”: “01-01-2022”,
“Column-4”: “01-01-2022”,
“Column-5”: 1,
“Column-6”: 899889889,
“ACV”: “1”,
“rowIndex”: 3
},
{
“Column-1”: “”,
“Column-2”: “”,
“Column-3”: “01-01-2022”,
“Column-4”: “01-01-2022”,
“Column-5”: 1,
“Column-6”: 899889889,
“ACV”: “1”,
“rowIndex”: 4
},
{
“Column-1”: “”,
“Column-2”: “”,
“Column-3”: “01-01-2022”,
“Column-4”: “01-01-2022”,
“Column-5”: 1,
“Column-6”: 899889889,
“ACV”: “1”,
“rowIndex”: 5
}
]
