Returns aggregated total values for timesheets based on the specified filters.
Headers
-
API token (can be retrieved from account settings)
-
ID of organization, for which the operation must be performed
Query parameters
-
Date filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- 01/01/2026..31/12/2026
- >=01/01/2026
- <=01/01/2026
- <>01/01/2026
Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.
- Range (
-
Employee contact ID filter.
Multi-value supported. Example: value1;value2 -
Client contact ID filter.
Multi-value supported. Example: value1;value2 -
Free-text description filter
-
Time spent filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Whether the entry is billable
-
Timesheet status filter
Values are
UNSUBMITTED,SUBMITTED,REJECTED,APPROVED, orBILLED. -
Billable amount filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Cost amount filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Task name filter
-
Billable rate filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Cost rate filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Department ID filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Order ID filter.
Multi-value supported. Example: value1;value2 -
Whether the entry is currently part of an active workflow
-
Order's client contact ID filter.
Multi-value supported. Example: value1;value2 -
Order name filter
-
Order joined ID filter
-
Order status filter
-
Parent order ID filter.
Multi-value supported. Example: value1;value2 -
Order department ID filter.
Multi-value supported. Example: value1;value2 -
Order status history entry status filter
Values are
OFFERED,OFFERED_SENT,CONFIRMED,CONFIRMED_SENT,BILLABLE,FINISHED, orCANCELLED. -
Order status history entry date filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- 01/01/2026..31/12/2026
- >=01/01/2026
- <=01/01/2026
- <>01/01/2026
Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.
- Range (
-
Order VAT rate ID filter.
Multi-value supported. Example: value1;value2 -
Order requested payment terms in days filter
-
Order's our contact name filter
-
Order currency ID filter.
Multi-value supported. Example: value1;value2 -
Order minimum invoiceable amount filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Order's client internal contact name filter
-
Order periodicity type filter
Values are
NONE,DAILY,WEEKLY,BI_WEEKLY,EVERY_MONTH,EVERY_2_MONTH,EVERY_3_MONTH,EVERY_4_MONTH,EVERY_6_MONTH, orANNUAL. -
Order recurring invoicing day of week filter
Values are
MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY, orSUNDAY. -
Order invoicing time filter
Values are
FIRST_DAY,LAST_DAY,FIRST_WORKING_DAY, orLAST_WORKING_DAY. -
Order recurring periodicity start date filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- 01/01/2026..31/12/2026
- >=01/01/2026
- <=01/01/2026
- <>01/01/2026
Use <>01/01/2026 to return only records where the selected date is not equal to the filter date.
- Range (
-
Whether disbursement fee is enabled for the order
-
Whether expenses are enabled for the order
-
Whether timesheets are enabled for the order
-
Order fixed amount filter (for TIMESHEET_FIXED orders)Supports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Order article ID filter.
Multi-value supported. Example: value1;value2 -
Order article quantity filterSupports comparison operators:
- Range (
..) - Greater than (
>) - Greater than or equal (
>=) - Less than (
<) - Less than or equal (
<=) - Not equal (
<>)
Examples:
- <=100.00
- >=100.00
- <>100.00
- 100.00..200.00
Use
<>0to return only records where the selected amount is not equal to zero. - Range (
-
Order article shipment status filter
Values are
SHIPPED,PARTIALLY_SHIPPED,NOT_SHIPPED, orSERVICE. -
Order office ID filter.
Multi-value supported. Example: value1;value2
curl \
--request GET 'https://wyzio.app/api-v1/timesheet/advanced/total'
{
"id": 42,
"date": "2026-05-04T09:42:00Z",
"employeeContactId": 42,
"employee": "string",
"client": "string",
"clientContactId": 42,
"order": "string",
"description": "string",
"time": 42.0,
"isBillable": true,
"status": "UNSUBMITTED",
"billableAmount": 42.0,
"costAmount": 42.0,
"taskName": "string",
"billableRate": 42.0,
"costRate": 42.0,
"departmentId": 42.0,
"orderIdOriginal": "string",
"orderId": 42,
"workflowPermissions": "string",
"isInWorkflow": true,
"flagsAmount": 42,
"orderContactId": 42,
"orderName": "string",
"orderJoinedId": "string",
"orderStatus": "string",
"parentOrderId": 42,
"orderDepartmentId": 42,
"orderHistoryStatus": "OFFERED",
"orderHistoryDate": "2026-05-04T09:42:00Z",
"orderVatRateId": 42,
"orderRequestedPaymentTerms": 42,
"orderOurContactName": "string",
"orderCurrencyId": 42,
"orderMinimumAmountToInvoice": 42.0,
"orderYourContactName": "string",
"orderPeriodicityType": "NONE",
"orderDayOfWeek": "MONDAY",
"orderInvoicingTime": "FIRST_DAY",
"orderPeriodicityStartDate": "2026-05-04T09:42:00Z",
"orderIsDisbursementFeeEnabled": true,
"orderIsExpensesEnabled": true,
"orderIsTimesheetsEnabled": true,
"orderFixedAmount": 42.0,
"orderOfficeId": 42
}