Announcement: Important Update in Jira Cloud for Google Sheets and Excel Integrations

[#1]

Dear Jira Community,

We are reaching out to inform you about upcoming changes to the Jira Cloud for Google Sheets and Jira Cloud for Microsoft Excel integrations. These updates are designed to enhance the reliability of your data imports.

Effective Date

16 December 2024

Context and Changes

Many of you have encountered reliability issues when importing Jira issues into your spreadsheets. To effectively address these concerns, we are implementing fundamental improvements to the core issue import functionality. Consequently, we will be removing the offset functionality available in the Jira.JQL() function in Jira Cloud for Excel and the JIRA() function in Jira Cloud for Google Sheets.

What you need to know

For Jira Cloud for Microsoft Excel Users

Old function → Jira.JQL(jql, [fields], offset, maxRows)

New function → Jira.JQL(jql, [fields], maxRows)

For Jira Cloud for Google Sheets Users

Old function → JIRA(jql, columns, offset, limit)

New function → JIRA(jql, columns, limit)

Migration Guidance

This is a breaking change and we understand that migrating existing spreadsheets might seem daunting, but rest assured, we're here to help. Here's how you can adjust to these changes:

• Utilize the Limit Parameter: Without the offset, you can still import as many issues as you need by configuring the limit parameter. This allows you to control the size of your data import.

• Leverage JQL Queries or Filters: You can refine your imports by using JQL queries or filters to specify the exact data you need, which is supported in both the Jira Cloud for Microsoft Excel and Jira Cloud for Google Sheets add-ons.

Benefits of This Change

• Improved Data Reliability: By eliminating the offset, the new system ensures more consistent and dependable data imports.

• Scalability: The new API changes are designed to support larger, more complex use cases efficiently.

Technical Details and Background

These changes are influenced by core updates to the Jira APIs. The new APIs will adopt a token-based pagination system, which enhances performance by removing the need for offsets.

For further technical insights and to understand the broader context of these changes, please refer to our detailed API changes announcement post. This post outlines the introduction of new endpoints and the removal of certain existing ones to enhance scalability and performance.

Support

We acknowledge that these changes may require adjustments to your current processes. Our goal is to ensure a seamless transition that ultimately enhances your experience with improved reliability.

Please feel free to reach out with any questions or concerns. Thank you for your understanding and continued support.

Best regards,

Atlassian Team