(Excel) Azure Storage: Upload Contents of String Variable to Block Blob

Sample code to upload the contents of a string variable to a block blob in Azure Cloud Storage. This creates the block blob, or replaces an existing block blob.

Note: The maximum size of a block blob created by uploading in a single step is 64MB. For larger files, the upload must be broken up into blocks. There is another Chilkat example for that..

Download Excel Class Modules Chilkat Excel Class Modules

' Azure Blob Service Example: Upload the contents of a string variable to a block blob.
' This creates a new block blob or replaces an existing one in its entirety.
' See also: https://msdn.microsoft.com/en-us/library/azure/dd179451.aspx

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

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

' Connect to the Azure Storage Blob Service

bTls = True

port = 443

bAutoReconnect = True
' In this example, the storage account name is "chilkat".

success = rest.Connect("chilkat.blob.core.windows.net",port,bTls,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Provide Azure Cloud credentials for the REST call.
Dim azAuth As Chilkat.AuthAzureStorage
Set azAuth = Chilkat.NewAuthAzureStorage
azAuth.AccessKey = "AZURE_ACCESS_KEY"
' The account name used here should match the 1st part of the domain passed in the call to Connect (above).
azAuth.Account = "chilkat"
azAuth.Scheme = "SharedKey"
azAuth.Service = "Blob"
' This causes the "x-ms-version: 2020-08-04" header to be automatically added.
azAuth.XMsVersion = "2020-08-04"
success = rest.SetAuthAzureStorage(azAuth)

' Note: The application does not need to explicitly set the following
' headers: Content-Length, x-ms-date, Authorization.  These headers
' are automatically set by Chilkat.

' IMPORTANT: Make sure to set the x-ms-blob-type header:
success = rest.AddHeader("x-ms-blob-type","BlockBlob")

' After uploading, the block blob named helloWorld.txt (in the container named "mycontainer")
' will contain the following string:

blobContents = "Hello World!"

' Note: The maximum size of a block blob created by uploading in a single step is 64MB.  
' For larger files, the upload must be broken up into blocks.  There is another Chilkat example for that..

responseStr = rest.FullRequestString("PUT","/mycontainer/helloWorld.txt",blobContents)
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' When successful, the Azure Storage service will respond with a 201 response status code,
' with no response body.

If (rest.ResponseStatusCode <> 201) Then
    ' Examine the request/response to see what happened.
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body (if any): "; responseStr
    Debug.Print "---"
    Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
    Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
    Exit Sub
End If

Debug.Print "Success."