Acumatica API - Endpoint Default 24 200 001Install

Summary

Fetches a list of Acumatica cases filtered by various fields or a custom OData expression.

Inputs

• BillableFilter — Filter results by Billable (boolean).
• BillableOvertimeFilter — Filter results by Billable Overtime (string).
• BillableTimeFilter — Filter results by Billable Time (string).
• BusinessAccountFilter — Filter results by Business Account (string).
• BusinessAccountNameFilter — Filter results by Business Account Name (string).
• CaseIDFilter — Filter results by Case ID (string).
• ClassIDFilter — Filter results by Class ID (string).
• ClosingDateFilter — Filter results by Closing Date (dateTime).
• ContactDisplayNameFilter — Filter results by Contact Display Name (string).
• ContactIDFilter — Filter results by Contact ID (number).
• ContractFilter — Filter results by Contract (string).
• DateReportedFilter — Filter results by Date Reported (dateTime).
• DescriptionFilter — Filter results by Description (string).
• InitialResponseFilter — Filter results by Initial Response (string).
• LastActivityDateFilter — Filter results by Last Activity Date (dateTime).
• LastIncomingActivityFilter — Filter results by Last Incoming Activity (dateTime).
• LastOutgoingActivityFilter — Filter results by Last Outgoing Activity (dateTime).
• LocationFilter — Filter results by Location (string).
• ManualOverrideFilter — Filter results by Manual Override (boolean).
• OvertimeSpentFilter — Filter results by Overtime Spent (string).
• OwnerFilter — Filter results by Owner (string).
• OwnerEmployeeNameFilter — Filter results by Owner Employee Name (string).
• PriorityFilter — Filter results by Priority (string).
• ReasonFilter — Filter results by Reason (string).
• ResolutionTimeFilter — Filter results by Resolution Time (string).
• SeverityFilter — Filter results by Severity (string).
• SLAFilter — Filter results by SLA (dateTime).
• StatusFilter — Filter results by Status (string).
• SubjectFilter — Filter results by Subject (string).
• TimeSpentFilter — Filter results by Time Spent (string).
• WorkgroupFilter — Filter results by Workgroup (string).
• WorkgroupDescriptionFilter — Filter results by Workgroup Description (string).
• LastModifiedDateTimeFilter — Filter results by Last Modified Date Time (dateTime).
• customFilter — Advanced OData $filter expression (e.g. CustomerID/value eq 'CUST001'). Applied in addition to any filter fields above.

Output shape

a list of items

Each item represents a Case record from Acumatica.

Examples

Example 1: Find all open cases for a specific business account.

Set BusinessAccountNameFilter.value to the account name.

Example 2: Filter cases by status and date range.

Set StatusFilter.value to 'Open' and ClosingDateFilter.operator to 'On or After' with a date.

Example 3: Use a custom OData query for complex filtering.

Enter a custom $filter expression in the customFilter field.

Links

• n8n community nodes installation guide