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

XMLWordPrintable

      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)

            Assignee:
            Tanguy Crusson
            Reporter:
            Kristin Hamilton (Inactive)
            Votes:
            5 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: