Forum Discussion
Creating API queries into Jira Cloud sandbox – but query is only bringing back 10% of issues
Hi,
As I am new to the Atlassian cloud, I'd need help on the issue with query that I'm using as below in the screenshot. the query pulls only 100 issues out of 984. I don't have idea if there is any issue with its jql query. will apriciate your help.
Thank you,
query :- = Json.Document(Web.Contents("https://my-xxx-sandbox-905.atlassian.net/rest/api/2/search?jql=project = xxx&maxResults=5000"))
- Anonymous3 years ago
HI DeoYadav,
This should be a paginated rest api, you can refer to the official document to looping and get all the records:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Learn
Regards,Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
HI DeoYadav,
This should be a paginated rest api, you can refer to the official document to looping and get all the records:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Learn
Regards,Xiaoxin Sheng