Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Change Order records from the Acumatica API, applying optional filter criteria to narrow down results based on properties like dates, amounts, statuses, references, and descriptions.

Inputs

• Change Date Filter — Filter results by Change Date using operators like equals, after, on or after, before, or on or before with a specific date-time value.
• Class Filter — Filter results by Class property using operators equals, contains, or starts with on a string value.
• Commitments Change Total Filter — Filter results by Commitments Change Total with numeric comparison operators.
• Completion Date Filter — Filter results by Completion Date using date-time comparison operators.
• Contract Time Change Days Filter — Filter results by Contract Time Change Days using numeric comparison operators.
• Cost Budget Change Total Filter — Filter results by Cost Budget Change Total with numeric comparison operators.
• Customer Filter — Filter results by Customer using string comparison operators.
• Description Filter — Filter results by Description with string comparison operators.
• Detailed Description Filter — Filter results by Detailed Description with string comparison operators.
• External Ref Nbr Filter — Filter results by External Ref Nbr with string comparison operators.
• Gross Margin Filter — Filter results by Gross Margin with numeric comparison operators.
• Gross Margin Amount Filter — Filter results by Gross Margin Amount with numeric comparison operators.
• Hold Filter — Filter results by Hold status with a boolean equals operator.
• Last Modified Date Time Filter — Filter results by last modified date-time using comparison operators.
• Original CO Ref Nbr Filter — Filter results by Original CO Ref Nbr with string comparison operators.
• Project ID Filter — Filter results by Project ID with string comparison operators.
• Ref Nbr Filter — Filter results by Ref Nbr with string comparison operators.
• Revenue Budget Change Total Filter — Filter results by Revenue Budget Change Total with numeric comparison operators.
• Revenue Change Nbr Filter — Filter results by Revenue Change Nbr with string comparison operators.
• Reverse Status Filter — Filter results by Reverse Status with string comparison operators.
• Status Filter — Filter results by Status with string comparison operators.
• Custom Filter — Apply an advanced custom OData $filter expression in addition to above filters.

Output shape

a list of Change Order records matching the specified filters

The results respect the applied filters combined into an OData $filter query. The output is typically an array of Change Order objects returned from the Acumatica API matching the criteria. Pagination details are not specified.

Examples

Example 1: Filter Change Orders by Change Date on or after 2024-01-01 and Status equals 'Open'

Set Change Date Filter operator to 'On or After' and value to '2024-01-01T00:00:00', then set Status Filter operator to 'Equals' and value to 'Open'.

Links

• n8n community nodes installation guide