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
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"