Gets the account variance facts. Run in API Explorer

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 string

    possible values : Current or 0 - Current period for filtered engagement(s), LastThree or 1(Default option) - Last three periods for filtered engagement(s), LastThirteen or 13 - Last thirteen periods for filtered engagement(s), LastTwentyFive or 25 - Last twenty five periods for filtered engagement(s), All or 99

  • engagement string

    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
  • 404 application/json

    Not Found

  • 400 application/json

    Bad Request

  • 500 application/json

    Internal Server Error

GET /api/AccountVarianceFacts
curl \
 --request GET 'https://analyticsapi.adra.com/balancer/api/AccountVarianceFacts' \
 --user "username:password"
Response examples (200)
[
  {
    "IsActive": true,
    "Account_Id": 23536,
    "Period_Key": 123,
    "Account_Key": 9768,
    "Explanation": null,
    "Materiality": 2,
    "DocumentedBy": null,
    "VarianceType": 2,
    "DocumentedDate": "2022-12-05T06:50:44.992Z",
    "Engagement_Key": 9876,
    "VarianceAmount": 1.34,
    "LegalEntity_Key": 3423,
    "MaterialityText": null,
    "VariancePercent": "1.23",
    "VarianceTypeText": "Month Over Month",
    "CurrentPeriod_Key": 435,
    "ComparedPeriod_Key": 4532,
    "VarianceSetting_Key": 231,
    "CurrentPeriodBalance": 0.23,
    "ComparedPeriodBalance": 0.11,
    "AccountPeriodVariance_Key": 1324
  }
]