(Excel) Sign Manifest File to Generate a Passbook .pkpass in Memory

Demonstrates how to create a Passbook .pkpass archive by creating a signature of a manifest file and then zipping to a .pkpass archive in memory

Download Excel Class Modules Chilkat Excel Class Modules

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' ---------------------------------------------------------------------------------------------
' This example is the same as Sign Manifest File to Generate a Passbook .pkpass file
' except everything happens in memory (no input files, no output files)
' ---------------------------------------------------------------------------------------------

' First create the manifest.json

Dim manifest As Chilkat.JsonObject
Set manifest = Chilkat.NewJsonObject
Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

Dim zip As Chilkat.Zip
Set zip = Chilkat.NewZip
Dim success As Boolean
success = zip.NewZip("notUsedAndNeverCreated.zip")

crypt.HashAlgorithm = "sha1"
' Return hashes as lowercase hex.
crypt.EncodingMode = "hexlower"

Dim pngData As Chilkat.BinData
Set pngData = Chilkat.NewBinData
' Assume we load the pngData with bytes for "icon.png" from somewhere, such as a byte array in memory.

Set entry = zip.AppendBd("icon.png",pngData)

digestStr = crypt.HashBdENC(pngData)
success = manifest.UpdateString("""icon.png""",digestStr)

success = pngData.Clear()
' Assume we load the pngData with bytes for "icon@2x.png" from somewhere...
Set entry = zip.AppendBd("icon@2x.png",pngData)

digestStr = crypt.HashBdENC(pngData)
success = manifest.UpdateString("""icon@2x.png""",digestStr)

success = pngData.Clear()
' Assume we load the pngData with bytes for "logo.png" from somewhere...
Set entry = zip.AppendBd("logo.png",pngData)

digestStr = crypt.HashBdENC(pngData)
success = manifest.UpdateString("""logo.png""",digestStr)

success = pngData.Clear()
' Assume we load the pngData with bytes for "logo@2x.png" from somewhere...
Set entry = zip.AppendBd("logo@2x.png",pngData)

digestStr = crypt.HashBdENC(pngData)
success = manifest.UpdateString("""logo@2x.png""",digestStr)


passJson = "{ .... }"'  Contains the contents of pass.json
Set entry = zip.AppendString("pass.json",passJson)

digestStr = crypt.HashStringENC(passJson)
success = manifest.UpdateString("""pass.json""",digestStr)

Set entry = zip.AppendString("manifest.json",manifest.Emit())

' Make sure we have the Apple WWDR intermediate certificate available for 
' the cert chain in the signature.
Dim certVault As Chilkat.XmlCertVault
Set certVault = Chilkat.NewXmlCertVault
Dim appleWwdrCert As Chilkat.Cert
Set appleWwdrCert = Chilkat.NewCert
success = appleWwdrCert.LoadByCommonName("Apple Worldwide Developer Relations Certification Authority")
If (success <> True) Then
    Debug.Print "The Apple WWDR intermediate certificate is not installed."
    Debug.Print "It is available at https://developer.apple.com/certificationauthority/AppleWWDRCA.cer"
    Debug.Print "You may alternatively load the .cer like this..."
    success = appleWwdrCert.LoadFromFile("qa_data/certs/AppleWWDRCA.cer")
    If (success <> True) Then
        Debug.Print appleWwdrCert.LastErrorText
        Exit Sub
    End If

End If

success = certVault.AddCert(appleWwdrCert)
success = crypt.UseCertVault(certVault)

' Use a digital certificate and private key from a PFX
Dim bdPfx As Chilkat.BinData
Set bdPfx = Chilkat.NewBinData
' Assume we loaded a PFX into bdPfx....

pfxPassword = "test123"

Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert
success = cert.LoadPfxBd(bdPfx,pfxPassword)
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' Provide the signing cert (with associated private key).
success = crypt.SetSigningCert(cert)
If (success <> True) Then
    Debug.Print crypt.LastErrorText
    Exit Sub
End If

' Specify the signed attributes to be included.
' (These attributes appear to not be necessary, but we're including
' them just in case they become necessary in the future.)
Dim jsonSignedAttrs As Chilkat.JsonObject
Set jsonSignedAttrs = Chilkat.NewJsonObject
success = jsonSignedAttrs.UpdateInt("contentType",1)
success = jsonSignedAttrs.UpdateInt("signingTime",1)
crypt.SigningAttributes = jsonSignedAttrs.Emit()

' Sign the manifest JSON to produce a signature
crypt.EncodingMode = "base64"

sig = crypt.SignStringENC(manifest.Emit())
Dim bdSig As Chilkat.BinData
Set bdSig = Chilkat.NewBinData
success = bdSig.AppendEncoded(sig,"base64")
Set entry = zip.AppendBd("signature",bdSig)

' ---------------------------------------------------------------------------------------------
' Note: Chilkat also has the capability to do everything in-memory (no files would be involved).  
' If this is of interest, please send email to support@chilkatsoft.com
' ---------------------------------------------------------------------------------------------

' Create the .pkipass archive (which is a .zip archive containing the required files).
' the .zip is written to bdZip
Dim bdZip As Chilkat.BinData
Set bdZip = Chilkat.NewBinData
success = zip.WriteBd(bdZip)
If (success <> True) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

Debug.Print "Success."