Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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-msft's avatar
    v-juanli-msft
    Community Support

    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's avatar
      Anonymous
      Not 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