Get Account Variance Facts

GET /api/AccountVarianceFacts

This request should be used to retrieve account variance information comparing balances between periods for the specified engagement(s). The data contained here will be similar to what can be seen in Balancer under the Variance Analysis 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
- accountPeriodVariance_Key integer(int32)
- engagement_Key integer(int32)
- legalEntity_Key integer(int32) | null
- account_Key integer(int32) | null
- period_Key integer(int32)
- varianceSetting_Key integer(int32) | null
- currentPeriod_Key integer(int32) | null
- comparedPeriod_Key integer(int32) | null
- account_Id integer(int32) | null
- engagementGuid string(uuid)
- varianceType integer(int32) | null
- varianceTypeText string | null
- currentPeriodBalance number(double) | null
- comparedPeriodBalance number(double) | null
- varianceAmount number(double) | null
- variancePercent string | null
- materiality integer(int32) | null
- materialityText string | null
- explanation string | null
- documentedDate string(date-time) | null
- documentedBy string | null
- isActive boolean | null
400

Bad Request
404

Not Found
500

Server Error

GET /api/AccountVarianceFacts

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

Response examples (200)

[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": 42,
    "account_Key": 42,
    "period_Key": 42,
    "varianceSetting_Key": 42,
    "currentPeriod_Key": 42,
    "comparedPeriod_Key": 42,
    "account_Id": 42,
    "engagementGuid": "string",
    "varianceType": 42,
    "varianceTypeText": "string",
    "currentPeriodBalance": 42.0,
    "comparedPeriodBalance": 42.0,
    "varianceAmount": 42.0,
    "variancePercent": "string",
    "materiality": 42,
    "materialityText": "string",
    "explanation": "string",
    "documentedDate": "2025-05-04T09:42:00+00:00",
    "documentedBy": "string",
    "isActive": true
  }
]