Forum Discussion
Lusitan
5 years agoNew Member
Retrieve 50 items a time from Jira
Hi
I have been looking around for a simple answer to a dilema I have. Our Jira only supports retrieving 50 items a time otherwise it can actualy crash (it is a know problem of version 7 of Jira). I have been looking around for a simple way to do some pagination on the API request so I can build my table 50 items a time.
I have my jira jsql ready: https://myjiraurl/rest/api/2/search?jql=project = PROJECTNAME
Can anyone help me on how to create a function to retrieve all jira items from this but 50 a time to not "break" the API?
Thank you
1 Reply
- amitchandak
Super User
Lusitan , Have you already explored pagination approch ?
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78