(Excel) Glacier Get Inventory Retrieval Job Output

Demonstrates how to get and parse the inventory retrieval job output.

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.

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

' Connect to the Amazon AWS REST server in the desired region.

bTls = True

port = 443

bAutoReconnect = True

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

' Provide AWS credentials.
Dim authAws As Chilkat.AuthAws
Set authAws = Chilkat.NewAuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "AWS_SECRET_KEY"
authAws.ServiceName = "glacier"
authAws.Region = "us-west-2"

success = rest.SetAuthAws(authAws)

' --------------------------------------------------------------------------
' Note: The above REST connection and setup of the AWS credentials
' can be done once.  After connecting, any number of REST calls can be made.
' The "auto reconnect" property passed to rest.Connect indicates that if
' the connection is lost, a REST method call will automatically reconnect
' if needed.
' --------------------------------------------------------------------------

' 
' For more information, see Glacier Retrieve Job Output Reference Documentation
' 
success = rest.AddHeader("x-amz-glacier-version","2012-06-01")

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/AWS_ACCOUNT_ID/vaults/chilkat/jobs/JOB_ID/output",sbResponseBody)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If


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

' Success is indicated by a 200 response status.
Debug.Print "response status code = "; respStatusCode

' The inventory retrieval job output is in CSV format.
Debug.Print "job output:"
Debug.Print sbResponseBody.GetAsString()
Debug.Print "--"

' The CSV has these fields:  ArchiveId,ArchiveDescription,CreationDate,Size,SHA256TreeHash
' Parse the CSV like this...
Dim csv As Chilkat.Csv
Set csv = Chilkat.NewCsv
csv.HasColumnNames = True
success = csv.LoadFromString(sbResponseBody.GetAsString())


i = 0

numRows = csv.NumRows
Do While i < numRows
    Debug.Print "ArchiveId: "; csv.GetCellByName(i,"ArchiveId")
    Debug.Print "Description: "; csv.GetCellByName(i,"ArchiveDescription")
    Debug.Print "Size: "; csv.GetCellByName(i,"Size")
    Debug.Print "-"
    i = i + 1
Loop