Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Unable to export more than 4000 records using Jira search API Edited

Shruti I'm New Here Jul 01, 2021

Hi,

I'm using Jira Search API to get all issues for my project in Power BI.

Below is the API URL used:

https://jirainstance/rest/api/2/search?jql=project=projectname&maxResults=10000

Total records are around 9000, however, only 4000 are pulled.

How can I fetch all the 9000 records in Power BI using this API?

 

2 answers

Hi @Shruti 

In this case, you can try our Power BI Connector for Jira app.

It makes exporting extremely simple without the limitations you face when using the API. It supports all fields of data, including tables, custom fields, history, Jira Service Desk, Tempo Timesheets, Tempo Planner, Portfolio for Jira, Agile, Insight, and others.

I hope this will be helpful

Julia Turchenko,

Marketing Manager at Alpha Serve

Directly from the mouth of the beast:

maxResults

integer

The maximum number of items to return per page. To manage page size, Jira may return fewer items per page where a large number of fields are requested. The greatest number of items returned per page is achieved when requesting id or key only.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

I'm surprised you can pull 4000 issues at once. Normally you're only able to pull 100 at a time or 1000 if you limit your fields to id or keys only.

The solution is to perform multiple requests using the startAt parameter.

Shruti I'm New Here Jul 04, 2021

Thanks for response @Daniel Turczanski - __JQL Search Extensions 

In Power BI, how can I call multiple requests with different values in startAt?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

780 views 2 21
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