Refresh

This website pulse.appsscript.info/p/2020/02/parsing-json-in-google-sheets-with-zendesk-and-google-script/ is currently offline. Cloudflare's Always Online™ shows a snapshot of this web page from the Internet Archive's Wayback Machine. To check for the live version, click Refresh.

AppsScriptPulse

Parsing JSON in Google Sheets with Zendesk and Google Script

For the most part, using ImportJSON works well—it’s a low effort way of pulling data from any API’s GET endpoint and storing that data in a sheet for further parsing and filtering. But, there was a flaw: Zendesk’s API calls are paginated and limited to 100 results per page. That meant that we needed to add a new ImportJSON() formula every 100 rows to get all of our data.

This follow-up guide goes the extra step—not to feed a big JSON file into ImportJSON, but to write a script that does everything, including pagination. And, as an added bonus, is easier on your API rate limit.

Source: Parsing JSON in Google Sheets with Zendesk and Google Script

Comments are closed.