My managers want to see the approval calendar from Timetracker for all users. I know it is possible to get such data by REST API 3.0, but could we get such data from ODATA API?
|week 0 | week 1 | week 2
user 1 | approved | send for approval | not approved
user 2 | approved | approved | approved
Yes, it is possible to get such information from timesheets(worklogs) but if there are approved 0 hours per week I will not recognize this approval.
The format would be:
ODATA\approval\
filter by: approval date, approved week, user, approved by manager, hours, approval state.
-
Official comment
Hi Lukas,
Thank you for the request. This feature priority is pretty low because there is already a way to get this data using REST API. I've tried to use Microsoft Excel by adding a Web data source and managed to get the data from the REST API. It's not the same table as you wish, but you can use it as a data source and create a structure you need. See the following screenshots.
The usual way of authorization with the token.
I got this table with all the Approval data. You could modify it and make it look as you like.
You also might be interested in using other tools. E.g. Power BI - the same data can be taken there the same way.
Kind regards,
Roman
Comment actions
Please sign in to leave a comment.
Comments
2 comments