Gets the account variance facts. Run in API Explorer

Add MCP server to your AI tool

Allow AI tools and LLMs to interact with the API documentation portal through MCP.

MCP server URL

https://developer.adra.com/doc/analytics-balancer/mcp

Standard setup for AI tools providing an mcp.json file

mcp.json
{
  "Analytics Balancer MCP server": {
    "url": "https://developer.adra.com/doc/analytics-balancer/mcp"
  }
}

Close
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

    Success

    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
    Hide response attributes Show response attributes object
    • accountPeriodVariance_Key integer(int32) Required
    • engagement_Key integer(int32) Required
    • legalEntity_Key null | integer(int32)
    • account_Key null | integer(int32)
    • period_Key integer(int32) Required
    • fiscalYearPeriod_Key integer(int32) Required
    • varianceSetting_Key null | integer(int32)
    • currentPeriod_Key null | integer(int32)
    • comparedPeriod_Key null | integer(int32)
    • account_Id null | integer(int32)
    • engagementGuid string(uuid) Required
    • varianceType null | integer(int32)
    • varianceTypeText null | string
    • currentPeriodBalance null | number(double)
    • comparedPeriodBalance null | number(double)
    • varianceAmount null | number(double)
    • variancePercent null | string
    • materiality null | integer(int32)
    • materialityText null | string
    • explanation null | string
    • documentedDate null | string(date-time)
    • volatility null | integer(int32)
    • volatilityText null | string
    • varianceImpact null | integer(int32)
    • varianceImpactText null | string
    • keyDrivers null | string
    • documentedBy null | string
    • isActive null | boolean
  • 400

    Bad Request

  • 404

    Not Found

  • 500

    Server Error

GET /api/AccountVarianceFacts
curl \
 --request GET 'https://analyticsapi.adra.com/balancer/api/AccountVarianceFacts' \
 --user "username:password"
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "AccountPeriodVariance_Key": 1324,
    "Engagement_Key": 9876,
    "LegalEntity_Key": 3423,
    "Account_Key": 9768,
    "Period_Key": 123,
    "VarianceSetting_Key": 231,
    "CurrentPeriod_Key": 435,
    "ComparedPeriod_Key": 4532,
    "Account_Id": 23536,
    "VarianceType": 2,
    "VarianceTypeText": "Month Over Month",
    "CurrentPeriodBalance": 0.23,
    "ComparedPeriodBalance": 0.11,
    "VarianceAmount": 1.34,
    "VariancePercent": "1.23",
    "Materiality": 2,
    "MaterialityText": null,
    "Explanation": null,
    "DocumentedDate": "2022-12-05T06:50:44.992Z",
    "DocumentedBy": null,
    "IsActive": true
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]
Response examples (200)
[
  {
    "accountPeriodVariance_Key": 42,
    "engagement_Key": 42,
    "legalEntity_Key": null,
    "account_Key": null,
    "period_Key": 42,
    "fiscalYearPeriod_Key": 42,
    "varianceSetting_Key": null,
    "currentPeriod_Key": null,
    "comparedPeriod_Key": null,
    "account_Id": null,
    "engagementGuid": "string",
    "varianceType": null,
    "varianceTypeText": null,
    "currentPeriodBalance": null,
    "comparedPeriodBalance": null,
    "varianceAmount": null,
    "variancePercent": null,
    "materiality": null,
    "materialityText": null,
    "explanation": null,
    "documentedDate": null,
    "volatility": null,
    "volatilityText": null,
    "varianceImpact": null,
    "varianceImpactText": null,
    "keyDrivers": null,
    "documentedBy": null,
    "isActive": null
  }
]