Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

Excel Examples

Web API Categories

ASN.1
Amazon EC2
Amazon Glacier
Amazon S3
Amazon S3 (new)
Amazon SES
Amazon SNS
Amazon SQS
Azure Cloud Storage
Azure Service Bus
Azure Table Service
Base64
Bounced Email
Box
CAdES
CSR
CSV
Certificates
Compression
DKIM / DomainKey
DSA
Diffie-Hellman
Digital Signatures
Dropbox
Dynamics CRM
EBICS
ECC
Ed25519
Email Object
Encryption
FTP
FileAccess
Firebase
GMail REST API
GMail SMTP/IMAP/POP
Geolocation
Google APIs
Google Calendar
Google Cloud SQL
Google Cloud Storage
Google Drive
Google Photos
Google Sheets
Google Tasks
Gzip
HTML-to-XML/Text
HTTP

HTTP Misc
IMAP
JSON
JSON Web Encryption (JWE)
JSON Web Signatures (JWS)
JSON Web Token (JWT)
Java KeyStore (JKS)
MHT / HTML Email
MIME
MS Storage Providers
Microsoft Graph
NTLM
OAuth1
OAuth2
OIDC
Office365
OneDrive
OpenSSL
Outlook
Outlook Calendar
Outlook Contact
PDF Signatures
PEM
PFX/P12
PKCS11
POP3
PRNG
REST
REST Misc
RSA
SCP
SCard
SFTP
SMTP
SSH
SSH Key
SSH Tunnel
ScMinidriver
SharePoint
Socket/SSL/TLS
Spider
Stream
Tar Archive
Upload
WebSocket
XAdES
XML
XML Digital Signatures
XMP
Zip
curl

 

 

 

(Excel) Upload File in Blocks (with Content-MD5 header) and Commit the Block List

Demonstrates how to upload a file in blocks and then commit the block list. This example includes a Content-MD5 header for each block.

Download Excel Class Modules

Chilkat Excel Class Modules

' Azure Blob Service Example: Upload a file in blocks, and then commit the block list.
' See also: https://msdn.microsoft.com/en-us/library/azure/dd135726.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.

' As the blocks are uploaded, we'll keep an XML block list for the subsequent commit..
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
xml.Tag = "BlockList"

' Any type of file can be uploaded in this way.  It can a text file, binary file, anything...
' This example will upload an XML file that is approximately 275K in size.  It can be downloaded
' at http://www.chilkatsoft.com/hamlet.xml
Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess
success = fac.OpenForRead("qa_data/xml/hamlet.xml")
' Assuming success for the example..

' We'll upload in 16K blocks (normally a program would upload in larger block sizes than this,
' but this is just an example...)

blockSize = 16384

' How many 16K blocks?  (Including 1 for the last partial block)

numBlocks = fac.GetNumBlocks(blockSize)

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
crypt.HashAlgorithm = "md5"

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
Dim uriPath As Chilkat.StringBuilder
Set uriPath = Chilkat.NewStringBuilder

Dim dataBlock As Chilkat.BinData
Set dataBlock = Chilkat.NewBinData


i = 0
Do While i < numBlocks

    Dim success As Boolean
    success = dataBlock.Clear()
    success = fac.ReadBlockBd(i,blockSize,dataBlock)
    If (success = False) Then
        Debug.Print fac.LastErrorText
        Exit Sub
    End If

    ' Generate a base64 block ID.  
    ' (Chilkat provides a helper method named GenBlockId to make this easy)
    ' A pre-base64 encoded block ID length of 4 is sufficient in this case because
    ' this file certainly won't have more than 99,999 blocks..
    blockId = fac.GenBlockId(i,4,"base64")

    ' Add this blockId to the list of blocks to be committed.
    xml.NewChild2 "Latest",blockId

    ' Build the URI path
    uriPath.Clear 
    success = uriPath.Append("/mycontainer/hamlet.xml?comp=block&blockId=")
    success = uriPath.Append(blockId)

    contentMd5 = crypt.HashBdENC(dataBlock)
    success = rest.AddHeader("Content-MD5",contentMd5)

    ' Upload this block..
    sbResponseBody.Clear 
    success = rest.FullRequestBd("PUT",uriPath.GetAsString(),dataBlock,sbResponseBody)
    If (success = False) Then
        Debug.Print rest.LastErrorText
        Exit Sub
    End If

    ' Verify that we received a 201 status code.
    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): "; sbResponseBody.GetAsString()
        Debug.Print "---"
        Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
        Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
        Exit Sub
    End If

    i = i + 1
Loop

fac.FileClose 

' Now commit the blocks.
' Let's have a look at the XML that will commit the blocks:

xmlStr = xml.GetXml()
Debug.Print xmlStr

' The XML will look like this:

' <?xml version="1.0" encoding="utf-8" ?>
' <BlockList>
'     <Latest>MDAwMA==</Latest>
'     <Latest>MDAwMQ==</Latest>
'     <Latest>MDAwMg==</Latest>
'     <Latest>MDAwMw==</Latest>
'     <Latest>MDAwNA==</Latest>
'     <Latest>MDAwNQ==</Latest>
'     <Latest>MDAwNg==</Latest>
'     <Latest>MDAwNw==</Latest>
'     <Latest>MDAwOA==</Latest>
'     <Latest>MDAwOQ==</Latest>
'     <Latest>MDAxMA==</Latest>
'     <Latest>MDAxMQ==</Latest>
'     <Latest>MDAxMg==</Latest>
'     <Latest>MDAxMw==</Latest>
'     <Latest>MDAxNA==</Latest>
'     <Latest>MDAxNQ==</Latest>
'     <Latest>MDAxNg==</Latest>
'     <Latest>MDAxNw==</Latest>
' </BlockList>

' --------------------------------------------------------------------------
' IMPORTANT: Remove the Content-MD5 header previously set in the loop above.
' --------------------------------------------------------------------------
success = rest.RemoveHeader("Content-MD5")

' Send the PUT Block List...

responseStr = rest.FullRequestString("PUT","/mycontainer/hamlet.xml?comp=blocklist",xmlStr)
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."

 

© 2000-2022 Chilkat Software, Inc. All Rights Reserved.