Creating API queries into Jira Cloud sandbox – but query is only bringing back 10% of issues

[DeoYadav]

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"))

[Anonymous · Accepted solution]

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