How to extract worklogs including both a unique ID and the Tempo Account?

[Jon Karnofsky]

In order to sync worklogs to another system, I'm wanting to get worklogs out of Jira/Tempo Timesheets. In order to allow insert/updates, I need a unique ID for the worklog. I need to associate these worklogs with another system, and the Tempo Account Key is my identifier there.

I've tried a few ways, but can't quite get the data. Would love some help!

• If I export worklogs as a csv while in Tempo Reports, I get all worklog info, the account key, but no worklog unique identifier.
• If I use the Tempo REST API, the worklog data includes the unique id, but doesn't include the Account Key. I can use the worklogs/account endpoint, but I'd have to hit that call for every account every time.

[Susanne Götz _Tempo_ · Accepted solution]

Hi @Jon Karnofsky ,

When integrating with an external system, we recommend using the Tempo Servlet API. This API returns all worklogs within a selected period and additional parameters can be added. 
Please take a look at https://tempo-io.github.io/tempo-mtm-docs/ for more information.

In your case, to include the Tempo account id, you will need to add the "addBillingInfo=true" parameter to the URL. 

Regards,
Susanne Götz
Tempo team

[Jon Karnofsky]

Thank you! That's exactly what I needed. 

[Tim Owen]

Is this still working for you? It seems they have deprecated servlet api

[Jon Karnofsky]

Yes, I had to migrate to the /worklog endpoint in the Tempo API. I am able to get the Account value in the response, they are in the attributes section of each item in the response. The account shows up under a key named "_Account_" (at least for us).

It may show up automatically for us because the account's a required field for us. I "think" in the Tempo settings, the Custom Fields is where you can other fields to that, in case it's not required for you.