CODEWITHSUNDEEP
exceljirapowerquery
Dince-afk
Dince-afk

Reputation: 220

How can I fetch Jira ticket data with Excel's Power Query functions?

I want to create a fetch query to get data from a saved search of filtered tickets on Jira and get back a table with all the tickets.

I found this URL which does download a CSV file with my goal data. I copied the link when using the "export" function on Jira's search tickets page.

https://*****/jira/sr/jira.issuesview.search-request***.csv?delimiter=,

But when I enter this URL into Excel Power Query's "Get Data from Web" it returns an unusable HTML in table format and not a CSV with rows for each ticket.

How can I download data via Power Queries from Jira?

Thanks in advance!

Upvotes: 2

Views: 705

Answers (1)

horseyride
horseyride

Reputation: 21373

You can download CSV files from the web, similar to below

let Source = Csv.Document(Web.Contents("https://www.fdic.gov/bank/individual/failed/banklist.csv"),[Delimiter=",",Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Bank Name ", type text}, {"City ", type text}, {"State ", type text}, {"Cert ", Int64.Type}, {"Acquiring Institution ", type text}, {"Closing Date ", type date}, {"Fund", Int64.Type}})
in #"Changed Type"

the question I guess is what Jira is putting out

Upvotes: 1

Related Questions