Tempo and Power BI integration

[Jean]

Hi, All.

I'm looking for an API that returns all logged hours for all accounts.

I've tried using /servlet/tempo-getWorklog/, the problem with this is that I need to register an IP address to access the data which makes it difficult to integrate with PowerBI. I could use Data Gateways, but this will just add unnecessary cost to the project. 

Cheers,

Jean

[Alexey Matveev · Accepted solution]

Hello, 

Concerning worklog Tempo stores worklogs in the same table as Jira stores. That is why you can use standard Jira rest api to query the worklog which would be api/2/worklog. Or you could use Tempo Rest api/rest/tempo-timesheets/3/worklogs/.

You can read more about Tempo rest api here

https://tempo.io/doc/timesheets/api/rest/latest/

You can read more about Jira rest api here

https://docs.atlassian.com/jira/REST/cloud/#api/2/worklog

[Aron Gombas _Midori_]

You could do this in 2 steps:

1. Better Excel Plugin can export Tempo worklogs to Excel (XLSX) files
2. Then Power BI can import Excel files.

It could be an alternative to accessing the servlet directly, and can give you an extra layer to pre-process worklog data.