Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Case records from Acumatica, applying multiple optional filters on various case attributes to refine the results.

Inputs

• Billable Filter — Filter results by whether the case is billable (boolean equality).
• Billable Overtime Filter — Filter results by Billable Overtime using operators Equals, Contains, or Starts With on string values.
• Billable Time Filter — Filter results by Billable Time with string operators Equals, Contains, or Starts With.
• Business Account Filter — Filter cases by Business Account with string operators Equals, Contains, or Starts With.
• Business Account Name Filter — Filter cases by Business Account Name using string operators Equals, Contains, or Starts With.
• Case ID Filter — Filter by Case ID with string operators Equals, Contains, or Starts With.
• Class ID Filter — Filter cases by Class ID with string operators Equals, Contains, or Starts With.
• Closing Date Filter — Filter cases by Closing Date using date/time operators Equals, After, On or After, Before, or On or Before.
• Contact Display Name Filter — Filter by Contact Display Name using string operators Equals, Contains, or Starts With.
• Contact ID Filter — Filter by Contact ID using numeric comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Contract Filter — Filter cases by Contract with string operators Equals, Contains, or Starts With.
• Date Reported Filter — Filter cases by Date Reported using date/time operators Equals, After, On or After, Before, or On or Before.
• Description Filter — Filter by Description with string operators Equals, Contains, or Starts With.
• Initial Response Filter — Filter by Initial Response using string operators Equals, Contains, or Starts With.
• Last Activity Date Filter — Filter by Last Activity Date using date/time operators Equals, After, On or After, Before, or On or Before.
• Last Incoming Activity Filter — Filter by Last Incoming Activity date/time with operators Equals, After, On or After, Before, or On or Before.
• Last Outgoing Activity Filter — Filter by Last Outgoing Activity date/time using operators Equals, After, On or After, Before, or On or Before.
• Location Filter — Filter cases by Location with string operators Equals, Contains, or Starts With.
• Manual Override Filter — Filter results by Manual Override as a boolean equality.
• Overtime Spent Filter — Filter by Overtime Spent with string operators Equals, Contains, or Starts With.
• Owner Filter — Filter cases by Owner using string operators Equals, Contains, or Starts With.
• Owner Employee Name Filter — Filter by Owner Employee Name with string operators Equals, Contains, or Starts With.
• Priority Filter — Filter by Priority using string operators Equals, Contains, or Starts With.
• Reason Filter — Filter by Reason with string operators Equals, Contains, or Starts With.
• Resolution Time Filter — Filter by Resolution Time using string operators Equals, Contains, or Starts With.
• Severity Filter — Filter by Severity with string operators Equals, Contains, or Starts With.
• SLA Filter — Filter by SLA date/time with operators Equals, After, On or After, Before, or On or Before.
• Status Filter — Filter cases by Status using string operators Equals, Contains, or Starts With.
• Subject Filter — Filter cases by Subject with string operators Equals, Contains, or Starts With.
• Time Spent Filter — Filter by Time Spent using string operators Equals, Contains, or Starts With.
• Workgroup Filter — Filter by Workgroup using string operators Equals, Contains, or Starts With.
• Workgroup Description Filter — Filter by Workgroup Description with string operators Equals, Contains, or Starts With.
• Last Modified Date Time Filter — Filter by Last Modified Date Time using date/time operators Equals, After, On or After, Before, or On or Before.
• Custom Filter — Apply an advanced OData $filter expression (string) to add custom filtering beyond the predefined fields.

Output shape

A list of Case objects matching the provided filters.

Filters are combined into an OData $filter query string. Records returned respect all specified filter criteria. The operation supports advanced custom OData filter expressions for complex queries.

Examples

Example 1: Fetch all cases where Status contains 'Open' and Priority equals 'High'.

Set 'Status Filter' operator to 'Contains' and value to 'Open'. Set 'Priority Filter' operator to 'Equals' and value to 'High'. Leave other filters empty.

Links

• n8n community nodes installation guide