It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

Jira max results is 100?

Bhakti Al Akbar Sep 19, 2017

I noticed recently that the max results with Jira API is 100. This used to be 1000. Why was this changed?

This actually impacts my app performance. It is now slowing down. Is there a way to increase the max results?

6 comments

Roberto Arconada Sep 19, 2017

Hello Bhakti,

I had the same issue and this the jira support answer:

this change of behaviour is actually intended since calling searches with maxResults set to 1000 in some cases it was causing OOM errors and it was bringing down JIRA.

 

I don't understand how they can do something like that without any advise :(

Like David Leal likes this
Bhakti Al Akbar Sep 19, 2017 • edited

Still, 100 is just too small in my opinion.

Warren Levy Community Leader Sep 20, 2017

I agree that this is a strange change to suddenly implement. There must be many people out there who are adversely affected by this. My concern is that it hasn't been publicised - shouldn't Atlassian make a change like this very visible?

The way I've coded it, I would be missing huge chunks of data and potentially not realise. Luckily I noticed this post and now need to make numerous code changes.

Like Josh Simnitt likes this
Lukas Krajnak Sep 20, 2017

This is impacting us as well. We pulling data from Jira every night, but know are pulls are failing as it can only pull 100 instead of 1000. Going to open ticket with Atlassian to understand why this was changed.

Lukas Krajnak Sep 20, 2017

I got reply from Atlassian: 

Good day. Thank you for reporting this issue.

After some checking, we have identified that you are hit by a recent bug which is discovered today. Please see the bug ticket as follow:

We apologize for the inconvenience caused to you due to this bug. We encourage you to visit the bug page linked above and click the Watch link near the top right to get updated of the bug fix. By doing this, it will ensure you are proactively informed of progress and updates on bug fix going forward.

There is already an internal ticket on our side about this bug and our developers have been notified about the bug. The fix is currently in progress. However, I'm afraid that I do not have ETA on the bug fix.

Lukas Krajnak Sep 20, 2017

They came back with same response as to Roberto Arconada

This change of behaviour is actually intended since, in some cases, calling searches with maxResults set to 1000 was causing OOM errors and it was bringing down JIRA.

Gaurav Tiwari Sep 20, 2017

We need the fix for this as our work is badly getting affected 

Warren Levy Community Leader Sep 20, 2017

Gaurav

Look at the comments (many of them) in the JRACLOUD ticket in Lukas's post above - I don't think there's going to be a fix, as this change is "fixing a bug" according to Atlassian!

Lukas Krajnak Sep 21, 2017

For Power BI users I have template which will pull issues by 100. Let me know if you are interested. 

Like Josh Simnitt likes this
Karen Cook Apr 17, 2018

I have a similar method for pulling 100 issues at a time in Power BI, however, I found that it only works in Power BI desktop.  I am unable to get the data to refresh on the Power BI server side as it won't refresh with functions being used.

Have you actually been able to get this to work on the server side with refreshing?

Saurabh Sahni Jul 03, 2018

Hi @Lukas Krajnak, can you please share the template? 

Lukas Krajnak Jul 09, 2018

Hi @Saurabh Sahni. Here is Template, hope it will work for you. All you need to do is update source and URL link in query editor 

 

https://www.amazon.com/clouddrive/share/MjrzIhCUlJ9EHMxk2c9irWnDVXemRSd5ZOAJGS4Aiub

Lukas Krajnak Jul 09, 2018

Hi @Saurabh Sahni. Here is Template, hope it will work for you. All you need to do is update source and URL link in query editor 

 

https://www.amazon.com/clouddrive/share/MjrzIhCUlJ9EHMxk2c9irWnDVXemRSd5ZOAJGS4Aiub

Stacey Jenkins Oct 10, 2018

@Lukas Krajnak - How are you passing the API Key and credentials for accessing the JIRA API with your template?

Lukas Krajnak Oct 12, 2018

Hi @Stacey Jenkins, I only pass credentials to access Jira API. I use Basic Authentication where I put username and Password. 

But for example with Tempo Timesheets I had to use API key and have it injected in the query in the header. 

 

Regards, 

 

Lukas

Comment

Log in or Sign up to comment
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

8,309 views 9 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you