Unable to export more than 4000 records using Jira search API

[Shruti]

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?

[Daniel Turczanski - __JQL Search Extensions]

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]

Thanks for response @Daniel Turczanski - __JQL Search Extensions 

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

[Yuliia Maidanova -Alpha Serve-]

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