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
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Manu Quiroga / frontera.digital
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー