Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Template Items from the Acumatica API filtered by various optional criteria.

Inputs

• Sales UOM Filter — Filter results by Sales Unit of Measure, supporting operators: Equals, Contains, Starts With.
• Cury Specific MSRP Filter — Filter results by Cury Specific Manufacturer's Suggested Retail Price with numeric comparison operators.
• Cury Specific Price Filter — Filter results by Cury Specific Price with numeric comparison operators.
• Item Class Filter — Filter results by Item Class, supporting operators: Equals, Contains, Starts With.
• Availability Filter — Filter results by Availability status, supporting operators: Equals, Contains, Starts With.
• Base UOM Filter — Filter results by Base Unit of Measure, supporting operators: Equals, Contains, Starts With.
• Content Filter — Filter results by Content, supporting operators: Equals, Contains, Starts With.
• Current Std Cost Filter — Filter results by Current Standard Cost with numeric comparison operators.
• Custom URL Filter — Filter results by Custom URL, supporting operators: Equals, Contains, Starts With.
• Default Issue Location ID Filter — Filter results by Default Issue Location ID, supporting operators: Equals, Contains, Starts With.
• Default Price Filter — Filter results by Default Price with numeric comparison operators.
• Description Filter — Filter results by Description, supporting operators: Equals, Contains, Starts With.
• Dimension Weight Filter — Filter results by Dimension Weight with numeric comparison operators.
• Export To External Filter — Filter results by Export To External flag (boolean).
• Inventory ID Filter — Filter results by Inventory ID, supporting operators: Equals, Contains, Starts With.
• Is Stock Item Filter — Filter results by whether the item is a stock item (boolean).
• Item Status Filter — Filter results by Item Status, supporting operators: Equals, Contains, Starts With.
• Last Modified Filter — Filter results by Last Modified date with date/time comparison operators.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time with date/time comparison operators.
• Meta Description Filter — Filter results by Meta Description, supporting operators: Equals, Contains, Starts With.
• MSRP Filter — Filter results by Manufacturer's Suggested Retail Price with numeric comparison operators.
• Page Title Filter — Filter results by Page Title, supporting operators: Equals, Contains, Starts With.
• Search Keywords Filter — Filter results by Search Keywords, supporting operators: Equals, Contains, Starts With.
• Tax Category Filter — Filter results by Tax Category, supporting operators: Equals, Contains, Starts With.
• Visibility Filter — Filter results by Visibility, supporting operators: Equals, Contains, Starts With.
• Weight UOM Filter — Filter results by Weight Unit of Measure, supporting operators: Equals, Contains, Starts With.
• Meta Keywords Filter — Filter results by Meta Keywords, supporting operators: Equals, Contains, Starts With.
• Require Shipment Filter — Filter results by Require Shipment flag (boolean).
• Not Available Filter — Filter results by Not Available status, supporting operators: Equals, Contains, Starts With.
• Custom Filter — Custom OData $filter string for advanced filtering (e.g., "CustomerID/value eq 'CUST001'"). Applied together with other filters.

Output shape

a list of Template Item records matching the provided filter criteria

Supports extensive filtering through individual field filters and an optional advanced OData $filter expression; all filters are combined in the request to the Acumatica API to return matching Template Items.

Examples

Example 1: Fetch Template Items with Inventory ID starting with 'ABC' and MSRP greater than 100.

Inventory ID Filter using 'Starts With' operator with value 'ABC'; MSRP Filter with 'Greater Than' operator and value 100.

Links

• n8n community nodes installation guide