Need help with paginating JIRA Rest call through Power Query

[Anonymous]

Hi,

I am trying to extract all the user details from JIRA REST API in Power BI. However, i managed to extract only 1000 records using the below REST call. I found number of articles on pagination but the record gets duplicated everytime as i did not find a way to iterate through pages. There are approximately 3000 unique JIRA users and i need to get them all. Can anyone please help me out to iterate records through pages as i am relatively new to M. Any help would be appreciated. 

let
contents = Json.Document(Web.Contents("https://xxxxxx.atlassian.net/rest/api/3/user/search?username&startAt=0&maxResults=1000")),
#"Converted to Table1" = Table.FromList(contents, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column2" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"self", "key", "accountId", "accountType", "name", "emailAddress", "avatarUrls", "displayName", "active", "timeZone", "locale"}, {"self", "key", "accountId", "accountType", "name", "emailAddress", "avatarUrls", "displayName", "active", "timeZone", "locale"})
in
#"Expanded Column2"

Thanks,

Arjun

[v-juanli-msft]

Hi @Anonymous 

Please follow the articles:

How to Import JIRA data in Power BI

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

Thanks for sharing the link. However, can you provide me the link or demonstrate how this can be achieved through Power Query?

I am not able to get all the records through Zappysys even with pagination.

Regards,

Arjun