Specifications

JSON PATHDESCRIPTIONEXAMPLEFormatRequired
file_date_and_timeUTC Date transmitted by CLOWD9. Format: YYYY-MM-DD hhmmss2023-01-20 102234stringYes
total_number_of_accountsDetails how many Accounts are included in the report2stringYes
accounts
idThe Identifier of the Account59731c30-babb-4572-acbf-5a05267f3197UUIDYes
program_idThe Program the Account is associated withb33bf1dc-30f4-498f-b7ad-3e23b7f0180eUUIDYes
product_idThe Product the Account is associated withab1e3e2-32cc-4e8f-96af-50fc158a4bd5UUIDYes
client_idThe Identifier of the Client the Account is associated with7d4d6327-0829-4ebd-8b5e-2e679b1d5014UUIDYes
currencyThe 3 Alpha currency codeGBPstringYes
currency_codeThe 3 digit Numeric currency code826stringYes
opening_account_positionintegerYes
actual_balanceThe opening Actual Balance.
A minus figure indicates a debit balance
1000000integerYes
available_balanceThe opening Available Balance.
A minus figure indicates a debit balance
1000000integerYes
authorizedTotal of Authorized spend5000integerYes
closing_account_position
actual_balanceThe Actual Balance at time of the report.
A minus figure indicates a debit balance
1000000integerYes
available_balanceThe Available Balance at time of the report.
A minus figure indicates a debit balance
9989001000000integerYes
authorizedThe total amount of any Authorized spend6100integerYes