Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a filtered list of Item Warehouse records from the Acumatica API using various optional filter criteria.

Inputs

• Created Date Time Filter — Filter results by creation date and time using operators like Equals, After, On or After, Before, On or Before.
• Default Issue From Filter — Filter results by the Default Issue From field using operators Equals, Contains, or Starts With.
• Default Receipt To Filter — Filter results by the Default Receipt To field using operators Equals, Contains, or Starts With.
• Default Subitem Filter — Filter results by the Default Subitem field 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.
• Last Modified Date Time Filter — Filter results by last modified date and time using operators like Equals, After, On or After, Before, On or Before.
• Max Qty Filter — Filter results by Max Quantity using numeric comparison operators such as Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• MSRP Filter — Filter results by MSRP with numeric comparison operators: Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Override Inventory Account Subaccount Filter — Filter by boolean Override Inventory Account Subaccount with 'Equals' operator.
• Override Preferred Vendor Filter — Filter by boolean Override Preferred Vendor with 'Equals' operator.
• Override Price Filter — Filter by boolean Override Price with 'Equals' operator.
• Override Replenishment Settings Filter — Filter by boolean Override Replenishment Settings with 'Equals' operator.
• Override Service Level Filter — Filter by boolean Override Service Level with 'Equals' operator.
• Override Standard Cost Filter — Filter by boolean Override Standard Cost with 'Equals' operator.
• Override Product Manager Filter — Filter by boolean Override Product Manager with 'Equals' operator.
• Override Max Qty Filter — Filter by boolean Override Max Quantity with 'Equals' operator.
• Override Reorder Point Filter — Filter by boolean Override Reorder Point with 'Equals' operator.
• Override Safety Stock Filter — Filter by boolean Override Safety Stock with 'Equals' operator.
• Preferred Location Filter — Filter results by Preferred Location using operators Equals, Contains, or Starts With.
• Preferred Vendor Filter — Filter results by Preferred Vendor 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.
• Reorder Point Filter — Filter results by Reorder Point with numeric comparison operators: Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Replenishment Class Filter — Filter results by Replenishment Class using operators Equals, Contains, or Starts With.
• Replenishment Method Filter — Filter results by Replenishment Method using operators Equals, Contains, or Starts With.
• Replenishment Source Filter — Filter results by Replenishment Source using operators Equals, Contains, or Starts With.
• Replenishment Warehouse Filter — Filter results by Replenishment Warehouse using operators Equals, Contains, or Starts With.
• Safety Stock Filter — Filter results by Safety Stock using numeric comparison operators: Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Seasonality Filter — Filter results by Seasonality using operators Equals, Contains, or Starts With.
• Service Level Filter — Filter results by Service Level with numeric comparison operators: Equals, Greater Than, Greater Than or Equal, Less Than, or Less Than or Equal.
• Status Filter — Filter results by Status using operators Equals, Contains, or Starts With.
• Warehouse ID Filter — Filter results by Warehouse ID using operators Equals, Contains, or Starts With.
• Custom Filter — Provide an advanced OData $filter string to apply additional custom filtering criteria, which is applied in conjunction with the other filters.

Output shape

a list of Item Warehouse records matching the applied filters, returned as JSON objects

Filters are combined to form an OData $filter query string for the Acumatica API; unsupported or empty filters are ignored. The operation returns all matching records without pagination within a single execution.

Links

• n8n community nodes installation guide