Account Services Query Service
Account Services
>
API Reference
>
v1
>
Account Services Query Service
Overview
Our Query service is used to interface with our Data Warehousing solution, to build reports on data within the Account Services domain.
openapi: 3.0.3
info:
title: Account Services APIs - Account Services Query Service
version: v1
description: APIs for Account Services
contact:
name: Digital Core @ Jack Henry and Associates, inc.
url: https://www.jackhenry.com/
email: DC-Operations@jackhenry.com
servers:
- url: https://{API_ENDPOINT}
variables:
API_ENDPOINT:
default: digital.garden-fi.com
security:
- bearerAuth: []
tags:
- name: Account Services Query Service
description: V1 APIs for generating Report Data from Account Services Data Broker
paths:
/a/api/acct-svcs/v1/{InstitutionUniversalId}/trial-balance:
get:
operationId: GetTrialBalance
tags:
- Account Services Query Service
summary: API to get trial balance report for a specific Institution
description: API to get trial balance report for a specific Institution
parameters:
- name: InstitutionUniversalId
in: path
description: A unique identifier to establish the identity of an Institution/Environment/Brand combination
required: true
schema:
type: string
- name: RunDate
in: query
required: false
description: Results will be returned as if the query for balances was run on the date provided. Defaults to the current UTC time.
schema:
type: string
format: date
nullable: true
responses:
'200':
description: Success
content:
application/json:
schema:
type: object
properties:
accounts:
type: array
items:
type: object
properties:
accountNumber:
type: string
accountStatus:
type: string
description: This enum attribute defines the account status.
enum:
- new
- active
- inactive
- restricted
- no_debits
- no_credits
- dormant
- escheat
- pending_close
- closed
- charged_off
branchId:
type: string
format: uuid
cycleDay:
type: integer
format: int32
currentBalance:
type: string
format: decimal
lastActivityDate:
type: string
format: date-time
nullable: true
accruedInterestNotPaid:
type: string
format: decimal
lastDepositDate:
type: string
format: date-time
nullable: true
lastDepositAmount:
type: string
format: decimal
nullable: true
statusTotals:
type: array
items:
type: object
properties:
accountStatus:
type: string
description: This enum attribute defines the account status.
enum:
- new
- active
- inactive
- restricted
- no_debits
- no_credits
- dormant
- escheat
- pending_close
- closed
- charged_off
totalAccounts:
type: integer
format: int32
positiveBalances:
type: string
format: decimal
negativeBalances:
type: string
format: decimal
accruedInterestNotPaid:
type: string
format: decimal
dailyAccruedInterest:
type: string
format: decimal
institutionTotals:
type: object
properties:
totalAccounts:
type: integer
format: int32
totalPositiveBalances:
type: string
format: decimal
totalNegativeBalances:
type: string
format: decimal
totalAccruedInterestNotPaid:
type: string
format: decimal
totalDailyAccruedInterest:
type: string
format: decimal
productTotals:
type: array
items:
type: object
properties:
productId:
type: string
format: uuid
productDescriptionInternal:
type: string
productDescriptionExternal:
type: string
totalAccounts:
type: integer
format: int32
positiveBalances:
type: string
format: decimal
negativeBalances:
type: string
format: decimal
accruedInterestNotPaid:
type: string
format: decimal
'400':
description: The server could not process the request due to an invalid request.
content:
application/problem+json:
schema:
type: object
required:
- type
- title
- details
properties:
type:
description: A string path which uniquely classifies the domain of the error.
type: string
nullable: false
example: jackhenry/operation-failed
title:
description: A end-user readable string title of the error type.
nullable: false
type: string
details:
description: An array of end-user readable strings which provide additional details for the error message.
type: array
nullable: false
items:
type: string
fieldDetails:
type: array
description: An array of objects which provide additional details to specific fields in the request that caused the error.
items:
type: object
properties:
field:
type: string
description: The name or path of the field in the request that caused the error.
detail:
type: string
description: A end-user readable message describing the error related to the field.
data:
type: object
description: |
Additional data that could be useful to a developer or for handing the error programmatically. The schema for the data in this object is intentionally left undefined.
nullable: true
examples:
badRequest:
summary: Bad request
value:
type: acct-svcs/bad-request
title: Rule violation
details:
- exampleField is invalid or malformed.
fieldDetails:
- field: exampleField
detail: Provide a valid value for this field.
'401':
description: Although the HTTP standard specifies "unauthorized", semantically this response means "unauthenticated". That is, the client must authenticate itself to get the requested response.
'403':
description: The client does not have access rights to the content; that is, it is unauthorized, so the server is refusing to give the requested resource. Unlike 401, the clients identity is known to the server.
'404':
description: The server can not find the requested resource. In an API, this can also mean that the endpoint is valid but the resource itself does not exist. Servers may also send this response instead of 403 to hide the existence of a resource from an unauthorized client.
'500':
description: An unexpected internal server error occurred while processing the request.
content:
application/problem+json:
schema:
type: object
required:
- type
- title
- details
properties:
type:
description: A string path which uniquely classifies the domain of the error.
type: string
nullable: false
example: jackhenry/operation-failed
title:
description: A end-user readable string title of the error type.
nullable: false
type: string
details:
description: An array of end-user readable strings which provide additional details for the error message.
type: array
nullable: false
items:
type: string
data:
type: object
description: |
Additional data that could be useful to a developer or for handing the error programmatically. The schema for the data in this object is intentionally left undefined.
nullable: true
examples:
internalServerError:
summary: Internal server error
value:
type: acct-svcs/internal-server-error
title: Unexpected error
details:
- An unexpected error occurred. Please contact your service provider and/or try again later.
Did this page help you?
Why was this page helpful?
Why wasn't this page helpful?
Thank you for your feedback!
Last updated Fri Jan 23 2026