i am trying to list all issues however getting only 50 results is there a way to get all issues

[Abhinav Jha]

i am trying to list all issues however getting only 50 results is there a way to get all issues in a project 
i have tried jql search howevet it is also giving 50 results only , there are more than 1000 issues in my project , i want a list of all the issues via api  .

any help will be much appriciated.

Thanks

[Joseph Chung Yin · Accepted solution]

@Abhinav Jha -

What are you trying to accomplished?  Are you trying to export the JQL search results?

In Jira/JSM envs -

DC/Server env - In this env, system admin can change the limitation via System > Advanced Settings.  However this configuration is applied at the system level.

Cloud env - You will follow the posting that @Kishan Sharma provide - https://confluence.atlassian.com/jirakb/increase-issue-limit-for-excel-exports-in-jira-cloud-779160811.html

Hope this also helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Abhinav Jha]

Hi Joseph , 
i am trying to integrate jira service desk with our portal , so want list of all the tickets inside a project in one page .
i have tried using max result param already and jql search as well , however not getting more than 50 results , in one page .

[Kishan Sharma]

Hi @Abhinav Jha 

Welcome to the Atlassian Community!

You have not mentioned whether you are using Server/DataCenter or Cloud. Please refer below links to know how to export more than 1000 issues from a project. 

Server/Data Center - Filter export only contains 1000 issues in Jira server | Jira | Atlassian Documentation

Cloud - Increase issue limit for Excel exports in Jira Cloud | Jira | Atlassian Documentation

Please refer to maxResults limit for the given API that is provided in the returned JSON object, and rely on pagination to retrieve the desired number of results in chunks. Hope this helps.

[Abhinav Jha]

Hi Kishan 
i have already tried max results param , however still result lists 50 tickets in one page 

i am looking for all the tickets in a project in one page.

[Kishan Sharma]

Hi @Abhinav Jha ,

By default, the Jira Issue Search REST API returns a maximum of 50 items per response. So, in your script, you will have to make multiple calls to retrieve the desired result using Pagination, you can read about it here - REST APIs (atlassian.com)

[Abhinav Jha]

HI Kishan 
thanks for providing this link , however i have already gone through this link , i was wondering is there any way where in we can get all tickets in a single api call 

[Kishan Sharma]

Hi Abhinav, unfortunately no, this is not possible via a single API call as pagination is enforced on this operation returning large collection of items.

[Kishan Sharma]

@Abhinav Jha If my answer was helpful, please mark the answer as accepted to help others community members having similar query.

[Abhinav Jha]

@Kishan Sharma  already marked as accepted 

[Kishan Sharma]

Thank you @Abhinav Jha, you can mark multiple answers accepted as well if they are helpful.

[Stefaan Boes]

We are using the spreadsheet plugin "Jira cloud for sheets" or "Jira cloud for excel" to directly import data from jira into a worksheet, based on existing jira filters or jql.  You can choose your fields and schedule imports.  Like magic !