Hi everyone,
I’m currently facing a specific issue in a Make scenario and would appreciate any advice:
We receive JSON data from an HTTP module, which includes several numeric values. Some of these values can be exactly 0. Our goal is to write these values into specific cells in an existing Excel file using the Microsoft 365 Excel module.
Example of the JSON structure:
{
"data": {
"N89": 1998.06,
"P84": 1960.75,
"N62": 35.31,
"O62": 0,
"P62": 0,
"Q62": 0,
"R62": 0
}
}
The scenario works as expected for all numeric values greater than 0. However, when a value is exactly 0, Make throws an error during the Excel update operation. Other values, like 35.31 or 1960.75, are written to the Excel file without any issues.
We are using individual Excel update operations for each target cell, and the value is mapped like this:
{{3.data.O62}}
(The 3 refers to the HTTP module in the scenario.)
The problem occurs consistently whenever the value is 0. It seems that Make either treats 0 as an empty or invalid value or handles it incorrectly when updating Excel.
Our requirement:
All values, including 0, need to be written into the Excel file without errors. We do not want to build workarounds for every single cell. The solution needs to be dynamic, reliable, and scalable, regardless of how many values might be 0.
Has anyone experienced a similar issue, or does anyone know a reliable approach to handle this in Make?
Thanks in advance for your help.
Sebastian
