(Excel) Dropbox Content Hash

Demonstrates how to compute the Dropbox content_hash of a file. (This is the "content_hash" found in the Dropbox FileMetadata object.

Note: This example requires Chilkat v9.5.0.79 or greater because it uses the fac.ReadBlockBd method.

For more information, see https://www.dropbox.com/developers/reference/content-hash

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 crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

' To calculate the content_hash of a file:
' Split the file into blocks of 4 MB (4,194,304 or 4 * 1024 * 1024 bytes). The last block (if any) may be smaller than 4 MB.
' Compute the hash of each block using SHA-256.
' Concatenate the hash of all blocks in the binary format to form a single binary string.
' Compute the hash of the concatenated string using SHA-256. Output the resulting hash in hexadecimal format.

crypt.HashAlgorithm = "sha256"
crypt.EncodingMode = "hex_lower"

' We're going to calculate the content_hash for the Milky Way JPG image linked here:  https://www.dropbox.com/developers/reference/content-hash

Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess
Dim bd As Chilkat.BinData
Set bd = Chilkat.NewBinData
Dim bdHashes As Chilkat.BinData
Set bdHashes = Chilkat.NewBinData


success = fac.OpenForRead("qa_data/jpg/milky-way-nasa.jpg")
If (success = False) Then
    Debug.Print fac.LastErrorText
    Exit Sub
End If


blockSize = 4194304

numBlocks = fac.GetNumBlocks(blockSize)


i = 0
Do While (i < numBlocks)
    ' Read the next 4MB block into bd.
    Dim success As Boolean
    success = bd.Clear()
    success = fac.ReadBlockBd(i,blockSize,bd)


    hashHex = crypt.HashBdENC(bd)
    Debug.Print i; ": "; hashHex
    success = bdHashes.AppendEncoded(hashHex,"hex_lower")

    i = i + 1
Loop

fac.FileClose 

' Hash the concatenated SHA-256 hashes.

content_hash = crypt.HashBdENC(bdHashes)
Debug.Print "content_hash = "; content_hash