VBScript

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.

VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

' 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
set bootstrap = CreateObject("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.
set bsId = CreateObject("Chilkat.JsonObject")
success = bsId.UpdateString("appName","oracle_bs")
success = bsId.UpdateString("service","Example")
success = bsId.UpdateString("username","Joe")

' ----------------------------------------------------
set secrets = CreateObject("Chilkat.Secrets")

' Setup for the Oracle Cloud Secrets
secrets.Location = "oracle_cloud"
success = secrets.SetBootstrapSecret(bsId,bootstrap)
If (success = 0) Then
    outFile.WriteLine(secrets.LastErrorText)
    WScript.Quit
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.
set jsonMatch = CreateObject("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")

set results = CreateObject("Chilkat.JsonObject")
results.EmitCompact = 0

success = secrets.ListSecrets(jsonMatch,results)
If (success = 0) Then
    outFile.WriteLine(secrets.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine(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
numSecrets = results.SizeOfArray("secrets")
Do 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
Loop

outFile.Close