Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a filtered list of Project Budget records from the Acumatica API applying multiple optional filter criteria.

Inputs

• Account Group Filter — Filter results by Account Group using operators like equals, contains, or starts with.
• Actual Amount Filter — Filter results by Actual Amount using comparison operators (equals, greater than, etc.).
• Actual Plus Open Committed Amount Filter — Filter results by Actual Plus Open Committed Amount using comparison operators.
• Actual Qty Filter — Filter results by Actual Quantity using comparison operators.
• Auto Completed Filter — Filter results by Auto Completed status (boolean, equals operator only).
• Budgeted CO Amount Filter — Filter results by Budgeted Change Order Amount using comparison operators.
• Budgeted CO Qty Filter — Filter results by Budgeted Change Order Quantity using comparison operators.
• Committed CO Amount Filter — Filter results by Committed Change Order Amount using comparison operators.
• Committed CO Qty Filter — Filter results by Committed Change Order Quantity using comparison operators.
• Committed Invoiced Amount Filter — Filter results by Committed Invoiced Amount using comparison operators.
• Committed Invoiced Qty Filter — Filter results by Committed Invoiced Quantity using comparison operators.
• Committed Open Amount Filter — Filter results by Committed Open Amount using comparison operators.
• Committed Open Qty Filter — Filter results by Committed Open Quantity using comparison operators.
• Committed Received Qty Filter — Filter results by Committed Received Quantity using comparison operators.
• Completed Filter — Filter results by Completed amount using comparison operators.
• Cost At Completion Filter — Filter results by Cost At Completion using comparison operators.
• Cost Code Filter — Filter results by Cost Code using operators like equals, contains, or starts with.
• Cost To Complete Filter — Filter results by Cost To Complete using comparison operators.
• Description Filter — Filter results by Description using operators like equals, contains, or starts with.
• Draft Invoices Amount Filter — Filter results by Draft Invoices Amount using comparison operators.
• Inventory ID Filter — Filter results by Inventory ID using operators like equals, contains, or starts with.
• Last Cost At Completion Filter — Filter results by Last Cost At Completion using comparison operators.
• Last Cost To Complete Filter — Filter results by Last Cost To Complete using comparison operators.
• Last Modified Date Time Filter — Filter results by Last Modified date/time using comparison operators such as equal, after, before, etc.
• Last Percentage Of Completion Filter — Filter results by Last Percentage Of Completion using comparison operators.
• Original Budgeted Amount Filter — Filter results by Original Budgeted Amount using comparison operators.
• Original Budgeted Qty Filter — Filter results by Original Budgeted Quantity using comparison operators.
• Original Committed Amount Filter — Filter results by Original Committed Amount using comparison operators.
• Original Committed Qty Filter — Filter results by Original Committed Quantity using comparison operators.
• Pending Invoice Amount Filter — Filter results by Pending Invoice Amount using comparison operators.
• Percentage Of Completion Filter — Filter results by Percentage Of Completion using comparison operators.
• Performance Filter — Filter results by Performance metric using comparison operators.
• Project ID Filter — Filter results by Project ID using operators like equals, contains, or starts with.
• Project Task ID Filter — Filter results by Project Task ID using operators like equals, contains, or starts with.
• Retainage Filter — Filter results by Retainage amount using comparison operators.
• Revenue Task Filter — Filter results by Revenue Task using comparison operators.
• Revised Budgeted Amount Filter — Filter results by Revised Budgeted Amount using comparison operators.
• Revised Budgeted Qty Filter — Filter results by Revised Budgeted Quantity using comparison operators.
• Revised Committed Amount Filter — Filter results by Revised Committed Amount using comparison operators.
• Revised Committed Qty Filter — Filter results by Revised Committed Quantity using comparison operators.
• Tax Category Filter — Filter results by Tax Category using operators like equals, contains, or starts with.
• Type Filter — Filter results by Type using operators like equals, contains, or starts with.
• Unit Rate Filter — Filter results by Unit Rate using comparison operators.
• UOM Filter — Filter results by Unit Of Measure using operators like equals, contains, or starts with.
• Variance Amount Filter — Filter results by Variance Amount using comparison operators.
• Custom Filter — Advanced OData $filter expression string applied in addition to any other filters to further refine results.

Output shape

a list of Project Budget records matching the filter criteria

The returned data is filtered using any combination of the provided filters plus the optional custom OData $filter string. If no filters are supplied, all Project Budget records are returned.

Links

• n8n community nodes installation guide