Sign in

v1

latestOpenAPI 3.0.02026-08-06151101754.7 KB
Timesheet activities

Returns all timesheet activities

get/timesheets/activities

Query parameters

idinteger

Filters by IDs. Multiple inputs with id[]=1&id[]=2

per_pageinteger

Number of items per Page

pageinteger

Result Page

order_bystring

Order column

order_direction'asc' | 'desc'

Order direction. asc or desc possible

returnstring

Returns a single aggregate over the filtered list instead of the paginated result, e.g. {"data": {"count": 42}}. Allowed values: count, sum.column, min.column, max.column, avg.column (e.g. return=sum.duration_seconds). sum and avg require a numeric column.

group_bystring

Returns one aggregate row per bucket of the given column instead of the paginated result, e.g. group_by=type_id gives {"data": [{"type_id": 1, "count": 5}, ...]}. The per-bucket aggregate reuses the "return=" grammar and defaults to count (e.g. group_by=type_id&return=sum.id). Combine with order_by=<aggregate>&order_direction=desc for "top N" queries. Groupable columns are known model columns plus foreign keys. Datetime columns must be bucketed by granularity: group_by=created_at:month (also :year, :day/:date), giving {"data": [{"created_at": "2026-07", "count": 5}, ...]}. Results are capped at 1000 buckets.

withstring

You can load relations using the with parameter. Example for assignments/appointments: with[]=documents loads all related documents and adds it to the response.

excludeinteger

Exclude ids. Multiple inputs with exclude[]=3&exclude[]=6

startstring date-time

Filter by start date

endstring date-time

Filter by end date

startedstring date-time

Filter by started date

endedstring date-time

Filter by ended date

timesheet_idinteger

Filter by timesheet_id. Multiple inputs with timesheet_id[]=1&timesheet_id[]=2

type_idinteger

Filter by type_id. Multiple inputs with type_id[]=1&type_id[]=2

assignment_idinteger

Filter by assignment_id. Multiple inputs with assignment_id[]=1&assignment_id[]=2

documentation_idinteger

Filter by documentation_id. Multiple inputs with documentation_id[]=1&documentation_id[]=2

latnumber float

Center latitude for radius-based geo filter on the activity start position. Requires lng and radius.

lngnumber float

Center longitude for radius-based geo filter on the activity start position. Requires lat and radius.

radiusinteger

Radius in meters for geo filter. Requires lat and lng.

Response

Activities list

OR
OR

Example response

{
  "data": [
    {
      "id": 1,
      "timesheet_id": 1,
      "assignment_id": 1,
      "documentation_id": 1,
      "type_id": 1,
      "duration_seconds": 3600,
      "start_lat": 48.137154,
      "start_lng": 11.576124,
      "end_lat": 48.137154,
      "end_lng": 11.576124,
      "first_line": "First line",
      "icon": "fas fa-tasks",
      "color": "#000000",
      "contrast_color": "WHITE"
    }
  ]
}