Acumatica API - Endpoint Default 23 200 001 icon

Acumatica API - Endpoint Default 23 200 001

Interact with Acumatica Endpoint Default/23.200.001

Actions478

Vendor Price Worksheet → Get List

AI-generated

Summary

Retrieve a list of vendor price worksheets from Acumatica with flexible filtering options.

Inputs

  • CreatedDateTimeFilter — Filter by Created Date Time using an operator (e.g., Equals, After) and a date value.
  • DescriptionFilter — Filter by Description using an operator (e.g., Equals, Contains, Starts With) and a text value.
  • EffectiveDateFilter — Filter by Effective Date using an operator (e.g., Equals, On or After) and a date value.
  • ExpirationDateFilter — Filter by Expiration Date using an operator (e.g., Equals, On or Before) and a date value.
  • HoldFilter — Filter by Hold status using Equals (true/false).
  • LastModifiedDateTimeFilter — Filter by Last Modified Date Time using an operator (e.g., Equals, Before) and a date value.
  • OverwriteOverlappingPricesFilter — Filter by Overwrite Overlapping Prices status using Equals (true/false).
  • PromotionalFilter — Filter by Promotional status using Equals (true/false).
  • ReferenceNbrFilter — Filter by Reference Nbr using an operator (e.g., Equals, Contains, Starts With) and a text value.
  • StatusFilter — Filter by Status using an operator (e.g., Equals, Contains, Starts With) and a text value.
  • customFilter — Advanced OData $filter expression (e.g., CustomerID/value eq 'CUST001') applied in addition to any filter fields above.

Output shape

a list of items, each containing the worksheet data (fields vary by resource schema).

The node generates INodeProperties dynamically based on the resource schema. Results include standard Acumatica fields (e.g., ID, rowNumber) and resource-specific fields (e.g., description, effectiveDate, vendorID).

Examples

Example 1: Retrieve all active vendor price worksheets.

Set HoldFilter to 'Equals' and 'true', StatusFilter to 'Equals' and 'Active'.

Example 2: Find worksheets expiring within the next 30 days.

Set ExpirationDateFilter to 'On or Before' and the current date + 30 days.

Example 3: Search for worksheets containing specific text in the description.

Set DescriptionFilter to 'Contains' and the search text (e.g., 'Discount').

Links

Discussion