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

Google Sheet Add-on for Jira Cloud can't export Comment Field

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.

      Description

      Being able to use the Jira Cloud Add-on for Google sheet is a helpful way to be able to export thousands of issues at the same time rather than going through the 1K limit on Jira. However there are certain fields that can't get exported such as comment field. Basically this feature doesn't seem to exist yet for the Add-on.

      Steps to Reproduce

      1. Use the guide here https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 to export your Jira Issues
      2. Use a Sample Jira function on Google Sheet as below
        =JIRA("project = AT2 order by created desc", "issuekey, summary, status, assignee, created, comment, priority, labels", 0, 1000)
        
      3. Notice the error [can't parse subfield]

      Expected

      The comments should be exported separated by a comma, or each comment should have it's own column

      Actual

      The comment column has this error [can't parse subfield]

      Workaround

      There is currently no workaround available

              rpatil@atlassian.com Rahul Patil (Inactive)
              hnyeche Prince N
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: