Acumatica API - Endpoint Default 24 200 001Install

Summary

Retrieve a list of Subcontract records from Acumatica, applying multiple optional filters to narrow down results based on various Subcontract fields.

Inputs

• Subcontract Nbr Filter — Filter by Subcontract Nbr using operators Equals, Contains, or Starts With.
• Status Filter — Filter by Status with operators Equals, Contains, or Starts With.
• Date Filter — Filter by Date field with operators Equals, After, On or After, Before, or On or Before.
• Start Date Filter — Filter by Start Date using date comparison operators.
• Description Filter — Filter by Description using text operators.
• Vendor ID Filter — Filter by Vendor ID using text operators.
• Location Filter — Filter by Location with text-based operators.
• Owner Filter — Filter by Owner using text filtering operators.
• Currency ID Filter — Filter by Currency ID with text operators.
• Base Currency ID Filter — Filter by Base Currency ID with text operators.
• Currency Effective Date Filter — Filter by Currency Effective Date using date comparison operators.
• Currency Rate Filter — Filter by Currency Rate with numeric comparison operators.
• Currency Rate Type ID Filter — Filter by Currency Rate Type ID using text operators.
• Currency Reciprocal Rate Filter — Filter by Currency Reciprocal Rate with numeric comparison operators.
• Vendor Ref Filter — Filter by Vendor Ref using text operators.
• Line Total Filter — Filter by Line Total with numeric comparison operators.
• Discount Total Filter — Filter by Discount Total using numeric operators.
• Retainage Total Filter — Filter by Retainage Total with numeric comparison operators.
• Subcontract Total Filter — Filter by Subcontract Total using numeric comparison operators.
• Tax Total Filter — Filter by Tax Total with numeric comparisons.
• Control Total Filter — Filter by Control Total using numeric operators.
• Branch Filter — Filter by Branch with text operators.
• Terms Filter — Filter by Terms using text operator options.
• Vendor Tax Zone Filter — Filter by Vendor Tax Zone with text operators.
• Apply Retainage Filter — Filter by boolean Apply Retainage, using Equals operator.
• Retainage Pct Filter — Filter by Retainage Pct with numeric comparison operators.
• Do Not Email Filter — Filter boolean Do Not Email using Equals operator.
• Do Not Print Filter — Filter boolean Do Not Print using Equals operator.
• Emailed Filter — Filter boolean Emailed using Equals operator.
• Printed Filter — Filter boolean Printed using Equals operator.
• Last Modified Date Time Filter — Filter by Last Modified Date Time using date comparisons.
• Custom Filter — Provide an advanced OData $filter expression string to apply alongside standard filters.

Output shape

a list of Subcontract records matching the specified filters

Returns matching Subcontract records as an array; multiple filters can be combined. The custom OData $filter string is applied in addition to other filters, enabling advanced querying. Pagination behavior is not specified.

Links

• n8n community nodes installation guide