Tempo GetWorkLog Export with required time

Question

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

btrd · Answer

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

Susan Wu · Answer

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 · Answer

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