Issue Summary

The Jira Cloud for Sheets app returns an inconsistent number of results (often non-contiguous) from time to time. The number of results returned varies throughout the day, sometimes returning all the correct number of results at times, but other times, only a limited number of results. When a limited number of results are returned, the results are non-contiguous.

This is happening due to Jira's and the API gateway's rate limit.

Steps to Reproduce

1. Open Google Sheets and launch the Jira Cloud add-on
2. Use the =JIRA() function to fetch the results of a JQL (more than 1k)

Expected Results

The results of the function (=JIRA()) in Google Sheets should return all the expected results every time it is run

Actual Results

The function (=JIRA()) returns all the expected results only some of the time. When retrying the same function again during another time, all the expected results are returned. When the function is repeated several times throughout the day, the number of results returned vary

Workaround

For the time being, the following workarounds can be considered;

• Open the filter results in Microsoft Excel
• Export the results as a CSV
• If using Jira Cloud for Sheets, consider reducing the number of fields that are returned
• If using Jira Cloud for Sheets, use the start and limit parameters in the =JIRA() function to return only a subset of results in different cells. For example;

=JIRA("project = ProjA order by updated desc", "", start, limit)