JIRA Function returns User is rate limited, please try again after some time.

[SuperScrummer]

Hi,

I am using Jira Function in google sheets to generate some JIRA reports.

I am connecting to Jira Cloud.

JIRA reports were working as per normal and there is no change to the jira function.

 For last 2 days, i am having this error

"User is rate limited, please try again after some time."

What could be the reason and how to solve it ?

[Phill Fox]

Hi @SuperScrummer 

There are limits to the number of requests a single tenant can make at any one point. This is described in some more detail at https://community.developer.atlassian.com/t/are-there-rate-limits-for-jira-cloud-apis/4317/24. 

Now from your error message it looks lile you have hit the limit of requests that can be serviced. This could be because you are pulling more data now from Jira than you were before. Or could even be as simple as having two copies of your google sheet open at once with both attempting to pull the same information.  Have you by any chance shared the google sheet with you team recently?

The solution is not easy as it requires you to think about the information that you are pulling and make sure you minimise the number of requests/size of data returned. Also you need to consider how many people may be accessing at any one point. This includes users of the Jira instance as well as your google sheet. 

Hope this helps. 

Phill