Acumatica API - Endpoint Default 25 200 001 icon

Acumatica API - Endpoint Default 25 200 001

Interact with Acumatica Endpoint Default/25.200.001

Actions478

Project Transaction → Get List

AI-generated

Summary

Retrieve a list of Project Transactions from the Acumatica API, applying optional filters to narrow down results.

Inputs

  • Created Date Time Filter — Filter Project Transactions by their Created Date Time using operators like equals, after, on or after, before, or on or before.
  • Description Filter — Filter results by the Description field using operators equals, contains, or starts with.
  • Last Modified Date Time Filter — Filter results by the Last Modified Date Time with operators equals, after, on or after, before, or on or before.
  • Module Filter — Filter by Module field using equals, contains, or starts with.
  • Original Doc Nbr Filter — Filter by Original Document Number with operators equals, contains, or starts with.
  • Original Doc Type Filter — Filter by Original Document Type with operators equals, contains, or starts with.
  • Reference Nbr Filter — Filter by Reference Number using equals, contains, or starts with.
  • Status Filter — Filter by Status with operators equals, contains, or starts with.
  • Total Amount Filter — Filter by Total Amount using numeric comparison operators equals, greater than, greater than or equal, less than, or less than or equal.
  • Total Billable Qty Filter — Filter by Total Billable Quantity with numeric operators equals, greater than, greater than or equal, less than, or less than or equal.
  • Total Qty Filter — Filter by Total Quantity using operators equals, greater than, greater than or equal, less than, or less than or equal.
  • Custom Filter — Provide an advanced custom OData $filter expression (e.g., "CustomerID/value eq 'CUST001'") to apply additional filtering criteria.

Output shape

a list of Project Transaction records

Returns an array of Project Transaction items matching the specified filters. If no filters are applied, returns all available Project Transactions. Supports standard pagination or limits as per Acumatica API defaults (not explicitly detailed in the properties or source). Errors may be returned if filters are malformed or the query exceeds API limits.

Examples

Example 1: Retrieve all Project Transactions created on or after 2024-01-01

Set 'Created Date Time Filter' operator to 'On or After' and value to '2024-01-01T00:00:00'.

Example 2: Retrieve Project Transactions where Description contains 'maintenance'

Set 'Description Filter' operator to 'Contains' and value to 'maintenance'.

Example 3: Retrieve Project Transactions with Total Amount greater than 1000

Set 'Total Amount Filter' operator to 'Greater Than' and value to 1000.

Links

Discussion