Help needed in writing zeroes to null values

There is a weather API which returns null values for some rows, I will have to make it zero before inserting them into QuestDB. Totally of 25 columns and 13 rows are returned per API call, so doing it manually was not possible because getting key names was difficult, tried with JSON.parse, but failed.
Also there is an issue with Spreadsheet node, if some of the values are not present in the first row their respective column names don’t appear in the spreadsheet output.

Have attached screenshot of sample forecast data received from the API.

Hey @Meghna_jose,

Can you share the json output from the http request node so we can take a look?

Hi @Jon,
Thanks for the response. Here is the output from HTTP node, which we used to save as a file in the options provided in http node.

Output
date,postalKey,latitude,longitude,GustLocalAfternoonAvg,GustLocalAfternoonMax,GustLocalAfternoonMin,GustLocalDayAvg,GustLocalDayMax,GustLocalDayMin,GustLocalDaytimeAvg,GustLocalDaytimeMax,GustLocalDaytimeMin,GustLocalEveningAvg,GustLocalEveningMax,GustLocalEveningMin,GustLocalMorningAvg,GustLocalMorningMax,GustLocalMorningMin,GustLocalNighttimeAvg,GustLocalNighttimeMax,GustLocalNighttimeMin,GustLocalOvernightAvg,GustLocalOvernightMax,GustLocalOvernightMin\n20221116,,34.06,-84.34,8.833333333333334,10.0,8.0,8.466666666666667,10.0,7.0,8.75,10.0,8.0,,,,8.666666666666666,9.0,8.0,,,,,,\n20221117,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221118,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221119,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221120,,34.06,-84.34,8.8,9.0,8.0,8.5,9.0,7.0,8.5,9.0,7.0,,,,8.0,9.0,7.0,,,,,,\n20221121,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221122,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221123,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221124,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221125,,34.06,-84.34,8.666666666666666,9.0,8.0,8.357142857142858,9.0,7.0,8.666666666666666,9.0,8.0,7.8,8.0,7.0,8.666666666666666,9.0,8.0,7.8,8.0,7.0,,,\n20221126,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221127,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,\n20221128,,34.06,-84.34,,,,,,,,,,,,,,,,,,,,,