(PowerBuilder) 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.

For more information, see https://cknotes.com/chilkat-secrets-class-added-in-version-10-1-0/

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Bootstrap
oleobject loo_BsId
oleobject loo_Secrets
integer li_Success
oleobject loo_JsonMatch
oleobject loo_Results
string ls_AppName
string ls_Service
string ls_Domain
string ls_Username
string ls_OracleName
integer i
integer li_NumSecrets

// 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
loo_Bootstrap = create oleobject
// Use "Chilkat_9_5_0.Secrets" for versions of Chilkat < 10.0.0
li_rc = loo_Bootstrap.ConnectToNewObject("Chilkat.Secrets")
if li_rc < 0 then
    destroy loo_Bootstrap
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// 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.
// ---------------------------------------------------------------------------------------------
loo_Bootstrap.Location = "local_manager"

// Specify the bootstrap secret to be used.
loo_BsId = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_BsId.ConnectToNewObject("Chilkat.JsonObject")

loo_BsId.UpdateString("appName","oracle_bs")
loo_BsId.UpdateString("service","Example")
loo_BsId.UpdateString("username","Joe")

// ----------------------------------------------------
loo_Secrets = create oleobject
// Use "Chilkat_9_5_0.Secrets" for versions of Chilkat < 10.0.0
li_rc = loo_Secrets.ConnectToNewObject("Chilkat.Secrets")

// Setup for the Oracle Cloud Secrets
loo_Secrets.Location = "oracle_cloud"
li_Success = loo_Secrets.SetBootstrapSecret(loo_BsId,loo_Bootstrap)
if li_Success = 0 then
    Write-Debug loo_Secrets.LastErrorText
    destroy loo_Bootstrap
    destroy loo_BsId
    destroy loo_Secrets
    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.
loo_JsonMatch = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JsonMatch.ConnectToNewObject("Chilkat.JsonObject")

loo_JsonMatch.UpdateString("appName","Test*")
// The following lines can be omitted. Not specifying anything for service, domain, or username is the same as "*".
loo_JsonMatch.UpdateString("service","*")
loo_JsonMatch.UpdateString("domain","*")
loo_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?"
loo_JsonMatch.UpdateString("vault_name","ocid1.vault.oc1.us-chicago-1.ijttzlz7aadxo.abxxeljt4gv6tgrar66i5ugffincjmp52oveht3y2zn74rgo6raz6h72qtia")
loo_JsonMatch.UpdateString("region","us-chicago-1")
loo_JsonMatch.UpdateString("tenancy_ocid","ocid1.tenancy.oc1..aaaaaaaaov6vd3xdybgvwblezx2kmgjmo3dvsuljbwpf2m27mk47kkxsa5aa")
loo_JsonMatch.UpdateString("user_ocid","ocid1.user.oc1..aaaaaaaarsn42gwcl5rvahcmt5r6aheek65z54k5nbd6gtclmqn6emkqxajq")
loo_JsonMatch.UpdateString("master_key_ocid","ocid1.key.oc1.us-chicago-1.ijttzlz7aadxo.abxyeljtfbqhl5h2velmojmm6ls77lskmc7ardpekjgw264my6fuyxmhm6xa")

loo_Results = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Results.ConnectToNewObject("Chilkat.JsonObject")

loo_Results.EmitCompact = 0

li_Success = loo_Secrets.ListSecrets(loo_JsonMatch,loo_Results)
if li_Success = 0 then
    Write-Debug loo_Secrets.LastErrorText
    destroy loo_Bootstrap
    destroy loo_BsId
    destroy loo_Secrets
    destroy loo_JsonMatch
    destroy loo_Results
    return
end if

Write-Debug loo_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.

i = 0
li_NumSecrets = loo_Results.SizeOfArray("secrets")
do while i < li_NumSecrets
    loo_Results.I = i
    // Note: appName and domain are optional and may not exist in any given secret.
    ls_AppName = loo_Results.StringOf("secrets[i].appName")
    ls_Service = loo_Results.StringOf("secrets[i].service")
    ls_Domain = loo_Results.StringOf("secrets[i].domain")
    ls_Username = loo_Results.StringOf("secrets[i].username")
    // Informational field for the raw Oracle secret name.
    ls_OracleName = loo_Results.StringOf("secrets[i].oracleName")
    i = i + 1
loop


destroy loo_Bootstrap
destroy loo_BsId
destroy loo_Secrets
destroy loo_JsonMatch
destroy loo_Results