Get Actual Data Entries

GET {{baseUrl}}/odata/ActualDataEntries?$apply=filter(month eq 2022-09-01 and approvalStatus/code eq 'Approved')/groupby((project/id, role/id), aggregate(hoursNormalized with sum as hours, costNormalized with sum as cost))

ActualDataEntries collection is a simplified interface for accessing the Timesheet Details report.

The interface is designed to achieve grouped and normalized information about the actual cost and hours in the context of basic dimensions (date, project, user, approval status, role, and activity).

For performance reasons, it is highly recommended to group data directly in the query, as shown in the example.
All restrictions on the size of the data page and the number of requests per unit of time apply to access to this collection.

Request Params

RESPONSES

status: OK

{"@odata.context":"https://api.timetta.com/odata/$metadata#ActualDataEntries(project(id),role(id),hours,cost)","value":[{"@odata.id":null,"cost":1134000,"hours":272,"role":{"@odata.id":null,"id":null},"project":{"@odata.id":null,"id":null}},{"@odata.id":null,"cost":120000,"hours":32,"role":{"@odata.id":null,"id":null},"project":{"@odata.id":null,"id":"c6ee3e9c-a74f-4e8d-a0d9-3ae8b777ec11"}},{"@odata.id":null,"cost":180000,"hours":40,"role":{"@odata.id":null,"id":"9d9fa50b-9289-4f34-bc37-effb2f1c4172"},"project":{"@odata.id":null,"id":"1b95da40-a327-4a04-aedf-52fda0e0c58e"}},{"@odata.id":null,"cost":28500,"hours":19,"role":{"@odata.id":null,"id":"a0a6d79c-f1d5-4506-bbb7-cfc740697d6f"},"project":{"@odata.id":null,"id":"7979d62d-5236-491d-8d09-9cece6dfee29"}},{"@odata.id":null,"cost":7500,"hours":5,"role":{"@odata.id":null,"id":"a190a2d6-6bc5-47b5-959f-2e460883aa7c"},"project":{"@odata.id":null,"id":"8fa44ea0-df3b-47f0-bc62-fea3554c6c4c"}}]}