how can fetch more than 100 Jira cloud Ticket via Alteryx Download tool?

[gowriangry]

how can fetch more than 100 Jira cloud Ticket via Alteryx Download tool?

Can extend the record limit? I want to download all the issues.

[JamesCharnley]

@gowriangry  It doesn't sound like something that the download tool is limiting, more likely it's how to deal with the API pagination. A brief look at the Jira cloud platform REST API documentation suggests there's a startAt and maxResults pagination parameters that you should be able to alter to get different records.

[gowriangry]

@JamesCharnley

 I set value in Startat 1 and maxresult  5000. But in download tool automatically change maxresult100

[JamesCharnley]

@gowriangry ah ok! I've had another look over the documentation and it says ' if the returned value of maxResults is less than the requested value, the returned value is the maximum.' So I guess you'll just need one call per 100 results in this instance, each one with a startAt value 100 higher than the last.

[gowriangry]

@ James Charnley

Jira able to fetch 5000 tickets in one call. Jira cloud only show 100 tickets. 

I used Generate Rows and macro to fetch whole tickets. But that option workflow run almost 17-25mins to fetch all tickets. that's why i try to fetch at least 5000 ticket in single run. 

[JamesCharnley]

@gowriangry  sounds like you pretty much have it sorted to the limits of the API. The cloud documentation uses 1000 as the example of a large number to find the maximum, so my guess in this instance is there isn't a way to do it faster!