APIServiceAccount Table

Stores a collection of external API service accounts.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for APIServiceAccount table

Database Column

Details

APIServiceAccountID

Type: integer. Key. Generated ID

Unique identifier for a API service account.

ComplianceOperatorID

Type: integer. Key. Nullable

Reference to a compliance operator.

AccessThreshold

Type: integer. Nullable

API access alert threshold

AccessCount

Type: integer

API access count.

LastSync

Type: datetime. Nullable

Indicates the last datetime this account is synced with FNOOD or validateToken API is called.

Description

Type: text (max 256 characters). Nullable

Description for this service account.

CreationUser

Type: text (max 256 characters). Nullable

Created by.

CreationDate

Type: datetime. Nullable

Creation date.

UpdatedUser

Type: text (max 256 characters). Nullable

Operator who made the latest change to the currency record.

UpdatedDate

Type: datetime. Nullable

Updated date