Mastering Data Iteration in Zoho Analytics for Make.com Users

Have you ever tried to extract data using Zoho Analytics and found yourself stuck trying to iterate through the data? You're not alone. This is a common challenge that many Make.com users face. The data format often looks something like this:

{
“data”: [
{“Rank”:“1”,“Country”:“United States”,“Gold”:“46”},
{“Rank”:“2”,“Country”:“Great Britain”,“Gold”:“27”},
{“Rank”:“3”,“Country”:“China”,“Gold”:“26”}
]
}

Despite trying to parse through it, the data simply refuses to cooperate. So, how can we break this down?

Solution

The key is to understand that the data is an array. Therefore, we need to put it into an array iterator after the module. Here's how:

[Insert Screenshot]

And voila! The output should look something like this:

[Insert Output Screenshot]

Troubleshooting Tips

If you're still encountering issues, it might be due to the quotes surrounding the data. They are smart quotes (“ ”), and you need to change them to normal double quotes ("). Also, when pasting JSON into the “Parse JSON” module’s JSON field, you need to do a “text-only” paste, using the keyboard shortcut in Windows CTRLSHIFTV.

If Zoho is returning invalid JSON, you might need to run a replace function to change the quotes. However, before you do that, it would be helpful to share screenshots of the module fields and filters in question with the community. You can also export the scenario blueprint file to allow others to replicate the issue.

If you're finding your JSON invalid, you can use a tool like jsonformatter.org to find out exactly where the issue is. Paste your JSON on the left, click Validate or Format, and the output will be on the right side.

Conclusion

Iterating through data in Zoho Analytics can be a challenge, but with the right approach and tools, it's definitely manageable. Remember to put the data into an array iterator, change smart quotes to normal double quotes, and use a JSON formatter to validate your JSON. With these steps, you should be able to overcome this challenge and extract the data you need.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.