Jira max results is 100?

[Bhakti Al Akbar]

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?

[Roberto Arconada]

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 :(

[Bhakti Al Akbar]

Still, 100 is just too small in my opinion.

[Warren]

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.

[Lukas Krajnak]

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]

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:

• JRACLOUD-67570.

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]

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]

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

[Warren]

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]

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

[Karen Cook]

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]

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

[Lukas Krajnak]

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

[Elwira Abramowska]

Hi @Lukas Krajnak
Can you send tamplate again?
And have you ever tried to connect to devtrack?
I have some projects in such system and I am looking for connecting with powerbi like to jira, it is possible?

thanks,

elwira

[Lukas Krajnak]

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]

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

[Lukas Krajnak]

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

[The Bulb Africa]

Hi @Lukas Krajnak is this template still available? Can i have access to using it?

[Lukas Krajnak]

Hi @The Bulb Africa ,

Here you can download the template

https://www.dropbox.com/s/rcbgqi8n86y0kwc/Jira%20Pull%20-%20Template.pbix?dl=0