Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Customer records from Acumatica filtered by multiple optional criteria.

Inputs

• Account Ref Filter — Filter results by Account Ref with operators Equals, Contains, or Starts With.
• Apply Overdue Charges Filter — Filter results by Apply Overdue Charges boolean field, using Equals operator.
• Auto Apply Payments Filter — Filter results by Auto Apply Payments boolean field, using Equals operator.
• B Account ID Filter — Filter results by B Account ID number using comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Billing Address Override Filter — Filter results by Billing Address Override boolean field, using Equals operator.
• Billing Contact Override Filter — Filter results by Billing Contact Override boolean field, using Equals operator.
• Created Date Time Filter — Filter results by Created Date Time using comparison operators Equals, After, On or After, Before, or On or Before.
• Currency ID Filter — Filter results by Currency ID string with operators Equals, Contains, or Starts With.
• Currency Rate Type Filter — Filter results by Currency Rate Type string with operators Equals, Contains, or Starts With.
• Customer Class Filter — Filter results by Customer Class string with operators Equals, Contains, or Starts With.
• Customer ID Filter — Filter results by Customer ID string with operators Equals, Contains, or Starts With.
• Customer Category Filter — Filter results by Customer Category string with operators Equals, Contains, or Starts With.
• Customer Name Filter — Filter results by Customer Name string with operators Equals, Contains, or Starts With.
• Email Filter — Filter results by Email string with operators Equals, Contains, or Starts With.
• Enable Currency Override Filter — Filter results by Enable Currency Override boolean field, using Equals operator.
• Enable Rate Override Filter — Filter results by Enable Rate Override boolean field, using Equals operator.
• Enable Write Offs Filter — Filter results by Enable Write Offs boolean field, using Equals operator.
• FOB Point Filter — Filter results by FOB Point string with operators Equals, Contains, or Starts With.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time using comparison operators Equals, After, On or After, Before, or On or Before.
• Location Name Filter — Filter results by Location Name string with operators Equals, Contains, or Starts With.
• Multi Currency Statements Filter — Filter results by Multi Currency Statements boolean field, using Equals operator.
• Parent Record Filter — Filter results by Parent Record string with operators Equals, Contains, or Starts With.
• Price Class ID Filter — Filter results by Price Class ID string with operators Equals, Contains, or Starts With.
• Primary Contact ID Filter — Filter results by Primary Contact ID number using comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Print Dunning Letters Filter — Filter results by Print Dunning Letters boolean field, using Equals operator.
• Print Invoices Filter — Filter results by Print Invoices boolean field, using Equals operator.
• Print Statements Filter — Filter results by Print Statements boolean field, using Equals operator.
• Residential Delivery Filter — Filter results by Residential Delivery boolean field, using Equals operator.
• Saturday Delivery Filter — Filter results by Saturday Delivery boolean field, using Equals operator.
• Send Dunning Lettersby Email Filter — Filter results by Send Dunning Lettersby Email boolean field, using Equals operator.
• Send Invoicesby Email Filter — Filter results by Send Invoicesby Email boolean field, using Equals operator.
• Send Statementsby Email Filter — Filter results by Send Statementsby Email boolean field, using Equals operator.
• Shipping Address Override Filter — Filter results by Shipping Address Override boolean field, using Equals operator.
• Shipping Branch Filter — Filter results by Shipping Branch string with operators Equals, Contains, or Starts With.
• Shipping Contact Override Filter — Filter results by Shipping Contact Override boolean field, using Equals operator.
• Shipping Rule Filter — Filter results by Shipping Rule string with operators Equals, Contains, or Starts With.
• Shipping Terms Filter — Filter results by Shipping Terms string with operators Equals, Contains, or Starts With.
• Shipping Zone ID Filter — Filter results by Shipping Zone ID string with operators Equals, Contains, or Starts With.
• Ship Via Filter — Filter results by Ship Via string with operators Equals, Contains, or Starts With.
• Statement Cycle ID Filter — Filter results by Statement Cycle ID string with operators Equals, Contains, or Starts With.
• Statement Type Filter — Filter results by Statement Type string with operators Equals, Contains, or Starts With.
• Status Filter — Filter results by Status string with operators Equals, Contains, or Starts With.
• Tax Registration ID Filter — Filter results by Tax Registration ID string with operators Equals, Contains, or Starts With.
• Tax Zone Filter — Filter results by Tax Zone string with operators Equals, Contains, or Starts With.
• Terms Filter — Filter results by Terms string with operators Equals, Contains, or Starts With.
• Warehouse ID Filter — Filter results by Warehouse ID string with operators Equals, Contains, or Starts With.
• Write Off Limit Filter — Filter results by Write Off Limit number using comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Restrict Visibility To Filter — Filter results by Restrict Visibility To string with operators Equals, Contains, or Starts With.
• Credit Limit Filter — Filter results by Credit Limit number using comparison operators Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Entity Usage Type Filter — Filter results by Entity Usage Type string with operators Equals, Contains, or Starts With.
• Tax Exemption Number Filter — Filter results by Tax Exemption Number string with operators Equals, Contains, or Starts With.
• Is Guest Customer Filter — Filter results by Is Guest Customer boolean field, using Equals operator.
• Custom Filter — Apply an advanced OData $filter expression as a string to further customize filtering.

Output shape

a list of Customer records matching the specified filters

Returned data structure depends on Acumatica API response. Filters are combined into a single OData $filter query. All filters are optional; omitting them returns all Customers.

Links

• n8n community nodes installation guide