Jira and 1000 API Limit

[clewicki]

Looking for information/query syntax on how to edit our queries to our Jira instance so we can retreive all the data in Jira.  Currently, our query returns only 1000 rows.

[antonstorozhuk]

Hello @clewicki 

I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie... it's available for Jira Cloud / Server / Data Center.

We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at support@alpha-serve.com. Please let us know if you need any assistance.

Cheers!

Anton

===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HKINANI]

You can try : https://[YourJiraServer]/rest/api/2/search?maxResults=-1

[v-yuezhe-msft · Accepted solution]

 @clewicki,

You can take a look at the following similar thread about the M function.

http://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/td-p/20047/page/7

Regards,
Lydia

[Greg_Deckler]

In general, depends on how the Jira API works but people have gotten around this by writing M functions to essentially calculate the next URL that needs to be retrieved.