Gets the account facts. Run in API Explorer
This request should be used to retrieve account fact data including balances, status, and assigned users for the specified period and engagement(s). The data contained here will be similar to what can be seen in Balancer under Accounts and Status.
Query parameters
-
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
-
Short Guid of desired engagement Ex - ESXmkya-nEeWMX-7_3fSxA or Guid of desired engagement Ex - 45c31339-96d0-4262-b051-c00f392685c1
GET
/api/AccountFacts
curl \
--request GET 'https://analyticsapi.adra.com/balancer/api/AccountFacts' \
--user "username:password"
Response examples (200)
[
{
"Balance": 81833.09,
"BalanceAbs": 81833.09,
"Period_Key": 14631,
"Account_Key": 1000011,
"IsFinalized": "False",
"NoOfRejects": 1,
"ApprovedDate": null,
"ApproverName": null,
"ExtraField01": null,
"ExtraField02": null,
"ExtraField03": null,
"ExtraField04": null,
"ExtraField05": null,
"ExtraField06": null,
"ExtraField07": null,
"ExtraField08": null,
"ExtraField09": null,
"ExtraField10": null,
"PreparedDate": null,
"PreparerName": null,
"RejectedDate": "2015-11-09T14:34:34.543Z",
"ReviewedDate": null,
"ReviewerName": null,
"AccountStatus": "Approved",
"NoOfApprovers": 1,
"NoOfDocuments": 0,
"NoOfPreparers": 1,
"NoOfReviewers": 1,
"ReviewComment": null,
"StatusComment": "l.ll",
"AccountPurpose": "Purpose of account text.",
"ApprovedByName": null,
"AssignedToName": "Peter",
"Engagement_Key": 4316,
"PreparedByName": null,
"ReviewedByName": null,
"LegalEntity_Key": 7854,
"AccountProcedure": "Account reconciliation procedure text.",
"ApproverUsername": null,
"IsCarriedForward": "False",
"PreparerUsername": null,
"ReviewerUsername": null,
"BalanceEngagement": 81833.09,
"ApprovedByUsername": null,
"AssignedToUsername": "peter@westbank.com",
"BalanceUpdatedDate": "2022-12-05T05:35:43.287Z",
"BalancerAccountUrl": "https://balancer.adra.com/accountperiods/1000011",
"PreparedByUsername": null,
"ReviewedByUsername": null,
"AccountStatusReason": "Other",
"UnidentifiedBalance": 0.01,
"AccountPeriodBalance": 0.34,
"AccountStatusPartial": "Approved",
"BalanceEngagementAbs": 81833.09,
"FiscalYearPeriod_Key": 256857,
"AccountStatusComments": null,
"AccountCreatedInPeriod": "2015-05-05T13:04:45.332Z",
"UnIdentifiedBalanceAbs": 0.01,
"AccountStatusReasonText": null,
"AccountPeriodComment_Key": 294137,
"AccountPeriodTransaction_Key": 294137,
"UnidentifiedBalanceEngagement": 0.01,
"UnIdentifiedBalanceEngagementAbs": 0.01
}
]