(Excel) Use an Azure Service SAS

Shows how to use an Azure Service SAS. (In this case, it is an SAS for a blob.)

Download Excel Class Modules Chilkat Excel Class Modules

' Azure Blob Service Example: Upload binary bytes to a block blob.
' This uses a Service SAS for Authorization.

' 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

' ----------------------------------------------------------------------------------------------
' The code above this comment could be placed inside a function/subroutine within the application
' because the connection does not need to be made for every request.  Once the connection is made
' the app may send many requests..
' ----------------------------------------------------------------------------------------------

' 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.

' Let's load a previously computed Azure Storage Account SAS token and use it.
' See How to Create an Azure Service SAS
Dim sbToken As Chilkat.StringBuilder
Set sbToken = Chilkat.NewStringBuilder
success = sbToken.LoadFile("qa_data/tokens/azureStorageServiceSas.txt","utf-8")
If (success <> True) Then
    Debug.Print "Failed to load SAS token."
    Exit Sub
End If

' Add the Shared Access Signature query params for authorization.
success = rest.AddQueryParams(sbToken.GetAsString())

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

' IMPORTANT: Make sure to add the x-ms-date header.
' When the header name is "x-ms-date", Chilkat will recognize the keyword "NOW" 
' and will substitute the current system date/time formatted as required by Microsoft.
success = rest.AddHeader("x-ms-date","NOW")

' For this example, we'll just load a JPG file into memory..
Dim binData As Chilkat.BinData
Set binData = Chilkat.NewBinData
success = binData.LoadFile("qa_data/jpg/starfish.jpg")
If (success <> True) Then
    Debug.Print "Failed to load JPG file."
    Exit Sub
End If

' 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..
Dim sbResponse As Chilkat.StringBuilder
Set sbResponse = Chilkat.NewStringBuilder
success = rest.FullRequestBd("PUT","/mycontainer/starfish.jpg",binData,sbResponse)
If (success <> 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): "; sbResponse.GetAsString()
    Debug.Print "---"
    Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
    Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
    Debug.Print "Failed."
    Exit Sub
End If

Debug.Print "Success."