Xojo Plugin

Oracle Cloud Secrets - List Matching Secrets

See more Secrets Examples

List secrets in the Oracle Cloud Secrets matching one or more wildcarded names for app, service, domain, and username.

Note: This example requires Chilkat v10.1.0 or later.

Xojo Plugin

Dim success As Boolean
success = False

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

// The bootstrap secret will contain the following information:

// Private Key PEM

// See following examples for setting up a bootstrap secret in memory, 
// or in the local manager (Windows Credentials Manager or Apple Keychain)
// Setup Bootstrap Secret in Local Manager
// Setup Bootstrap Secret in Memory
Dim bootstrap As New Chilkat.Secrets

// Set the location of the bootstrap secret.
// Can be "local_manager" or "memory", depending on how you setup the bootstrap secret.
// ---------------------------------------------------------------------------------------------
// If your operating system is NOT Windows or MacOS/iOS, then change "local_manager" to "memory"
// You can also, if desired, use "memory" on Windows and MacOS/iOS if your bootstrap secret was previously setup in memory.
// ---------------------------------------------------------------------------------------------
bootstrap.Location = "local_manager"

// Specify the bootstrap secret to be used.
Dim bsId As New Chilkat.JsonObject
success = bsId.UpdateString("appName","oracle_bs")
success = bsId.UpdateString("service","Example")
success = bsId.UpdateString("username","Joe")

// ----------------------------------------------------
Dim secrets As New Chilkat.Secrets

// Setup for the Oracle Cloud Secrets
secrets.Location = "oracle_cloud"
success = secrets.SetBootstrapSecret(bsId,bootstrap)
If (success = False) Then
    System.DebugLog(secrets.LastErrorText)
    Return
End If

// Set wildcarded or exact values for appName, service, domain, and username.
// Omit any members where anything is allowed to match, or alternatively specify "*" to match anything.
Dim jsonMatch As New Chilkat.JsonObject
success = jsonMatch.UpdateString("appName","Test*")
// The following lines can be omitted. Not specifying anything for service, domain, or username is the same as "*".
success = jsonMatch.UpdateString("service","*")
success = jsonMatch.UpdateString("domain","*")
success = jsonMatch.UpdateString("username","*")

// Oracle Cloud Secrets requires a lot of additional information for each API call.
// You'll need to replace the following with your values.
// Note: To learn how to find these values, go to an AI such as ChatGPT and ask (for example) "In Oracle Cloud, where do I find my master key OCID?"
success = jsonMatch.UpdateString("vault_name","ocid1.vault.oc1.us-chicago-1.ijttzlz7aadxo.abxxeljt4gv6tgrar66i5ugffincjmp52oveht3y2zn74rgo6raz6h72qtia")
success = jsonMatch.UpdateString("region","us-chicago-1")
success = jsonMatch.UpdateString("tenancy_ocid","ocid1.tenancy.oc1..aaaaaaaaov6vd3xdybgvwblezx2kmgjmo3dvsuljbwpf2m27mk47kkxsa5aa")
success = jsonMatch.UpdateString("user_ocid","ocid1.user.oc1..aaaaaaaarsn42gwcl5rvahcmt5r6aheek65z54k5nbd6gtclmqn6emkqxajq")
success = jsonMatch.UpdateString("master_key_ocid","ocid1.key.oc1.us-chicago-1.ijttzlz7aadxo.abxyeljtfbqhl5h2velmojmm6ls77lskmc7ardpekjgw264my6fuyxmhm6xa")

Dim results As New Chilkat.JsonObject
results.EmitCompact = False

success = secrets.ListSecrets(jsonMatch,results)
If (success = False) Then
    System.DebugLog(secrets.LastErrorText)
    Return
End If

System.DebugLog(results.Emit())

// Sample output:

// {
//   "secrets": [
//     {
//       "appName": "Test2",
//       "service": "Custom",
//       "domain": "Ocean",
//       "username": "Starfish",
//       "oracleName": "Test2-Custom-Ocean-Starfish"
//     },
//     {
//       "appName": "Test",
//       "service": "Something",
//       "domain": "Xyz",
//       "username": "Abc",
//       "oracleName": "Test-Something-Xyz-Abc"
//     }
//   ]
// }

// ---------------------------------------------------------------------------------------
// Here's sample code for parsing the JSON list of secrets.

Dim appName As String
Dim service As String
Dim domain As String
Dim username As String
Dim oracleName As String

Dim i As Int32
i = 0
Dim numSecrets As Int32
numSecrets = results.SizeOfArray("secrets")
While i < numSecrets
    results.I = i
    // Note: appName and domain are optional and may not exist in any given secret.
    appName = results.StringOf("secrets[i].appName")
    service = results.StringOf("secrets[i].service")
    domain = results.StringOf("secrets[i].domain")
    username = results.StringOf("secrets[i].username")
    // Informational field for the raw Oracle secret name.
    oracleName = results.StringOf("secrets[i].oracleName")
    i = i + 1
Wend