Hello everyone,
I am using the Document Generator for an APEX application. I am populating a report query using table values, but I've encountered an issue with null columns.
Instead of being null or empty, these columns are appearing in the generated JSON as non-breaking spaces (\u00A0).
Due to that, the XLSX template is populated with "space" (the cells are not empty).
Thank you for your help
Please see the JSON example below:
{
"change\_personal\_info": \[
{
"spreadsheet\_key": 1,
"c": "213152",
"e": "FRA",
"f": "1982-07-28",
"g": "FRA",
"h": "FRA-50",
"i": "F",
"l": "\\u00A0",
"o": "\\u00A0",
"aj": "FR\_C",
"am": “FRA”
},
{
"spreadsheet\_key": 2,
"c": "213153",
"e": "FRA",
"f": "1965-08-31",
"g": "FRA",
"h": "FRA-50",
"i": "M",
"l": "\\u00A0",
"o": "\\u00A0",
"aj": "FR\_C",
"am": “FRA”
}
\]
}