How to compose a 7pace Timetracker API call (extension for Azure DevOps)

Learn how to compose an OData API call for the Timetracker API. The same API call can be used with Reporting widgets and other third-party software like Excel or PowerBI.

00:00 - Timetracker Reporting & API Settings
00:28 - API Root
00:58 - Endpoints
01:45 - Adding $select (where to find fields)
05:28 - Adding $filter (to remove workLogs without work item from results)
06:30 - Adding workLogsFilter
08:23 - workItemsFilter
09:16 - Adding $orderby
10:11 - Adding $top