Parse Zoho Reports JSON into Google Spreadsheet
Ulion, you helped us with a script to parse Zoho Reports CSV into a Google Spreadsheet but we'd like to try the Zoho Reports JSON instead because we think it might be faster.
I shared a G-Sheet with you called "Test JSON fetch" , which contains sample data, the original code and some JSON parse samples.
The issue is that some of our reports a large and include several data imports which regularly hit the Google imposed limit of 6 minutes per script execution. We're thinking that pulling the data in via JSON format might speed things up.
NOTE: The sample sheet "Test JSON fetch" only has 2 import data pages, so it won't time out, but the 2 data sets we selected are some of our most problematic because the queries are large. When these are combined with several other data pulls/result pages, they often time out even if we try to separate the script executions for each data set.
Edit our "Original_Code" script to import JSON instead of CSV from Zoho Reports.
We have included a couple sample JSON parse scripts in case there is something that you can use from them.