Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Modifying JIRA content Pack

Hi Everyone! I'm trying to modify the original template of the JIRA content Pack to get more information about the issues of my organization. https://powerbi.microsoft.com/es-es/blog/explore-your...
Need Help
pgomes's avatar
pgomes
Regular Visitor
8 years ago

Hi Anonymous,

 

I have the same necessity to get Jira worklogs. Can you share with me you modified content pack?

 

Another question: How can i modify the JIRA Content Pack?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi pgomes!

It's easy to modify the Jira Content pack.

Since the query editor I add a new function that look for the issues:

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

And after that I call this function from a new query and make the data transformations.

 

let
    Origen = SearchIssues(),
    #"Se expandió Incidencia" = Table.ExpandRecordColumn(Origen, "incidencia", {"key", "fields"}, {"key", "fields"})
in
   #"Se expandió Incidencia"