Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a list of Purchase Orders from Acumatica filtered by various criteria.

Inputs

• Base Currency ID Filter — Filter results by Base Currency ID with operator options: Equals, Contains, Starts With.
• Branch Filter — Filter results by Branch with operator options: Equals, Contains, Starts With.
• Control Total Filter — Filter results by Control Total with operator options: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Currency ID Filter — Filter results by Currency ID with operator options: Equals, Contains, Starts With.
• Currency Effective Date Filter — Filter results by Currency Effective Date with operator options: Equals, After, On or After, Before, On or Before.
• Currency Rate Filter — Filter results by Currency Rate with operator options: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Currency Rate Type ID Filter — Filter results by Currency Rate Type ID with operator options: Equals, Contains, Starts With.
• Currency Reciprocal Rate Filter — Filter results by Currency Reciprocal Rate with operator options: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Date Filter — Filter results by Date with operator options: Equals, After, On or After, Before, On or Before.
• Description Filter — Filter results by Description with operator options: Equals, Contains, Starts With.
• Hold Filter — Filter results by Hold status (boolean) with operator Equals.
• Is Tax Valid Filter — Filter results by tax validity (boolean) with operator Equals.
• Last Modified Date Time Filter — Filter results by Last Modified Date Time with operator options: Equals, After, On or After, Before, On or Before.
• Line Total Filter — Filter results by Line Total with operator options: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Location Filter — Filter results by Location with operator options: Equals, Contains, Starts With.
• Order Nbr Filter — Filter results by Order Number with operator options: Equals, Contains, Starts With.
• Order Total Filter — Filter results by Order Total with operator options: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Owner Filter — Filter results by Owner with operator options: Equals, Contains, Starts With.
• Project Filter — Filter results by Project with operator options: Equals, Contains, Starts With.
• Promised On Filter — Filter results by Promised On date with operator options: Equals, After, On or After, Before, On or Before.
• Status Filter — Filter results by Status with operator options: Equals, Contains, Starts With.
• Tax Total Filter — Filter results by Tax Total with operator options: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
• Terms Filter — Filter results by Terms with operator options: Equals, Contains, Starts With.
• Type Filter — Filter results by Type with operator options: Equals, Contains, Starts With.
• Vendor ID Filter — Filter results by Vendor ID with operator options: Equals, Contains, Starts With.
• Vendor Ref Filter — Filter results by Vendor Reference with operator options: Equals, Contains, Starts With.
• Vendor Tax Zone Filter — Filter results by Vendor Tax Zone with operator options: Equals, Contains, Starts With.
• Custom Filter — Advanced OData $filter expression to refine the query with a custom filter string.

Output shape

a list of Purchase Order records matching the specified filters

Filters are combined and translated into an OData $filter query string sent to the Acumatica API. The result is an array of Purchase Order objects; pagination and result limits depend on Acumatica API defaults and are not configurable via this operation parameters.

Links

• n8n community nodes installation guide