Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieves a paginated list of Acumatica accounts using an OData filter query, with filters for account attributes and a custom filter field.

Inputs

• AccountCDFilter — Filter by Account Code using an operator (Equals, Contains, Starts With).
• AccountClassFilter — Filter by Account Class using an operator (Equals, Contains, Starts With).
• AccountGroupFilter — Filter by Account Group using an operator (Equals, Contains, Starts With).
• AccountIDFilter — Filter by Account ID using numeric comparison operators (Equals, Greater Than, Less Than, etc.).
• ActiveFilter — Filter by Active status (Equals).
• CashAccountFilter — Filter by Cash Account status (Equals).
• ChartOfAccountsOrderFilter — Filter by Chart Of Accounts Order using numeric comparison operators (Equals, Greater Than, Less Than, etc.).
• ConsolidationAccountFilter — Filter by Consolidation Account using an operator (Equals, Contains, Starts With).
• CreatedDateTimeFilter — Filter by Created Date Time using comparison operators (Equals, After, Before, On or After, On or Before).
• CurrencyIDFilter — Filter by Currency ID using an operator (Equals, Contains, Starts With).
• DescriptionFilter — Filter by Description using an operator (Equals, Contains, Starts With).
• LastModifiedDateTimeFilter — Filter by Last Modified Date Time using comparison operators (Equals, After, Before, On or After, On or Before).
• PostOptionFilter — Filter by Post Option using an operator (Equals, Contains, Starts With).
• RequireUnitsFilter — Filter by Require Units status (Equals).
• RevaluationRateTypeFilter — Filter by Revaluation Rate Type using an operator (Equals, Contains, Starts With).
• SecuredFilter — Filter by Secured status (Equals).
• TaxCategoryFilter — Filter by Tax Category using an operator (Equals, Contains, Starts With).
• TypeFilter — Filter by Type using an operator (Equals, Contains, Starts With).
• UseDefaultSubaccountFilter — Filter by Use Default Subaccount status (Equals).
• customFilter — Advanced OData $filter expression (e.g., CustomerID/value eq 'CUST001') applied in addition to the standard filters.

Output shape

A list of items, each containing a single account record with fields populated from the Acumatica API response.

Returns an array of items; pagination is handled by the node based on the Acumatica API configuration.

Examples

Example 1: Retrieve all active cash accounts with a specific account code prefix.

ActiveFilter: Equals true; AccountCDFilter: Starts With 'CASH'

Example 2: Get accounts created after a specific date.

CreatedDateTimeFilter: On or After [Date]

Example 3: Filter accounts by type and use a custom OData query for a complex condition.

TypeFilter: Equals 'Asset'; customFilter: 'Type/value eq ''Asset'' and Active/value eq true'

Links

• n8n community nodes installation guide