Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Time Entry records from Acumatica, applying optional filters to narrow the results based on various properties such as approval status, employee, project ID, dates, and more, including an advanced custom OData $filter expression.

Inputs

• Approval Status Filter — Filter by the approval status using operators like equals, contains, or starts with.
• Approver Filter — Filter by approver using operators such as equals, contains, or starts with.
• Billable Filter — Boolean filter to specify if the time entries are billable.
• Billable Overtime Filter — Filter by billable overtime using operators like equals, contains, or starts with.
• Billable Time Filter — Filter by billable time using operators like equals, contains, or starts with.
• Certified Job Filter — Boolean filter to specify if the time entries are certified jobs.
• Cost Code Filter — Filter by cost code using operators like equals, contains, or starts with.
• Cost Rate Filter — Numeric filter for cost rate with comparison operators (equals, greater than, less than, etc.).
• Date Filter — Filter by date with comparison operators such as equals, after, on or after, before, or on or before.
• Earning Type Filter — Filter by earning type using operators like equals, contains, or starts with.
• Employee Filter — Filter by employee using operators like equals, contains, or starts with.
• External Ref Nbr Filter — Filter by external reference number using operators like equals, contains, or starts with.
• Labor Item Filter — Filter by labor item using operators like equals, contains, or starts with.
• Last Modified Date Time Filter — Filter by last modified date/time with operators such as equals, after, on or after, before, or on or before.
• Overtime Filter — Filter by overtime using operators like equals, contains, or starts with.
• Project ID Filter — Filter by project ID using operators like equals, contains, or starts with.
• Project Task ID Filter — Filter by project task ID using operators like equals, contains, or starts with.
• Summary Filter — Filter by summary text using operators like equals, contains, or starts with.
• Time Spent Filter — Filter by time spent using operators like equals, contains, or starts with.
• Union Local Filter — Filter by union local using operators like equals, contains, or starts with.
• WCC Code Filter — Filter by WCC code using operators like equals, contains, or starts with.
• Time Zone Filter — Filter by time zone using operators like equals, contains, or starts with.
• Custom Filter — Advanced OData $filter expression string to apply additional filtering beyond the standard fields.

Output shape

a list of Time Entry records from Acumatica

The returned data includes all Time Entries matching the provided filter criteria. Filters are combined with logical AND. The customFilter string, if provided, is applied in addition to other filter fields using OData syntax. Pagination is not explicitly described; returned list shape depends on Acumatica API responses.

Examples

Example 1: Retrieve all approved time entries for employee 'EMP123' with billable time.

Set 'Approval Status Filter' operator to 'Equals' and value to the desired approval status, set 'Employee Filter' operator to 'Equals' and value to 'EMP123', and set 'Billable Filter' to true.

Links

• n8n community nodes installation guide