Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a filtered list of customers from the Acumatica API using various optional filters that correspond to customer attributes and settings.

Inputs

• Account Ref Filter — Filter results by comparing 'Account Ref' using operators: equals, contains, or starts with.
• Apply Overdue Charges Filter — Filter customers where 'Apply Overdue Charges' is equal to true or false.
• Auto Apply Payments Filter — Filter customers where 'Auto Apply Payments' is equal to true or false.
• B Account ID Filter — Filter results by 'B Account ID' with comparison operators: equals, greater than, greater or equal, less than, or less or equal.
• Billing Address Override Filter — Filter customers where 'Billing Address Override' is true or false.
• Billing Contact Override Filter — Filter customers where 'Billing Contact Override' is true or false.
• Created Date Time Filter — Filter customers by their 'Created Date Time' using operators: equals, after, on or after, before, or on or before.
• Currency ID Filter — Filter results by 'Currency ID' using operators: equals, contains, or starts with.
• Currency Rate Type Filter — Filter results by 'Currency Rate Type' using operators: equals, contains, or starts with.
• Customer Class Filter — Filter results by 'Customer Class' using operators: equals, contains, or starts with.
• Customer ID Filter — Filter results by 'Customer ID' using operators: equals, contains, or starts with.
• Customer Category Filter — Filter results by 'Customer Category' using operators: equals, contains, or starts with.
• Customer Name Filter — Filter results by 'Customer Name' using operators: equals, contains, or starts with.
• Email Filter — Filter results by 'Email' using operators: equals, contains, or starts with.
• Enable Currency Override Filter — Filter customers where 'Enable Currency Override' is true or false.
• Enable Rate Override Filter — Filter customers where 'Enable Rate Override' is true or false.
• Enable Write Offs Filter — Filter customers where 'Enable Write Offs' is true or false.
• FOB Point Filter — Filter results by 'FOB Point' using operators: equals, contains, or starts with.
• Last Modified Date Time Filter — Filter customers by their 'Last Modified Date Time' with operators: equals, after, on or after, before, or on or before.
• Location Name Filter — Filter results by 'Location Name' using operators: equals, contains, or starts with.
• Multi Currency Statements Filter — Filter customers where 'Multi Currency Statements' is true or false.
• Parent Record Filter — Filter results by 'Parent Record' using operators: equals, contains, or starts with.
• Price Class ID Filter — Filter results by 'Price Class ID' using operators: equals, contains, or starts with.
• Primary Contact ID Filter — Filter customers by 'Primary Contact ID' with comparison operators: equals, greater than, greater or equal, less than, or less or equal.
• Print Dunning Letters Filter — Filter customers where 'Print Dunning Letters' is true or false.
• Print Invoices Filter — Filter customers where 'Print Invoices' is true or false.
• Print Statements Filter — Filter customers where 'Print Statements' is true or false.
• Residential Delivery Filter — Filter customers where 'Residential Delivery' is true or false.
• Saturday Delivery Filter — Filter customers where 'Saturday Delivery' is true or false.
• Send Dunning Lettersby Email Filter — Filter customers where 'Send Dunning Letters by Email' is true or false.
• Send Invoicesby Email Filter — Filter customers where 'Send Invoices by Email' is true or false.
• Send Statementsby Email Filter — Filter customers where 'Send Statements by Email' is true or false.
• Shipping Address Override Filter — Filter customers where 'Shipping Address Override' is true or false.
• Shipping Branch Filter — Filter results by 'Shipping Branch' using operators: equals, contains, or starts with.
• Shipping Contact Override Filter — Filter customers where 'Shipping Contact Override' is true or false.
• Shipping Rule Filter — Filter results by 'Shipping Rule' using operators: equals, contains, or starts with.
• Shipping Terms Filter — Filter results by 'Shipping Terms' using operators: equals, contains, or starts with.
• Shipping Zone ID Filter — Filter results by 'Shipping Zone ID' using operators: equals, contains, or starts with.
• Ship Via Filter — Filter results by 'Ship Via' using operators: equals, contains, or starts with.
• Statement Cycle ID Filter — Filter results by 'Statement Cycle ID' using operators: equals, contains, or starts with.
• Statement Type Filter — Filter results by 'Statement Type' using operators: equals, contains, or starts with.
• Status Filter — Filter results by 'Status' using operators: equals, contains, or starts with.
• Tax Registration ID Filter — Filter results by 'Tax Registration ID' using operators: equals, contains, or starts with.
• Tax Zone Filter — Filter results by 'Tax Zone' using operators: equals, contains, or starts with.
• Terms Filter — Filter results by 'Terms' using operators: equals, contains, or starts with.
• Warehouse ID Filter — Filter results by 'Warehouse ID' using operators: equals, contains, or starts with.
• Write Off Limit Filter — Filter customers by 'Write Off Limit' with comparison operators: equals, greater than, greater or equal, less than, or less or equal.
• Restrict Visibility To Filter — Filter results by 'Restrict Visibility To' using operators: equals, contains, or starts with.
• Credit Limit Filter — Filter customers by 'Credit Limit' with comparison operators: equals, greater than, greater or equal, less than, or less or equal.
• Entity Usage Type Filter — Filter results by 'Entity Usage Type' using operators: equals, contains, or starts with.
• Tax Exemption Number Filter — Filter results by 'Tax Exemption Number' using operators: equals, contains, or starts with.
• Is Guest Customer Filter — Filter customers where 'Is Guest Customer' is true or false.
• Custom Filter — Specify an advanced OData $filter expression to apply custom filtering in addition to the predefined filter fields.

Output shape

a list of customer records matching the applied filters

The output is an array of customer objects filtered by the conditions specified via the input parameters. If no filters are applied, all customers are returned. The 'Custom Filter' input allows advanced OData filtering syntax for additional fine-grained control beyond the provided filters.

Links

• n8n community nodes installation guide