Acumatica API - Endpoint Default 23 200 001 icon

Acumatica API - Endpoint Default 23 200 001

Interact with Acumatica Endpoint Default/23.200.001

Actions478

Project Transaction → Get List

AI-generated

Summary

Retrieve a list of Project Transaction records filtered by optional criteria.

Inputs

  • CreatedDateTimeFilter — Filter results by Created Date Time using an operator and value.
  • DescriptionFilter — Filter results by Description using an operator and value.
  • LastModifiedDateTimeFilter — Filter results by Last Modified Date Time using an operator and value.
  • ModuleFilter — Filter results by Module using an operator and value.
  • OriginalDocNbrFilter — Filter results by Original Doc Nbr using an operator and value.
  • OriginalDocTypeFilter — Filter results by Original Doc Type using an operator and value.
  • ReferenceNbrFilter — Filter results by Reference Nbr using an operator and value.
  • StatusFilter — Filter results by Status using an operator and value.
  • TotalAmountFilter — Filter results by Total Amount using an operator and numeric value.
  • TotalBillableQtyFilter — Filter results by Total Billable Qty using an operator and numeric value.
  • TotalQtyFilter — Filter results by Total Qty using an operator and numeric value.
  • customFilter — Advanced OData $filter expression applied in addition to other filters.

Output shape

a list of Project Transaction items

Pagination may be supported via n8n paging; each item includes fields defined by the Acumatica schema, but exact fields depend on the resource definition.

Examples

Example 1: Get all transactions created after a given date

CreatedDateTimeFilter: {"operator": "gt", "value": "2024-01-01T00:00:00"}

Example 2: Filter by status and custom OData expression

StatusFilter: {"operator": "eq", "value": "Open"} and customFilter: "Status eq 'Open' and CreatedDateTime ge 2024-01-01"

Example 3: Retrieve transactions with total amount greater than 1000

TotalAmountFilter: {"operator": "gt", "value": 1000}

Links

Discussion