Modifying JIRA content Pack

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"