Read collection

Reading the collection

Retrieve the list of time entries via OData with date-range filtering support.

GET /api/v01/WorkLogs/odata/WorkLogs?$format=json

Supported parameters: $select, $filter, $orderby, $skip, $top, $inlinecount, $format.

The source can be narrowed by log date through extra parameters:

Parameter	Type	Description
`i_WorkLogDateTimeStart`	string `YYYY-MM-DD`	Lower bound of the start date
`i_WorkLogDateTimeEnd`	string `YYYY-MM-DD`	Upper bound of the start date

Parameters are passed as regular query parameters.

Examples

A specific user's time logs for May 2026:

GET /api/v01/WorkLogs/odata/WorkLogs
  ?i_WorkLogDateTimeStart='2026-05-01'&i_WorkLogDateTimeEnd='2026-05-31'
  &$filter=WorkLogUserID eq '0000001234'
  &$select=WorkLogID,WorkLogDateStart,WorkLogDuration,TaskKey,TaskText,WorkLogDescription
  &$orderby=WorkLogDateTimeStart asc
  &$format=json

Total hours by project for a period, broken down by employees (via $inlinecount and aggregate fields):

GET /api/v01/WorkLogs/odata/WorkLogs
  ?i_WorkLogDateTimeStart='2026-05-01'&i_WorkLogDateTimeEnd='2026-05-31'
  &$filter=WorkLogProjectCode eq 'PROJ'
  &$select=WorkLogUserFullName,WorkLogSpentHours
  &$orderby=WorkLogSpentHours desc
  &$top=100
  &$inlinecount=allpages
  &$format=json