Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a filtered list of Template Items from the Acumatica API endpoint, allowing precise filtering on multiple Template Item fields using various operators.

Inputs

• Sales UOM Filter — Filter results by Sales Unit of Measure using operators like equals, contains, or starts with.
• Cury Specific MSRP Filter — Filter results by currency-specific MSRP using numeric comparison operators (equals, greater than, less than, etc.).
• Cury Specific Price Filter — Filter results by currency-specific price using numeric comparison operators.
• Item Class Filter — Filter results by Item Class with string operators (equals, contains, starts with).
• Availability Filter — Filter results by Availability using string operators.
• Base UOM Filter — Filter results by Base Unit of Measure using string operators.
• Content Filter — Filter results by Content with string comparison operators.
• Current Std Cost Filter — Filter results by current standard cost using numeric comparison operators.
• Custom URL Filter — Filter results by Custom URL using string comparison operators.
• Default Issue Location ID Filter — Filter results by Default Issue Location ID with string comparison operators.
• Default Price Filter — Filter results by Default Price using numeric operators.
• Description Filter — Filter results by Description using string comparison operators.
• Dimension Weight Filter — Filter results by Dimension Weight using numeric operators.
• Export To External Filter — Filter results by Export To External flag (boolean, equals operator).
• Inventory ID Filter — Filter results by Inventory ID using string operators.
• Is Stock Item Filter — Filter results by whether item is stock item (boolean, equals operator).
• Item Status Filter — Filter results by Item Status using string operators.
• Last Modified Filter — Filter results by Last Modified date using date/time comparison operators.
• Last Modified Date Time Filter — Filter results by Last Modified date and time using date/time comparison operators.
• Meta Description Filter — Filter results by Meta Description using string operators.
• MSRP Filter — Filter results by MSRP using numeric comparison operators.
• Page Title Filter — Filter results by Page Title using string operators.
• Search Keywords Filter — Filter results by Search Keywords using string operators.
• Tax Category Filter — Filter results by Tax Category using string operators.
• Visibility Filter — Filter results by Visibility using string comparison operators.
• Weight UOM Filter — Filter results by Weight Unit of Measure using string operators.
• Meta Keywords Filter — Filter results by Meta Keywords using string operators.
• Require Shipment Filter — Filter results by whether shipment is required (boolean, equals operator).
• Not Available Filter — Filter results by Not Available using string operators.
• Custom Filter — Provide an advanced OData $filter expression to apply custom filtering beyond the predefined filters.

Output shape

A list of Template Item records matching the specified filters retrieved from the Acumatica API.

Supports combining multiple filter criteria using the provided filter fields and an optional advanced OData $filter expression string. Returns all matching records as a list when executed.

Examples

Example 1: Fetch all Template Items where Inventory ID starts with 'ABC' and MSRP is greater than 100.

Set the Inventory ID Filter operator to 'Starts With' and value to 'ABC', set the MSRP Filter operator to 'Greater Than' and value to 100.

Links

• n8n community nodes installation guide