(Excel) Azure Storage: Get Blob Service Stats

Azure Storage Blob Service REST API: Sample code to get Blob Service Stats

Download Excel Class Modules Chilkat Excel Class Modules

' Azure Blob Service Example: Get Blob Service Stats

' 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".
' ---- IMPORTANT ----
' The "-secondary" suffix is required.
' This requires an Azure storage account with replication set to "Read-access geo-redundant storage (RA-GRS)"
' If you made the change just prior to testing this example, you'll need to give it time for the 
' DNS to become available..  
' ---- IMPORTANT ----

success = rest.Connect("chilkat-secondary.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: x-ms-date, Authorization.  These headers
' are automatically set by Chilkat.


responseStr = rest.FullRequestNoBody("GET","/?restype=service&comp=stats")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' When successful, the Azure Storage service will respond with a 200 response code,
' with an XML body.  
If (rest.ResponseStatusCode <> 200) 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

' Load the XML response for parsing.
' An example of the response XML is shown below.
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(responseStr)

Debug.Print xml.GetXml()

' Use the ChilkatPath method to get various pieces of information out
' of the XML.  For example:

Debug.Print "Status = "; xml.ChilkatPath("GeoReplication|Status|*")

lastSyncTimeStr = xml.ChilkatPath("GeoReplication|LastSyncTime|*")
Debug.Print "LastSyncTime = "; lastSyncTimeStr

' The date/time string can be loaded into a CkDateTime object for 
' access to individual parts, or conversion to other formats.
Dim dateTime As Chilkat.CkDateTime
Set dateTime = Chilkat.NewCkDateTime
success = dateTime.SetFromRfc822(lastSyncTimeStr)

' For example:

bLocalTime = True

Set dt = dateTime.GetDtObj(bLocalTime)
Debug.Print dt.Year; "/"; dt.Month; "/"; dt.Day

' <StorageServiceStats>
'     <GeoReplication>
'         <Status>live</Status>
'         <LastSyncTime>Tue, 03 May 2016 23:57:54 GMT</LastSyncTime>
'     </GeoReplication>
' </StorageServiceStats>