Forum Discussion
Need help with paginating JIRA Rest call through Power Query
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
2 Replies
- v-juanli-msftCommunity Support
Hi Anonymous
Please follow the articles:
How to Import JIRA data in Power BI
Best Regards
MaggieCommunity 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.- AnonymousNot applicable
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