JIRA JQL result set limited to 50

[Balu All]

Hello, I am executing a JQL using REST API call from within a VBA macro. Here is my code ...

sJQL = "https://somewebsite.com/issues2/rest/api/latest/search?jql=project%20%3D%20SISBTXTRPR%20AND%20issuetype%20%3D%20Story%20ORDER%20BY%20key%20ASC"

With JiraService

.Open "GET", sJQL, False
.SetRequestHeader "Content-Type", "application/json"
.SetRequestHeader "Accept", "application/json"
.SetRequestHeader "Authorization", "Basic " & UserPassBase64
.Send ""

Set JSONObj = JsonConverter.ParseJson(JiraService.ResponseText)

For i = 1 To 100
ActiveSheet.Cells(i, 1) = JSONObj("issues")(i)("key")
Next i 

End With

The result set is always limited to 50. How could I overcome this? Please help!

[Ivan Tovbin]

Hi,

You need to pass 'maxResults' parameter to your query, like so:

https://yourjira.com/rest/api/latest/search?maxResults=500

Also, please take a look at this ticket. 

[Balu All]

Thank you, I will try this way also. However, I was able to submit a request to the REST API using URI as below:

sJQL = "https://somewebsite.com/issues2/rest/api/latest/search?jql=project%20%3D%20SISBTXTRPR%20AND%20issuetype%20%3D%20Story%20ORDER%20BY%20key%20ASC&startAt=0&maxResults=50"

And then I wrote a piece of logic to paginate for the next 50. So, the next URI would be "startAt=50&maxResults=50"

sJQL = "https://somewebsite.com/issues2/rest/api/latest/search?jql=project%20%3D%20SISBTXTRPR%20AND%20issuetype%20%3D%20Story%20ORDER%20BY%20key%20ASC&startAt=50&maxResults=50"

[Mourad Marzouk]

hey @Ivan Tovbin did they change it? doesn't seem to work for me still only gets 50, I'm on python if that makes a difference