(Excel) AWS Secrets Manager - Get Secret Value

See more AWS Secrets Manager Examples

Retrieves the contents of the encrypted fields SecretString or SecretBinary from the specified version of a secret, whichever contains content.

For more information, see https://docs.aws.amazon.com/secretsmanager/latest/apireference/API_GetSecretValue.html

Download Excel Class Modules Chilkat Excel Class Modules

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

' Sends the following sample request.
' Note: Chilkat will automatically add Content-Length, X-Amz-Date, Accept-Encoding, and Authorization

' POST / HTTP/1.1
' Host: secretsmanager.region.domain
' Accept-Encoding: identity
' X-Amz-Target: secretsmanager.GetSecretValue
' Content-Type: application/x-amz-json-1.1
' X-Amz-Date: <date>
' Authorization: AWS4-HMAC-SHA256 Credential=<credentials>,SignedHeaders=<headers>, Signature=<signature>
' Content-Length: <payload-size-bytes>
' 
' {
'   "SecretId": "MyTestDatabaseSecret",
' }

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to the Amazon AWS REST server.
' such as https://secretsmanager.us-west-2.amazonaws.com/

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("secretsmanager.us-west-2.amazonaws.com",port,bTls,bAutoReconnect)

' Provide AWS credentials for the REST call.
Dim authAws As Chilkat.AuthAws
Set authAws = Chilkat.NewAuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "AWS_SECRET_KEY"
' the region should match our URL above..
authAws.Region = "us-west-2"
authAws.ServiceName = "secretsmanager"

Dim success As Boolean
success = rest.SetAuthAws(authAws)

' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

success = json.UpdateString("SecretId","MyTestDatabaseSecret2")

success = rest.AddHeader("Content-Type","application/x-amz-json-1.1")
success = rest.AddHeader("X-Amz-Target","secretsmanager.GetSecretValue")

Dim sbRequestBody As Chilkat.StringBuilder
Set sbRequestBody = Chilkat.NewStringBuilder
success = json.EmitSb(sbRequestBody)
Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If


respStatusCode = rest.ResponseStatusCode
Debug.Print "response status code = "; respStatusCode

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
jResp.EmitCompact = False
success = jResp.LoadSb(sbResponseBody)

If (respStatusCode >= 400) Then
    Debug.Print "Response Status Code = "; respStatusCode
    Debug.Print "Response Header:"
    Debug.Print rest.ResponseHeader
    Debug.Print "Response Body:"
    Debug.Print jResp.Emit()
    Exit Sub
End If

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

' Sample response body:

' {
'   "ARN":"arn:aws:secretsmanager:us-west-2:123456789012:secret:MyTestDatabaseSecret-a1b2c3",
'   "CreatedDate":1.523477145713E9,
'   "Name":"MyTestDatabaseSecret",
'   "SecretString":"{\n  \"username\":\"david\",\n  \"password\":\"BnQw&XDWgaEeT9XGTT29\"\n}\n",
'   "VersionId":"EXAMPLE1-90ab-cdef-fedc-ba987SECRET1"
' }

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON


ARN = jResp.StringOf("ARN")

CreatedDate = jResp.StringOf("CreatedDate")

Name = jResp.StringOf("Name")

SecretString = jResp.StringOf("SecretString")

VersionId = jResp.StringOf("VersionId")