(Visual FoxPro) 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

LOCAL loBootstrap
LOCAL loBsId
LOCAL loSecrets
LOCAL lnSuccess
LOCAL loJsonMatch
LOCAL loResults
LOCAL lcAppName
LOCAL lcService
LOCAL lcDomain
LOCAL lcUsername
LOCAL lcOracleName
LOCAL i
LOCAL lnNumSecrets

* 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
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Secrets')
loBootstrap = 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.
* ---------------------------------------------------------------------------------------------
loBootstrap.Location = "local_manager"

* Specify the bootstrap secret to be used.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loBsId = CreateObject('Chilkat.JsonObject')
loBsId.UpdateString("appName","oracle_bs")
loBsId.UpdateString("service","Example")
loBsId.UpdateString("username","Joe")

* ----------------------------------------------------
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Secrets')
loSecrets = CreateObject('Chilkat.Secrets')

* Setup for the Oracle Cloud Secrets
loSecrets.Location = "oracle_cloud"
lnSuccess = loSecrets.SetBootstrapSecret(loBsId,loBootstrap)
IF (lnSuccess = 0) THEN
    ? loSecrets.LastErrorText
    RELEASE loBootstrap
    RELEASE loBsId
    RELEASE loSecrets
    CANCEL
ENDIF

* 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.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonMatch = CreateObject('Chilkat.JsonObject')
loJsonMatch.UpdateString("appName","Test*")
* The following lines can be omitted. Not specifying anything for service, domain, or username is the same as "*".
loJsonMatch.UpdateString("service","*")
loJsonMatch.UpdateString("domain","*")
loJsonMatch.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?"
loJsonMatch.UpdateString("vault_name","ocid1.vault.oc1.us-chicago-1.ijttzlz7aadxo.abxxeljt4gv6tgrar66i5ugffincjmp52oveht3y2zn74rgo6raz6h72qtia")
loJsonMatch.UpdateString("region","us-chicago-1")
loJsonMatch.UpdateString("tenancy_ocid","ocid1.tenancy.oc1..aaaaaaaaov6vd3xdybgvwblezx2kmgjmo3dvsuljbwpf2m27mk47kkxsa5aa")
loJsonMatch.UpdateString("user_ocid","ocid1.user.oc1..aaaaaaaarsn42gwcl5rvahcmt5r6aheek65z54k5nbd6gtclmqn6emkqxajq")
loJsonMatch.UpdateString("master_key_ocid","ocid1.key.oc1.us-chicago-1.ijttzlz7aadxo.abxyeljtfbqhl5h2velmojmm6ls77lskmc7ardpekjgw264my6fuyxmhm6xa")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loResults = CreateObject('Chilkat.JsonObject')
loResults.EmitCompact = 0

lnSuccess = loSecrets.ListSecrets(loJsonMatch,loResults)
IF (lnSuccess = 0) THEN
    ? loSecrets.LastErrorText
    RELEASE loBootstrap
    RELEASE loBsId
    RELEASE loSecrets
    RELEASE loJsonMatch
    RELEASE loResults
    CANCEL
ENDIF

? loResults.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
lnNumSecrets = loResults.SizeOfArray("secrets")
DO WHILE i < lnNumSecrets
    loResults.I = i
    * Note: appName and domain are optional and may not exist in any given secret.
    lcAppName = loResults.StringOf("secrets[i].appName")
    lcService = loResults.StringOf("secrets[i].service")
    lcDomain = loResults.StringOf("secrets[i].domain")
    lcUsername = loResults.StringOf("secrets[i].username")
    * Informational field for the raw Oracle secret name.
    lcOracleName = loResults.StringOf("secrets[i].oracleName")
    i = i + 1
ENDDO

RELEASE loBootstrap
RELEASE loBsId
RELEASE loSecrets
RELEASE loJsonMatch
RELEASE loResults