Export info from JIRA to GSheets giving error: (cells.go:419) googleapi: Error 503: BackendError

[Nicole Johnson]

Hi everyone!

I currently use Jira cloud for sheets to get information from Jira exported into Google sheets. I have a bunch of different sheets for different projects. Some sheets will update on their daily schedule just fine, but a lot of sheets will get this error in Jira Cloud for Sheets: 

Last import failed with error: (cells.go:419) googleapi: Error 503: The service is currently unavailable., backendError

I can refresh the issues a time or two and the information will come over, but I need this to work everytime, or at least almost every time so I don't have to manually refresh it. 

I use JQL import type with the formula as:

PROJECT IN ("X") AND ISSUETYPE IN ("Bug") AND STATUS IN ("To Do", "In review", "In Progress", "Done", "Ready for review", "Testing", "Rejected", "Blocked", "Won't do") AND REPORTER IN ("X", "Y", "Z") ORDER BY created ASC

Is there an issue with my formula, or maybe the way Each project is set up in Jira? Thank you for any help!  

[MobilityStream]

Hi @Nicole Johnson

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

[Stanley Duback]

Hey Nicole,

I use a similar export for a report that I update daily and had issues initially with errors being thrown when using the JQL, have you by chance tried saving the JQL as a filter and using the filter as the import type vs the JQL?

[Nicole Johnson]

I have not, can you tell me how to do that so I can try it out?(:

[Stanley Duback]

Sure, when you have your JQL select save as at the top to create the filter

After you have your filter created in the Jira cloud for gsheets app you can change the get issues section from the JQL to the filter your have just saved.

[Nicole Johnson]

Awesome, that seems to be working so far! Thanks so much!

[Nicole Johnson]

It happened again.. After using the filters instead I got the same errors once everything autorefreshed last night. 

[Stanley Duback]

Have you attempted to remove and add the plugin into the sheet again? Does this issue persist across multiple gsheets? Do you have multiple google accounts signed in?

[Nicole Johnson]

I don't have multiple accounts signed in, that did happen at one point and I fixed that. I have multiple tabs on the one sheet, quite a few. I am currently changing them to refresh at different times of the day to see if that helps. They were all set to about 2 or 3 different times overnight, but I am going to change them to only have 2 refresh at the same time.