How to know when fail to download all JIRA issues to the google sheet?

[Manjunatha K]

This is regarding Get issues from JIRA to the Google spread sheets:

I have set auto refresh at every hour. Some times once in a while it does not download all JIRA issues. It stops midway.  How to know any such errors?

Ref: https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?tab=overview&hosting=cloud

We have built automation sending out executive reports to the management teams. It is really embarrassing as we do not get the right report sometimes. 

Best way is if not complete then you trigger refresh again so that should bet all issues as per the filter. Otherwise let us know how to catch this exception in the google sheet and take necessary action. 

Thank you 

[MobilityStream]

Hi @Manjunatha K ,

Atlassian transitioned Jira Cloud for Sheets to maintenance mode, with enhancements discontinued, in summer of 2022 (background here). This has resulted in many user-reported issues and increased system unreliability. The user community is full of post by users that lose connectivity, see frequent errors (503 and others), experience various data issues (duplication, missing data, etc.) If reliable exports are important to your business, we recommend to try our Google Sheet Integration add-on. It works fundamentally different by exporting directly out of Jira via API calls. It is much more reliable and used by the largest organizations. Exports can be one-time, scheduled, or real-time. You can also export much richer data to create more sophisticated reports (Assets, Changelogs, Projects, Sprints, Users, etc.). Everything directly controlled within Jira. Give it a try.

Kind regards,

The Mobility Team