ApplicationCredential Table
The ApplicationCredential table maintains secure, reusable credential information used for authenticating against external systems such as Salesforce or database connections. It supports different connection and credential types with flexible formats.
The following table describes each field in the ApplicationCredential table:
| Column Name | Data Type | Required | Description |
|---|---|---|---|
| name | varchar | Yes | A unique identifier to describe the stored credentials. |
| connectionType | varchar | Yes | The type of connection associated with the credentials, i.e. Salesforce, Database |
| credentialType | varchar | Yes | The type of credentials that are stored, i.e, OAuth, Username and Password |
| loginHost | varchar | No | An optional host endpoint utilized by the credentials for Salesforce connections. |
| credentials | clob | Yes | The actual credentials being stored. Format of this field is dependent on the connectionType and credentialType. |
| isactive | boolean | Yes | True if the credentials can be utilized, otherwise false. |
| createdDate | datetime | Yes | The date and time when the record was created. |
| modifiedDate | datetime | Yes | The date and time when the record was last modified. |
| lastModifiedBy | varchar | Yes | The user who last modified the record. |
| createdBy | varchar | Yes | The user who created the record. |