Community
Q&A
Jira
Questions
Adding tables to a custom field's description

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

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!

1 answer

0 votes

Hello Jakob,

Thank you for raising this question.

HTML markup was removed since version 6.2 due to security issues, however, the Wiki Markup is being implemented to it.

The format you mentioned above seems a little bit confusing for me. Can you please try the following format and let me know if it works for you?

||heading 1||heading 2||heading 3||
|col A1|col A2|col A3|
|col B1|col B2|col B3|

Just to ensure that you are editing it on the correct place, you must do it in the field Configuration page - Project Settings > Fields

That being said, it seems that we are still implementing the wiki markup on some Custom field types of JIRA server:

- Provide support for Wiki Markup in Custom Field descriptions

Can you confirm what is the Custom field type you are using? Is it a Number Custom Field?

We will be waiting for your answer.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Petterson,

Thanks for your reply.

I found out that the issue was in fact not in the html/wiki markup.
There was an existing Field Configuration for the project, which had and invalid table in it.
So when changing the Custom Fields description, this of course did not affect the project.

I basically overlooked that, possibly a novice mistake.

The following table worked for me:

<!DOCTYPE html>
<html>
<body>

<table>

 <tr>
 <td>Almost certain</td>
 <td> 3 </td>
 <td> 5 </td>
 <td> 6 </td>
 </tr>
 <tr>
 <td>Possible</td>
 <td> 2 </td>
 <td> 4 </td>
 <td> 4 </td>
 </tr>
 <tr>
 <td>Unlikely</td>
 <td> 1 </td>
 <td> 2 </td>
 <td> 3 </td>
 </tr>
 <tr>
 <td>Impact</td>
 <td> minor </td>
 <td> medium </td>
 <td> major </td>
 </tr>
</table>

</body>
</html>

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

1 answer

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events