Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Vendor records from the Acumatica API applying various optional filters to narrow results.

Inputs

• Account Ref Filter — Filter results by Account Ref using an operator (Equals, Contains, Starts With) and a string value.
• AP Account Filter — Filter results by AP Account with selectable operator and string value.
• AP Subaccount Filter — Filter results by AP Subaccount with operator and string value.
• Cash Account Filter — Filter results by Cash Account using an operator and a value string.
• Created Date Time Filter — Filter results by Created Date Time with operators such as Equals, After, On or After, Before, On or Before, using a date-time value.
• Currency ID Filter — Filter results by Currency ID using an operator and a string value.
• Currency Rate Type Filter — Filter results by Currency Rate Type with an operator and string value.
• Enable Currency Override Filter — Filter results to vendors with Enable Currency Override boolean value equal to the specified value.
• Enable Rate Override Filter — Filter by Enable Rate Override boolean value (equals operator only).
• F1099 Box Filter — Filter by F1099 Box with a string value and operator.
• F1099 Vendor Filter — Filter by F1099 Vendor boolean value (equals operator only).
• FATCA Filter — Filter by FATCA boolean value (equals operator only).
• FOB Point Filter — Filter by FOB Point using operator and string value.
• Foreign Entity Filter — Filter by Foreign Entity boolean value (equals operator only).
• Landed Cost Vendor Filter — Filter by Landed Cost Vendor boolean value (equals operator only).
• Last Modified Date Time Filter — Filter by Last Modified Date Time with operators Equals, After, On or After, Before, or On or Before using date-time value.
• Legal Name Filter — Filter by Legal Name using Equals, Contains, or Starts With operator and string value.
• Location Name Filter — Filter by Location Name using operator and string value.
• Max Receipt Filter — Filter by Max Receipt using numeric comparison operators and a number value.
• Min Receipt Filter — Filter by Min Receipt using numeric comparison operators and a number value.
• Parent Account Filter — Filter by Parent Account using operator and string value.
• Payment By Filter — Filter by Payment By using operator and string value.
• Payment Method Filter — Filter by Payment Method using operator and string value.
• Pay Separately Filter — Filter by Pay Separately boolean value (equals operator only).
• Print Orders Filter — Filter by Print Orders boolean value (equals operator only).
• Receipt Action Filter — Filter by Receipt Action with operator and string value.
• Receiving Branch Filter — Filter by Receiving Branch with operator and string value.
• Remittance Address Override Filter — Filter by Remittance Address Override boolean value (equals operator only).
• Remittance Contact Override Filter — Filter by Remittance Contact Override boolean value (equals operator only).
• Send Ordersby Email Filter — Filter by Send Orders By Email boolean value (equals operator only).
• Shipping Contact Override Filter — Filter by Shipping Contact Override boolean value (equals operator only).
• Shipping Address Override Filter — Filter by Shipping Address Override boolean value (equals operator only).
• Shipping Terms Filter — Filter by Shipping Terms using operator and string value.
• Ship Via Filter — Filter by Ship Via using operator and string value.
• Status Filter — Filter by Status using operator and string value.
• Tax Calculation Mode Filter — Filter by Tax Calculation Mode using operator and string value.
• Tax Registration ID Filter — Filter by Tax Registration ID using operator and string value.
• Tax Zone Filter — Filter by Tax Zone using operator and string value.
• Terms Filter — Filter by Terms using operator and string value.
• Threshold Receipt Filter — Filter by Threshold Receipt using numeric comparison operator and number value.
• Vendor Class Filter — Filter by Vendor Class using operator and string value.
• Vendor ID Filter — Filter by Vendor ID using operator and string value.
• Vendor Is Tax Agency Filter — Filter by Vendor Is Tax Agency boolean value (equals operator only).
• Vendor Name Filter — Filter by Vendor Name using Equals, Contains, or Starts With operator and string value.
• Warehouse Filter — Filter by Warehouse using operator and string value.
• Custom Filter — Apply an advanced OData $filter expression string to refine the query beyond the provided filter fields.

Output shape

a list of Vendor records matching the specified filters

Filters are combined to build an OData $filter expression sent with the request. The returned data includes vendor resources matching all filter criteria. Users can provide a custom OData filter string for complex queries in addition to the UI filters.

Links

• n8n community nodes installation guide