(Visual FoxPro) Azure Key Vault Find Certificate

See more Azure Key Vault Examples

Let's say you have the certificate locally, but not with the private key. You only have the certificate, such as in a .cer file, but not the .pfx. The purpose of this example is to show how to find the same certificate in Azure Key Vault, and return the Azure Key Vault's name for the certificate.

Note: This example requires Chilkat v9.5.0.96 or later.

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

LOCAL loCert
LOCAL lnSuccess
LOCAL loBdThumbprint
LOCAL lcSeek_x5t
LOCAL loJson
LOCAL loHttp
LOCAL loSbResponse
LOCAL lnStatusCode
LOCAL loJsonResp
LOCAL loJsonRec
LOCAL loSbId
LOCAL lcCertName

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

* We have a .cer file locally, and we want to find this same certificate in Azure Key Vault
* because we'll need Azure Key Vault's name (and version) for the certificate if we are going to ask
* Key Vault to sign using the cert's private key.

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Cert')
loCert = CreateObject('Chilkat.Cert')
lnSuccess = loCert.LoadFromFile("qa_data/certs/myCert.cer")
IF (lnSuccess = 0) THEN
    ? loCert.LastErrorText
    RELEASE loCert
    CANCEL
ENDIF

* Let's the the SHA1 thumbprint for our cert in base64url format.  This is the "x5t" member that we'll 
* be seeking in the list of certificates returned from Azure Key Vault.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.BinData')
loBdThumbprint = CreateObject('Chilkat.BinData')
loBdThumbprint.AppendEncoded(loCert.Sha1Thumbprint,"hex")
lcSeek_x5t = loBdThumbprint.GetEncoded("base64url")
? "Seeking the cert with x5t = " + lcSeek_x5t

* Provide information needed for Chilkat to automatically get an OAuth2 access token as needed.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("client_id","APP_ID")
loJson.UpdateString("client_secret","APP_PASSWORD")
loJson.UpdateString("resource","https://vault.azure.net")
loJson.UpdateString("token_endpoint","https://login.microsoftonline.com/TENANT_ID/oauth2/token")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

* Instead of providing an actual access token, we give Chilkat the information that allows it to 
* automatically fetch the access token using the OAuth2 client credentials flow.
loHttp.AuthToken = loJson.Emit()

* Download JSON containing information about the certs in the Azure Key Vault.
* Replace VAULT_NAME with the name of your Azure Key Vault.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbResponse = CreateObject('Chilkat.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://VAULT_NAME.vault.azure.net/certificates?api-version=7.4",loSbResponse)
IF (lnSuccess = 0) THEN

    lnStatusCode = loHttp.LastStatus
    IF (lnStatusCode = 0) THEN
        * We did not get a response from the server..
        ? loHttp.LastErrorText
    ELSE
        * We received a response, but it was an error.
        ? "Error response status code: " + STR(lnStatusCode)
        ? "Error response:"
        ? loSbResponse.GetAsString()
    ENDIF

    RELEASE loCert
    RELEASE loBdThumbprint
    RELEASE loJson
    RELEASE loHttp
    RELEASE loSbResponse
    CANCEL
ENDIF

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

* The JSON will contain an array of certs like this:

* {
*   "value": [
*     {
*       "id": "https://kvchilkat.vault.azure.net/certificates/BadSSL",
*       "x5t": "U04xLnb8Ww7BKkW9dD7P1cCHNDY",
*       "attributes": {
*         "enabled": true,
*         "nbf": 1674409014,
*         "exp": 1737481014,
*         "created": 1697294224,
*         "updated": 1697294224
*       },
*       "subject": ""
*     },
* ...
* ...

* Find the record having an "x5t" value equal to the one we're seeking.
loJsonRec = loJsonResp.FindRecord("value","x5t",lcSeek_x5t,1)
IF (loJsonResp.LastMethodSuccess = 0) THEN
    ? "Did not find a matching certificate."
ELSE
    ? "Found the matching certificate."
    * The id is a value such as https://kvchilkat.vault.azure.net/certificates/BadSSL
    ? "id: " + loJsonRec.StringOf("id")

    * The name of the certificate is the last word after the final "/", such as "BadSSL"
    * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
    loSbId = CreateObject('Chilkat.StringBuilder')
    loSbId.Append(loJsonRec.StringOf("id"))
    lcCertName = loSbId.GetAfterFinal("/",0)
    ? "name: " + lcCertName

    RELEASE loJsonRec
ENDIF

RELEASE loJsonResp

RELEASE loCert
RELEASE loBdThumbprint
RELEASE loJson
RELEASE loHttp
RELEASE loSbResponse
RELEASE loJsonResp
RELEASE loSbId