Get info from "incorrect" JSON from Zoho Analytic
Hello all,
When you get info from the Zoho Analytics API, the JSON sometimes comes in a incorrect form. I am getting info from a report and the JSON comes this way
- { "ID":"81921000005496719", "Name":"Product1", "Total":"110.00"},{ "ID":"", "Name":"", "Total":"94.00"},{ "ID":"", "Name":"", "Total":"44.00"},{ "ID":"81921000005496749", "Name":"Product2", "Total":"150.00"},{ "ID":"", "Name":"", "Total":"322.00"},{ "ID":"", "Name":"", "Total":"84.00"},
I want to sum the total of every ID but I am not able to do it because of not all the data group has the Item ID. Does anyone how can I do this? I tried with a for each and flags but it seems impossible