Hello, I am executing a JQL using REST API call from within a VBA macro. Here is my code ...
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!
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:
And then I wrote a piece of logic to paginate for the next 50. So, the next URI would be "startAt=50&maxResults=50"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.