Fetching Credentials

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

Returns the wallet and credentials for the schemas exposed by the Database Private Endpoint. Credentials are serialized into JSON and, within that payload, Oracle Wallet file contents are base64 encoded. The JSON format of the response is shown in "JSON Format of Wallet and Credentials".

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)