Acumatica API - Endpoint Default 23 200 001Install

Summary

Retrieve filtered Vendor records

Inputs

• AccountRefFilter — Filter results by Account Ref
• APAccountFilter — Filter results by AP Account
• APSubaccountFilter — Filter results by AP Subaccount
• CashAccountFilter — Filter results by Cash Account
• CreatedDateTimeFilter — Filter results by Created Date Time
• CurrencyIDFilter — Filter results by Currency ID
• CurrencyRateTypeFilter — Filter results by Currency Rate Type
• EnableCurrencyOverrideFilter — Filter results by Enable Currency Override
• EnableRateOverrideFilter — Filter results by Enable Rate Override
• F1099BoxFilter — Filter results by F1099 Box
• F1099VendorFilter — Filter results by F1099 Vendor
• FATCAFilter — Filter results by FATCA
• FOBPointFilter — Filter results by FOB Point
• ForeignEntityFilter — Filter results by Foreign Entity
• LandedCostVendorFilter — Filter results by Landed Cost Vendor
• LastModifiedDateTimeFilter — Filter results by Last Modified Date Time
• LegalNameFilter — Filter results by Legal Name
• LocationNameFilter — Filter results by Location Name
• MaxReceiptFilter — Filter results by Max Receipt
• MinReceiptFilter — Filter results by Min Receipt
• ParentAccountFilter — Filter results by Parent Account
• PaymentByFilter — Filter results by Payment By
• PaymentMethodFilter — Filter results by Payment Method
• PaySeparatelyFilter — Filter results by Pay Separately
• PrintOrdersFilter — Filter results by Print Orders
• ReceiptActionFilter — Filter results by Receipt Action
• ReceivingBranchFilter — Filter results by Receiving Branch
• RemittanceAddressOverrideFilter — Filter results by Remittance Address Override
• RemittanceContactOverrideFilter — Filter results by Remittance Contact Override
• SendOrdersbyEmailFilter — Filter results by Send Ordersby Email
• ShippingContactOverrideFilter — Filter results by Shipping Contact Override
• ShippingAddressOverrideFilter — Filter results by Shipping Address Override
• ShippingTermsFilter — Filter results by Shipping Terms
• ShipViaFilter — Filter results by Ship Via
• StatusFilter — Filter results by Status
• TaxCalculationModeFilter — Filter results by Tax Calculation Mode
• TaxRegistrationIDFilter — Filter results by Tax Registration ID
• TaxZoneFilter — Filter results by Tax Zone
• TermsFilter — Filter results by Terms
• ThresholdReceiptFilter — Filter results by Threshold Receipt
• VendorClassFilter — Filter results by Vendor Class
• VendorIDFilter — Filter results by Vendor ID
• VendorIsTaxAgencyFilter — Filter results by Vendor Is Tax Agency
• VendorNameFilter — Filter results by Vendor Name
• WarehouseFilter — Filter results by Warehouse
• customFilter — Custom OData $filter string (e.g. "OrderDate/value gt 2024-01-01T00:00:00")

Output shape

a list of Vendor records

Paginated results; may include $top, $skip, and custom filter; response body is empty on success/failure only

Examples

Example 1: Filter vendors by name containing 'Acme'

Set VendorNameFilter operator to 'Contains' and value to 'Acme'; optionally add StatusFilter eq 'Open'

Example 2: Retrieve only active vendors with cash account 1234

Set CashAccountFilter value to '1234' and PaySeparatelyFilter value to true; optionally set StatusFilter eq 'Active'

Example 3: Use advanced OData filter to get vendors created after a date

Enter customFilter value 'CreatedDateTime/value gt 2024-01-01T00:00:00'

Links

• n8n community nodes installation guide