List Absence (find where)
Find a list of Absence records that match the specified criteria.
Tip: All query parameters accept multiple values for array filtering — e.g. ?id=1&id=2 or ?id[]=1&id[]=2. This also works within the where parameter: ?where={"id":[1,2,3]}.
Note: The per-attribute filter parameters and the where parameter are mutually exclusive. If where is supplied, the per-attribute filters are ignored — put all filter criteria inside where instead. limit, skip, sort, and populate are unaffected.
query Parameters
userFilter by user ID
startDateFilter by start date (YYYY-MM-DD). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
endDateFilter by end date (YYYY-MM-DD). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
absenceTypeID of the associated AbsenceType record. E.g. vacation, sick leave, home office. Determines the values of the read-only boolean flags on this record.
reducesOvertimeReduces overtime balance. Should only be set for overtime-reduction type absences. Inherited from the linked AbsenceType on create and when absenceType is changed; cannot be modified independently.
countsAsVacationDeducted from the employee's vacation allowance. Inherited from the linked AbsenceType on create and when absenceType is changed; cannot be modified independently.
idFilter by record ID
createdAtFilter by creation date (YYYY-MM-DD or YYYY-MM-DDTHH:mm:ss.sssZ). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
updatedAtFilter by last update date (YYYY-MM-DD or YYYY-MM-DDTHH:mm:ss.sssZ). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
whereA JSON-encoded Waterline criteria for advanced filtering. Only whitelisted criteria are supported: user, startDate, endDate, absenceType, reducesOvertime, countsAsVacation, id, createdAt, updatedAt. Sub-attribute modifiers such as startsWith, >=, <=, >, <, and != are supported on any whitelisted criterion. The contains modifier is not supported on this model.
Note: If where is supplied, the per-attribute filter query parameters above are ignored — where is the entire criteria. (limit, skip, sort, and populate are unaffected.) To combine filters, put them all inside where.
e.g. ?where={"startDate":{">=":"2026-06-01","<":"2026-07-01"}}
limitThe maximum number of records to return. Defaults to 10000, capped at 50000.
skipThe number of records to skip (useful for pagination).
sortThe sort order. By default, returned records are sorted by primary key value in ascending order.
e.g. ?sort=lastName%20ASC
List Absence (find where) › Responses
Responds with a paged list of Absence records that match the specified criteria
Get Absence (find one)
Update Absence
Partially update an existing Absence record. Despite using PUT, this endpoint applies PATCH semantics — only the fields included in the request body are modified; omitted fields are left unchanged.
path Parameters
idThe desired Absence record's primary key value
Update Absence › Request Body
Aerion model Absence
Update Absence › Responses
Responds with the newly updated Absence record as a JSON dictionary
Aerion model Absence