Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Too much data? (Consuming the JIRA ChangeLogs)

I have been successful in using the JIRA PBI Desktop PBIT published by this community - yet I also seek the changelog data for each issue.   -Referencing the JIRA REST API for the changelog  I am a...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous, The below does not load because of the following reasons:

1. A field e.g., status when it undergoes a standard lifecycle i.e., to do, in progress, testing and done it creates 4 unique entries for a user story

2. the above is only for a field imagine a scenario for every field and also for every custom field introduced within JIRA.

 

How to resolve this:

1. When you expand, choose only those fields you need the history for initially, e.g., sprint or status

2. Once the above is done, use the group by option to group by key and list all fields as 'table'

3. Then use the custom column and use the syntax of Table.Column ([column name], "the field you want to expand"

4. Then use the list expand option to list it as a value by using a delimiter

5. Remove duplicates and load

 

Note: The load will take some time but will definitely work and yes, I used your M query and it worked like a charm :)

 

Hope this helps and considering that this is not resolved for you.

 

Regards,

Anand

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Anonymous ,

       

      Thanks for sharing the link and your solution. I am also trying to read changelogs from JIRA like you did. But I am not able to follow the link and implement those steps for the M query you wrote above:

      let
    SearchIssue = () =>
    let 
        Source = FetchPages("", 500),
        table = Table.ExpandRecordColumn(Source, "Column1", {"id"}, {"id"}),
        Search = (id) => 
        let
            Issue = Json.Document(Web.Contents(URL & "/rest/api/2/issue/" & id & "?expand=changelog"))
        in
            Issue,
        Output = Table.AddColumn(table, "incidencia",each Search([id])) 
    in
        Output  
in
    SearchIssue

      Can you please help with some pointers on how you achieved it? Really appreciate your help in this regard.


      Regards,

      Anuj