Get Transaction Facts

GET /api/TransactionFacts

This request should be used to retrieve transaction details including amounts, dates, who added the item, when it was added as well as the status for the specified transaction and account in the fiscal period for the selected engagement(s). This would be information that is found on the transactions on a given account under the Accounts and Status tab.

Query parameters

period

possible values : Current or 0 - Current period for filtered engagement(s), LastThree or 1 - Last three period for filtered engagement(s), All or 99(Default option)
engagement

Short Guid of desired engagement Ex - ESXmkya-nEeWMX-7_3fSxA or Guid of desired engagement Ex - 45c31339-96d0-4262-b051-c00f392685c1

Responses

200 application/json

Success
Hide response attributes Show response attributes object
- engagement_Key integer(int32)
- legalEntity_Key integer(int32)
- transaction_Key integer(int32)
- period_Key integer(int32)
- account_Key integer(int32)
- itemAddedByUsername string | null
- itemAddedByName string | null
- transactionType string | null
- transactionStatus string | null
- accountStatus string | null
- accountIsFinalized string | null
- accountIsCarriedForward string | null
- itemCreatedDate string(date-time)
- accountBalance number(double)
- accountUnidentifiedBalance number(double)
- accountBalanceEngagement number(double)
- accountUnidentifiedBalanceEngagement number(double)
- boookingDate string(date-time)
- referenceOverJournalNumber string | null
- text string | null
- amount number(double)
- amountABS number(double)
- currencyRate number(double)
- transactionAmount number(double)
- currency integer(int32)
- currencyName string | null
- countOfAttachments integer(int32)
- ageDays integer(int32)
- ageGroup string | null
- accountPeriodTransaction_Key integer(int32) | null
- engagementGuid string(uuid)
400

Bad Request
404

Not Found
500

Server Error

GET /api/TransactionFacts

curl \
 -X GET https://analyticsapi.adra.com/balancer/api/TransactionFacts

Response examples (200)

[
  {
    "engagement_Key": 42,
    "legalEntity_Key": 42,
    "transaction_Key": 42,
    "period_Key": 42,
    "account_Key": 42,
    "itemAddedByUsername": "string",
    "itemAddedByName": "string",
    "transactionType": "string",
    "transactionStatus": "string",
    "accountStatus": "string",
    "accountIsFinalized": "string",
    "accountIsCarriedForward": "string",
    "itemCreatedDate": "2025-05-04T09:42:00+00:00",
    "accountBalance": 42.0,
    "accountUnidentifiedBalance": 42.0,
    "accountBalanceEngagement": 42.0,
    "accountUnidentifiedBalanceEngagement": 42.0,
    "boookingDate": "2025-05-04T09:42:00+00:00",
    "referenceOverJournalNumber": "string",
    "text": "string",
    "amount": 42.0,
    "amountABS": 42.0,
    "currencyRate": 42.0,
    "transactionAmount": 42.0,
    "currency": 42,
    "currencyName": "string",
    "countOfAttachments": 42,
    "ageDays": 42,
    "ageGroup": "string",
    "accountPeriodTransaction_Key": 42,
    "engagementGuid": "string"
  }
]