(Excel) Create S3 Pre-Signed URL for Upload

Demonstrates how to generate a pre-signed URL for S3 uploads.

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.

' Note: This example requires Chilkat v9.5.0.83 or greater.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.AwsAccessKey = "AWS_ACCESS_KEY"
http.AwsSecretKey = "AWS_SECRET_KEY"

' Make sure to set your AWS region correctly
http.AwsRegion = "us-east-1"


bucketName = "chilkat200"

objectName = "starfish/starfish.jpg"

awsService = "s3"

httpVerb = "PUT"

' The signed URL will be valid for this number of seconds:

numSecondsValid = 86400

' Choose between a URL beginning with "http://" or "https://"...

bUseHttps = False

' Generate the pre-signed URL

preSignedUrl = http.S3_GenPresignedUrl(httpVerb,bUseHttps,bucketName,objectName,numSecondsValid,awsService)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' The following URL can be copy-and-pasted into a browser..
Debug.Print "Presigned URL for Upload: "; preSignedUrl

' Here's an example of a pre-signed URL
' 
' http://chilkat200.s3.amazonaws.com/starfish/starfish.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIBJLOVZVXAU2AFUA%2F20200623%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20200623T234049Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&X-Amz-Signature=xxxxxeaea071178d772856c0a4e4c0114a8d9992f0d0812955e490d0exxxxxxx
' 

' We can also use the pre-signed URL to upload from Chilkat
' For example, upload by streaming from a local file

Set resp = http.PFile("PUT",preSignedUrl,"qa_data/jpg/starfish.jpg","image/jpg",False,False)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "response status code = "; resp.StatusCode
Debug.Print "response body size: "; resp.ContentLength
If (resp.ContentLength > 0) Then
    Debug.Print "response body:"
    Debug.Print resp.BodyStr
End If