Jira Tempo and Power Query

[bjurek]

Hello!

I need your help because I can't manage to connect queries to the "Tempo" application in "Jira".

Using the link below, I can enter and download the csv I am interested in, however, I would like to do it directly using the API

https://NameOfCompany.atlassian.net/plugins/servlet/ac/io.tempo.jira/tempo-app#!/teams/team/6/timesheet?columns=WORKED_COLUMN&dateDisplayType=months&from=2023-03-01&groupBy=worker&order=DESCENDING&periodKey&periodType=LAST_PERIOD&showCharts=false&sortBy=WORKED_COLUMN&subPeriodType=MONTH&teamId=6&to=2023-03-31&viewType=TIMESHEET

I have two ways to access data. 1. API integration 2. OAuth 2.0 Applications

1. i have token

2. i have client id and client secret 

[v-jingzhang]

Hi @bjurek 

I have no experience with Tempo REST APIs. But if it has an API which can be called to get the expected data you want, it may be possible to convert the request into Power Query. Currently there are many documents about Tempo REST APIs, unfortunately I don't know which API is the suitable one. You may consult this problem in Atlassian Community to find out the appropriate API. Then we can test if it can be converted into Power Query. 

In Power Query, we usually use Web.Contents function to make a POST or GET request to an API to get data. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.