nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Nicole Johnson_klqgww

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!

Accepted answers

All comments

Stanley Duback_u509bh

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_klqgww

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

Stanley Duback_u509bh

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

save as jql.png

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_klqgww

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud