Fetching Credentials

Method	Endpoint
GET	<base-url>/api/data-pe/v1/fetch-credentials

Example 5-1 JSON Format of Wallet and Credentials

{
  "wallets": {
    "certificateEndDate": 1746276157000, 
    "certificateStartDate": 1588596157000, 
    "comment": null,
    "lastRotationDate": 1624305815466,
    "schemas": {
      "MFCS_RDS_CUSTOM": "password1", 
      "CE_RDS_CUSTOM": "password2", 
      ...
      RDS_CUSTOM_2": "password3", 
      RDS_CUSTOM_3": "password3"
    }, 
    "wallet": {
      "README": "...base64-encoded-file...", 
      "cwallet.sso": "...base64-encoded-file...", 
      "ewallet.p12": "...base64-encoded-file...", 
      "keystore.jks": "...base64-encoded-file...",
      "ojdbc.properties": "...base64-encoded-file...", 
      "sqlnet.ora": "...base64-encoded-file...", 
      "tnsnames.ora": "...base64-encoded-file...", 
      "truststore.jks": "...base64-encoded-file..."
    },
    "walletName": "Wallet_RDSADWABC123", 
    "walletPassword": null
  }
}

Table 5-1 Serialized Wallet and Credential Format

Content	Purpose
wallets	map of wallet contents
walletName	Name of database wallet and instance, derived from tnsnames.ora within wallet
walletPassword	(Currently unused)
comment	(Currently unused)
certificateEndDate	Expiration date of wallet, derived from truststore certificate within wallet
certificateStartDate	Start date of wallet, derived from truststore certificate within wallet
lastRotationDate	Date of last rotation
schemas	Map of database credentials (username):(password)
wallet	Map of wallet file contents, (filename):(base64 encoded file)