Acumatica API - Endpoint Default 24 200 001 icon

Acumatica API - Endpoint Default 24 200 001

Interact with Acumatica Endpoint Default/24.200.001

Actions478

Project Transaction → Get List

AI-generated

Summary

Retrieve a filtered list of Project Transactions from the Acumatica API using various optional filters.

Inputs

  • Created Date Time Filter — Filter results by Created Date Time using operators: Equals, After, On or After, Before, On or Before.
  • Description Filter — Filter results by Description using operators: Equals, Contains, Starts With.
  • Last Modified Date Time Filter — Filter results by Last Modified Date Time with operators as for Created Date Time.
  • Module Filter — Filter results by Module using operators: Equals, Contains, Starts With.
  • Original Doc Nbr Filter — Filter results by Original Document Number with operators: Equals, Contains, Starts With.
  • Original Doc Type Filter — Filter results by Original Document Type using operators: Equals, Contains, Starts With.
  • Reference Nbr Filter — Filter results by Reference Number with operators: Equals, Contains, Starts With.
  • Status Filter — Filter results by Status using operators: Equals, Contains, Starts With.
  • Total Amount Filter — Filter results by Total Amount using numeric comparison operators: Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal.
  • Total Billable Qty Filter — Filter results by Total Billable Quantity with numeric comparison operators as for Total Amount.
  • Total Qty Filter — Filter results by Total Quantity using numeric comparison operators as above.
  • Custom Filter — Advanced custom OData $filter expression to apply additional filtering beyond the preset filters.

Output shape

a list of Project Transaction records

Returns an array of objects matching the applied filters. If no filters are set, returns all Project Transactions. Supports standard OData filtering syntax via the custom filter for complex queries.

Examples

Example 1: Fetch all Project Transactions created on or after January 1, 2024 with status containing 'Open'

Set Created Date Time Filter with operator 'On or After' and value '2024-01-01T00:00:00', set Status Filter with operator 'Contains' and value 'Open'.

Links

Discussion