Acumatica API - Endpoint Default 25 200 001Install

Summary

Retrieve a filtered list of Expense Claim records from Acumatica's API using various optional filters to narrow down results based on fields like dates, amounts, IDs, statuses, and custom OData expressions.

Inputs

• Approval Date Filter — Filter results by Approval Date using operators like equals, after, on or after, before, or on or before a specific datetime.
• Base Currency ID Filter — Filter results by Base Currency ID with operators such as equals, contains, or starts with a specified string.
• Claimed By Filter — Filter results by the Claimed By field using operators equals, contains, or starts with a specified string.
• Claim Total Filter — Filter results by Claim Total amount using numeric comparisons (equals, greater than, less than, etc.).
• Currency ID Filter — Filter by Currency ID value with string operators equals, contains, or starts with.
• Currency Rate Filter — Filter results by Currency Rate number using comparisons like equals, greater than, less than, etc.
• Customer ID Filter — Filter results by Customer ID string using equals, contains, or starts with operators.
• Date Filter — Filter results by Date using datetime comparisons (equals, after, on or after, before, or on or before).
• Department ID Filter — Filter by Department ID string using equals, contains, or starts with operators.
• Description Filter — Filter results by Description text string using equals, contains, or starts with.
• Last Modified Date Time Filter — Filter by last modification timestamp using datetime operators like equals, after, on or after, before, or on or before.
• Location ID Filter — Filter results by Location ID string using equals, contains, or starts with.
• Reciprocal Rate Filter — Filter by Reciprocal Rate number using numeric comparisons (equals, greater than, less than, etc.).
• Ref Nbr Filter — Filter by Reference Number string using operators equals, contains, or starts with.
• Status Filter — Filter results by Status string using operators equals, contains, or starts with.
• Tax Total Filter — Filter results by Tax Total amount using numeric comparisons such as equals, greater than, or less than.
• VAT Exempt Total Filter — Filter by VAT Exempt Total numeric value with standard numeric comparison operators.
• VAT Taxable Total Filter — Filter by VAT Taxable Total numeric amount using operators like equals, greater than, or less than.
• Custom Filter — Provide an advanced OData $filter expression string to apply complex filtering beyond the standard fields.

Output shape

a list of Expense Claim records matching the provided filter criteria

Supports complex filtering via multiple field-specific filters combined with an optional custom OData filter expression. Returns all matching records without explicit pagination described.

Links

• n8n community nodes installation guide