Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-57

As a user I'd like the ability to import Jira issues into Sheets without adding header row

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Currently a header row is automatically inserted into a Google Sheet when a job to import issues from Jira is executed.  This header row contains field names such as "Issue Type", "Key", "Summary", "Assignee", "Reporter", "Status", etc.  Imported issues are inserted below this header row.

      As a user I'd like the ability to import Jira issues into Sheets without adding this header row containing the names of the fields.

      Existing workarounds using Google Sheets today:

      • Returning all issues from a JQL minus the header:
      =QUERY(JIRA("project=TEST", "issueKey, assignee.displayName, status, summary"), "SELECT * OFFSET 1", 0)
      • Returning a single issue without the header
      =INDEX(JIRA("key=ABC-123", "issueKey, assignee.displayName, status, summary"), 2, 0)

            [API-57] As a user I'd like the ability to import Jira issues into Sheets without adding header row

            David Leal added a comment -

            Agreed, I am really surprised that this option was not considered in the JQL signature. It requires adding an additional optional input argument.

            David Leal added a comment - Agreed, I am really surprised that this option was not considered in the JQL signature. It requires adding an additional optional input argument.
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3126966 ] New: JAC Suggestion Workflow 3 [ 3588387 ]
            Evan Bovie made changes -
            Link New: This issue is related to API-124 [ API-124 ]

            Evan Bovie added a comment -

            Agreed. My reason is that I want to rename the headers for our external clients, while keeping the existing field names internal.

            Evan Bovie added a comment - Agreed. My reason is that I want to rename the headers for our external clients, while keeping the existing field names internal.
            Tanguy Crusson made changes -
            Description Original: Currently a header row is automatically inserted into a Google Sheet when a job to import issues from Jira is executed.  This header row contains field names such as "Issue Type", "Key", "Summary", "Assignee", "Reporter", "Status", etc.  Imported issues are inserted below this header row.

            As a user I'd like the ability to import Jira issues into Sheets without adding this header row containing the names of the fields.

            Possible workaround:
            {code:java}
            =INDEX(JIRA("key=ABC-123", "issueKey, assignee.displayName, status, summary"), 2, 0){code}             		New: Currently a header row is automatically inserted into a Google Sheet when a job to import issues from Jira is executed.  This header row contains field names such as "Issue Type", "Key", "Summary", "Assignee", "Reporter", "Status", etc.  Imported issues are inserted below this header row.

            As a user I'd like the ability to import Jira issues into Sheets without adding this header row containing the names of the fields.

            Existing workarounds using Google Sheets today:
             * Returning all issues from a JQL minus the header:

            {code:java}
            =QUERY(JIRA("project=TEST", "issueKey, assignee.displayName, status, summary"), "SELECT * OFFSET 1", 0){code}
             * Returning a single issue without the header

            {code:java}
            =INDEX(JIRA("key=ABC-123", "issueKey, assignee.displayName, status, summary"), 2, 0){code}
            Kristin Hamilton (Inactive) made changes -
            Description Original: Currently a header row is automatically inserted into a Google Sheet when a job to import issues from Jira is executed.  This header row contains field names such as "Issue Type", "Key", "Summary", "Assignee", "Reporter", "Status", etc.  Imported issues are inserted below this header row.

            As a user I'd like the ability to import Jira issues into Sheets without adding this header row containing the names of the fields.             		New: Currently a header row is automatically inserted into a Google Sheet when a job to import issues from Jira is executed.  This header row contains field names such as "Issue Type", "Key", "Summary", "Assignee", "Reporter", "Status", etc.  Imported issues are inserted below this header row.

            As a user I'd like the ability to import Jira issues into Sheets without adding this header row containing the names of the fields.

            Possible workaround:
            {code:java}
            =INDEX(JIRA("key=ABC-123", "issueKey, assignee.displayName, status, summary"), 2, 0){code}
            Kristin Hamilton (Inactive) created issue -

              tcrusson Tanguy Crusson
              khamilton@atlassian.com Kristin Hamilton (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: