Export worklogs using Jira/Tempo API

[Mike Kondrashin]

Tempo reports are useful, but I prefer to use Excel or jupyter notebook to go through the worklogs. Currently I do this by first exporting all worklogs from tempo reports into a csv file.

I want to automate this. I've tried using tempo and Jira native API to export data, but annoyingly enough they all have API limits in terms on the number of records they return.

I could work around if any of those allowed server side calculations (e.g. group by project and sum worklogs), but this is not available either.

Is there any way I could automate the whole process? If tempo can generate a csv file with 1000s of worklogs, is there a public API that I can use to return the same records in json or even in csv file?

[Alexander Eck [Tempo] · Accepted solution]

Hi Mike,

the Tempo REST API supports paging if the number of worklogs exceeds 1000 records. You can also use the "updatedFrom" parameter to possibly limit the amount of returned worklogs.

BR

[Mike Kondrashin]

@Alexander Eck [Tempo] many thanks for your reply. Is there any chance you could show how to use the pagination or point me to the documentation? thanks again. 

[Alexander Eck [Tempo]]

Mike,

The Tempo Cloud REST API response always consists of three parts:

1. “self”: this is a string to the endpoint url that has been called

2. “metadata”:  here you will see the total number of worklogs (“count”) if the “limit” parameter is greater than the amount of worklogs to be returned in the call. When the “limit” parameter is smaller than the amount of worklogs (in that case the “limit” parameter will be the same as “count”) you will get a “next” section that includes the url to be called for the next page of results (“offset” parameter is already been set). 
3. “results”:  this will return all worklog objects. You will need to iterate through all the returned worklogs.