Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Stock Items from the Acumatica API, optionally applying extensive OData filters based on multiple Stock Item fields and a custom filter expression.

Inputs

• ABC Code Filter — Filter results by ABC Code using operators Equals, Contains, or Starts With.
• Auto Incremental Value Filter — Filter results by Auto Incremental Value using operators Equals, Contains, or Starts With.
• Average Cost Filter — Filter results by Average Cost using numeric comparison operators (Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal).
• Base UOM Filter — Filter results by Base UOM using operators Equals, Contains, or Starts With.
• COGS Account Filter — Filter results by COGS Account using operators Equals, Contains, or Starts With.
• COGS Subaccount Filter — Filter results by COGS Subaccount using operators Equals, Contains, or Starts With.
• Content Filter — Filter results by Content using operators Equals, Contains, or Starts With.
• Country Of Origin Filter — Filter results by Country Of Origin using operators Equals, Contains, or Starts With.
• Current Std Cost Filter — Filter results by Current Std Cost using numeric comparison operators.
• Default Issue Location ID Filter — Filter results by Default Issue Location ID using operators Equals, Contains, or Starts With.
• Default Price Filter — Filter results by Default Price using numeric comparison operators.
• Default Receipt Location ID Filter — Filter results by Default Receipt Location ID using operators Equals, Contains, or Starts With.
• Default Subitem Filter — Filter results by Default Subitem using operators Equals, Contains, or Starts With.
• Default Warehouse ID Filter — Filter results by Default Warehouse ID using operators Equals, Contains, or Starts With.
• Deferral Account Filter — Filter results by Deferral Account using operators Equals, Contains, or Starts With.
• Deferral Subaccount Filter — Filter results by Deferral Subaccount using operators Equals, Contains, or Starts With.
• Description Filter — Filter results by Description using operators Equals, Contains, or Starts With.
• Dimension Volume Filter — Filter results by Dimension Volume using numeric comparison operators.
• Dimension Weight Filter — Filter results by Dimension Weight using numeric comparison operators.
• Discount Account Filter — Filter results by Discount Account using operators Equals, Contains, or Starts With.
• Discount Subaccount Filter — Filter results by Discount Subaccount using operators Equals, Contains, or Starts With.
• Image Url Filter — Filter results by Image Url using operators Equals, Contains, or Starts With.
• Inventory Account Filter — Filter results by Inventory Account using operators Equals, Contains, or Starts With.
• Inventory ID Filter — Filter results by Inventory ID using operators Equals, Contains, or Starts With.
• Inventory Subaccount Filter — Filter results by Inventory Subaccount using operators Equals, Contains, or Starts With.
• Is A Kit Filter — Filter results by whether the Stock Item is a Kit (boolean equals).
• Item Class Filter — Filter results by Item Class using operators Equals, Contains, or Starts With.
• Item Status Filter — Filter results by Item Status using operators Equals, Contains, or Starts With.
• Item Type Filter — Filter results by Item Type using operators Equals, Contains, or Starts With.
• Landed Cost Variance Account Filter — Filter results by Landed Cost Variance Account using operators Equals, Contains, or Starts With.
• Landed Cost Variance Subaccount Filter — Filter results by Landed Cost Variance Subaccount using operators Equals, Contains, or Starts With.
• Last Cost Filter — Filter results by Last Cost using numeric comparison operators.
• Last Modified Filter — Filter results by Last Modified date using date comparison operators.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time using date comparison operators.
• Last Std Cost Filter — Filter results by Last Std Cost using numeric comparison operators.
• Lot Serial Class Filter — Filter results by Lot Serial Class using operators Equals, Contains, or Starts With.
• Markup Filter — Filter results by Markup using numeric comparison operators.
• Max Cost Filter — Filter results by Max Cost using numeric comparison operators.
• Min Cost Filter — Filter results by Min Cost using numeric comparison operators.
• Min Markup Filter — Filter results by Min Markup using numeric comparison operators.
• MSRP Filter — Filter results by MSRP using numeric comparison operators.
• Packaging Option Filter — Filter results by Packaging Option using operators Equals, Contains, or Starts With.
• Pack Separately Filter — Filter results by Pack Separately (boolean equals).
• Pending Std Cost Filter — Filter results by Pending Std Cost using numeric comparison operators.
• PO Accrual Account Filter — Filter results by PO Accrual Account using operators Equals, Contains, or Starts With.
• PO Accrual Subaccount Filter — Filter results by PO Accrual Subaccount using operators Equals, Contains, or Starts With.
• Posting Class Filter — Filter results by Posting Class using operators Equals, Contains, or Starts With.
• Price Class Filter — Filter results by Price Class using operators Equals, Contains, or Starts With.
• Price Manager Filter — Filter results by Price Manager using operators Equals, Contains, or Starts With.
• Price Workgroup Filter — Filter results by Price Workgroup using operators Equals, Contains, or Starts With.
• Product Manager Filter — Filter results by Product Manager using operators Equals, Contains, or Starts With.
• Product Workgroup Filter — Filter results by Product Workgroup using operators Equals, Contains, or Starts With.
• Purchase Price Variance Account Filter — Filter results by Purchase Price Variance Account using operators Equals, Contains, or Starts With.
• Purchase Price Variance Subaccount Filter — Filter results by Purchase Price Variance Subaccount using operators Equals, Contains, or Starts With.
• Purchase UOM Filter — Filter results by Purchase UOM using operators Equals, Contains, or Starts With.
• Reason Code Subaccount Filter — Filter results by Reason Code Subaccount using operators Equals, Contains, or Starts With.
• Sales Account Filter — Filter results by Sales Account using operators Equals, Contains, or Starts With.
• Sales Subaccount Filter — Filter results by Sales Subaccount using operators Equals, Contains, or Starts With.
• Sales UOM Filter — Filter results by Sales UOM using operators Equals, Contains, or Starts With.
• Standard Cost Revaluation Account Filter — Filter results by Standard Cost Revaluation Account using operators Equals, Contains, or Starts With.
• Standard Cost Revaluation Subaccount Filter — Filter results by Standard Cost Revaluation Subaccount using operators Equals, Contains, or Starts With.
• Standard Cost Variance Account Filter — Filter results by Standard Cost Variance Account using operators Equals, Contains, or Starts With.
• Standard Cost Variance Subaccount Filter — Filter results by Standard Cost Variance Subaccount using operators Equals, Contains, or Starts With.
• Subject To Commission Filter — Filter results by Subject To Commission (boolean equals).
• Tax Category Filter — Filter results by Tax Category using operators Equals, Contains, or Starts With.
• Tariff Code Filter — Filter results by Tariff Code using operators Equals, Contains, or Starts With.
• Use On Entry Filter — Filter results by Use On Entry (boolean equals).
• Valuation Method Filter — Filter results by Valuation Method using operators Equals, Contains, or Starts With.
• Volume UOM Filter — Filter results by Volume UOM using operators Equals, Contains, or Starts With.
• Weight UOM Filter — Filter results by Weight UOM using operators Equals, Contains, or Starts With.
• Cury Specific MSRP Filter — Filter results by Cury Specific MSRP using numeric comparison operators.
• Cury Specific Price Filter — Filter results by Cury Specific Price using numeric comparison operators.
• Availability Filter — Filter results by Availability using operators Equals, Contains, or Starts With.
• Custom URL Filter — Filter results by Custom URL using operators Equals, Contains, or Starts With.
• Export To External Filter — Filter results by Export To External (boolean equals).
• Meta Description Filter — Filter results by Meta Description using operators Equals, Contains, or Starts With.
• Meta Keywords Filter — Filter results by Meta Keywords using operators Equals, Contains, or Starts With.
• Page Title Filter — Filter results by Page Title using operators Equals, Contains, or Starts With.
• Search Keywords Filter — Filter results by Search Keywords using operators Equals, Contains, or Starts With.
• Template Item ID Filter — Filter results by Template Item ID using operators Equals, Contains, or Starts With.
• Visibility Filter — Filter results by Visibility using operators Equals, Contains, or Starts With.
• Not Available Filter — Filter results by Not Available using operators Equals, Contains, or Starts With.
• Custom Filter — Apply a custom OData $filter string expression for advanced filtering (e.g., "OrderDate/value gt 2024-01-01T00:00:00").

Output shape

a list of Stock Item records matching the specified filters

You can combine multiple optional filter parameters to narrow down the returned Stock Items. The 'Custom Filter' parameter allows specifying any valid OData filter expression for advanced querying. The operation returns data in the structure provided by the Acumatica API endpoint for Stock Items.

Links

• n8n community nodes installation guide