List VacationBudget (find where)
Find a list of VacationBudget 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
quantityFilter by quantity
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
vacationTypeFilter by vacationType
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, quantity, startDate, vacationType, 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 VacationBudget (find where) › Responses
Responds with a paged list of VacationBudget records that match the specified criteria
Create VacationBudget
Create a new VacationBudget record.
Create VacationBudget › Request Body
Aerion model VacationBudget
Create VacationBudget › Responses
Responds with a JSON dictionary representing the newly created VacationBudget instance
Aerion model VacationBudget
Get VacationBudget (find one)
Update VacationBudget
Partially update an existing VacationBudget 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 VacationBudget record's primary key value
Update VacationBudget › Request Body
Aerion model VacationBudget
Update VacationBudget › Responses
Responds with the newly updated VacationBudget record as a JSON dictionary
Aerion model VacationBudget
Vacation budget breakdown for a user and year
Returns the rows that make up a user's vacation balance for the given year: residual days carried over (vacationType=4), yearly budget (1), custom adjustments (2), and absences that consume vacation days (3). Rows are sorted with residual first, then by extra.startDate ascending. Callers may read their own data, or anyone's with canAccessUsers or limitedTeamStaffAccess covering the user's team.
query Parameters
userUser ID whose vacation budget is being requested.
yearCalendar year (2000–2032).
Vacation budget breakdown for a user and year › Responses
Vacation budget rows for the user in the requested year.
yearprevious for residual days carried over from years before the requested year; current for rows belonging to the requested year.
quantityDays. Positive for budget / residual, negative for absence consumption.
vacationType1 yearly budget, 2 custom adjustment, 3 absence consumption, 4 residual carry-over.
extraRow-specific detail. null for residual (vacationType 4). For yearly (1): {vacationBudgetId}. For custom (2): {startDate, comment, vacationBudgetId}. For absence (3): {startDate, absenceId}.