Acumatica API - Endpoint Default 23 200 001Install

Summary

Retrieve a list of Account records filtered by various optional criteria using OData filter expressions.

Inputs

• Account CD Filter — Filter accounts by Account CD with operators equals, contains, or starts with.
• Account Class Filter — Filter accounts by Account Class with operators equals, contains, or starts with.
• Account Group Filter — Filter accounts by Account Group with operators equals, contains, or starts with.
• Account ID Filter — Filter accounts by Account ID using comparison operators: equals, greater than, greater or equal, less than, less or equal.
• Active Filter — Filter accounts by Active status (boolean equals).
• Cash Account Filter — Filter accounts by Cash Account status (boolean equals).
• Chart Of Accounts Order Filter — Filter accounts by Chart Of Accounts Order using numeric comparison operators.
• Consolidation Account Filter — Filter accounts by Consolidation Account with string operators equals, contains, or starts with.
• Created Date Time Filter — Filter accounts by Created Date Time using datetime comparison operators.
• Currency ID Filter — Filter accounts by Currency ID with string operators equals, contains, or starts with.
• Description Filter — Filter accounts by Description with string operators equals, contains, or starts with.
• Last Modified Date Time Filter — Filter accounts by Last Modified Date Time using datetime comparison operators.
• Post Option Filter — Filter accounts by Post Option with string operators equals, contains, or starts with.
• Require Units Filter — Filter accounts by Require Units with boolean equals operator.
• Revaluation Rate Type Filter — Filter accounts by Revaluation Rate Type with string operators equals, contains, or starts with.
• Secured Filter — Filter accounts by Secured status with boolean equals operator.
• Tax Category Filter — Filter accounts by Tax Category with string operators equals, contains, or starts with.
• Type Filter — Filter accounts by Type with string operators equals, contains, or starts with.
• Use Default Subaccount Filter — Filter accounts by Use Default Subaccount with boolean equals operator.
• Custom Filter — Provide an advanced OData $filter expression string to apply additional filtering beyond the predefined filters.

Output shape

a list of Account records matching the applied filters

The operation returns the list of Account records from Acumatica matching all specified filters combined with an optional advanced OData $filter string. If no filters are specified, returns all accounts. Filtering is applied server-side using OData syntax. Returned data includes fields as defined by the resource schema.

Examples

Example 1: Retrieve all active accounts whose Account CD starts with '100' and created after 2023-01-01.

Set 'Active Filter' to true (Equals), 'Account CD Filter' operator to 'Starts With' and value to '100', set 'Created Date Time Filter' operator to 'After' and value to '2023-01-01T00:00:00'.

Example 2: Retrieve accounts filtered by a custom OData expression for more complex criteria.

Leave other filters empty and set 'Custom Filter' to a valid OData filter string (e.g., "CustomerID/value eq 'CUST001'").

Links

• n8n community nodes installation guide