Tempo GetWorkLog Export with required time

[btrd]

Hi, i want to build reports about Tempo Worklogs in external reporting software. For that reason i am exporting worklogs with the tempo GetWorkLogs HTTP GET method as Excel format. I am missing one thing - the amount of hours that an employee has to register for each day. Depeding on day of week (weekend hours=0 or holidays=0, some employees are working only 4 hours per day, and so on). When i am exporting the worklogs manually from Tempo Webinterface as Excel, the are two Pages, one with the worklogs an one with data about the users. I have tried the different parameters for the http get method but i can spot this information.

Do you have any tips?

Thank you guys

[Susan Wu]

Hi @btrd ,

Tempo Servlet API GetWorklogs endpoint can only give you worklog related info. For required hours, you need to use Tempo REST API User Schedule V1 endpoint to get the value of requiredSeconds for the user and date into Excel. You can refer to this KB for more info.

BR,

Susan

[btrd]

Hi @Susan Wu ,

thanks for the reply. I got back to that task and tried User-Schedule-V1. It actually works well, thank you very much.

But it needs a single user as a query. I am creating a report for xxx users with their recorded times and the times needed. It would be very cumbersome if I had to make the call for each user. It would be handy if I basically got the result of User-Schedule-V1, just for multiple users and days at the same time.

Is there a possibility?

I am currently querying the required users with getTeamMembers.

Thanks & regards

[Susan Wu]

Hi @btrd ,

Team membership only gives you the joining/leaving dates of team members, but not their required hours.

Since you need both approval status and required hours with worklogs, you can use this private API to get them for a team. Just need to make sure the status = "approved".

Hope this helps.

BR,

Susan Wu

Tempo Product Expert

[btrd]

Hi @Susan Wu

thanks for your reply.

Thank you for your reply. While I was dealing with the Approval variant, I made a parallel loop call with User Schedule V1 for each affected user. That's how it works.

Thanks and regards