Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,363,252
Community Members
 
Community Events
168
Community Groups

JIRA JQL result set limited to 50

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!

 

1 answer

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

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"

 

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 

Suggest an answer

Log in or Sign up to answer