Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a filtered list of Service Orders from the Acumatica API using various optional filter criteria.

Inputs

• Appointment Duration Filter — Filter results by Appointment Duration using operators Equals, Contains, or Starts With on a string value.
• Appointments Needed Filter — Filter results by whether Appointments Needed is true or false (only Equals operator).
• Billable Total Filter — Filter results by Billable Total using comparison operators (Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal) on a numeric value.
• Branch Location Filter — Filter results by Branch Location applying string operators Equals, Contains, or Starts With.
• Currency Filter — Filter results by Currency using string operators Equals, Contains, or Starts With.
• Customer Filter — Filter results by Customer with string operators Equals, Contains, or Starts With.
• Customer Order Filter — Filter results by Customer Order with string operators Equals, Contains, or Starts With.
• Date Filter — Filter results by Date using comparison operators Equals, After, On or After, Before, On or Before on a dateTime value.
• Default Project Task Filter — Filter results by Default Project Task with string operators Equals, Contains, or Starts With.
• Description Filter — Filter results by Description using string operators Equals, Contains, or Starts With.
• Estimated Duration Filter — Filter results by Estimated Duration applying string operators Equals, Contains, or Starts With.
• External Reference Filter — Filter results by External Reference using string operators Equals, Contains, or Starts With.
• Hold Filter — Filter results by Hold status (boolean) using Equals operator.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time with comparison operators Equals, After, On or After, Before, On or Before on a dateTime value.
• Location Filter — Filter results by Location with string operators Equals, Contains, or Starts With.
• Override Filter — Filter results by Override status (boolean) using Equals operator.
• Priority Filter — Filter results by Priority using string operators Equals, Contains, or Starts With.
• Problem Filter — Filter results by Problem with string operators Equals, Contains, or Starts With.
• Project Filter — Filter results by Project applying string operators Equals, Contains, or Starts With.
• Service Order Nbr Filter — Filter results by Service Order Number using string operators Equals, Contains, or Starts With.
• Service Order Total Filter — Filter results by Service Order Total with numeric comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Service Order Type Filter — Filter results by Service Order Type using string operators Equals, Contains, or Starts With.
• Severity Filter — Filter results by Severity applying string operators Equals, Contains, or Starts With.
• SLA Filter — Filter results by SLA date with comparison operators Equals, After, On or After, Before, On or Before on a dateTime value.
• SLA Time Filter — Filter results by SLA Time using comparison operators Equals, After, On or After, Before, On or Before on a dateTime value.
• Status Filter — Filter results by Status with string operators Equals, Contains, or Starts With.
• Supervisor Filter — Filter results by Supervisor using string operators Equals, Contains, or Starts With.
• Tax Total Filter — Filter results by Tax Total numeric value with comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Waiting for Purchased Items Filter — Filter results by whether Waiting for Purchased Items is true or false using Equals operator.
• Workflow Stage Filter — Filter results by Workflow Stage applying string operators Equals, Contains, or Starts With.
• Custom Filter — Provide an advanced OData $filter expression string to apply additional or custom filter criteria. This is combined with other filter fields if they are set.

Output shape

a list of Service Order records matching the provided filters in Acumatica's API response format

The result includes all Service Orders matching the combined filters. Filters are combined as an OData $filter query. If no filters are specified, all Service Orders are returned according to API limits. The customFilter input allows adding any valid OData filter expression for advanced queries. The operation returns structured data as per Acumatica's response schema for Service Orders.

Examples

Example 1: Retrieve all Service Orders for a specific Customer where the Status contains 'Open' and the Billable Total is greater than 1000.

Set Customer Filter operator to Contains with the customer name or ID, Status Filter operator to Contains with 'Open', and Billable Total Filter operator to Greater Than with value 1000.

Example 2: Fetch Service Orders created after January 1, 2024, with Hold status set to false.

Set Date Filter operator to After with value '2024-01-01T00:00:00' and Hold Filter value to false.

Links

• n8n community nodes installation guide