(Excel) Aruba Fatturazione Elettronica Get Zip by Filename

Returns an invoice with all of its notifications in Zip format (e.g. IT01879020517_abcde.xml.p7m).

For more information, see https://fatturazioneelettronica.aruba.it/apidoc/docs_EN.html#_getzipbyfilename

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl -X GET https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/getZipByFilename?filename=IT01879020517_jtlk1.xml.p7m \
'   -H "Accept: application/json" \
'   -H "Authorization: Bearer NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE="

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

' Adds the "Authorization: Bearer NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE=" header.
http.AuthToken = "NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE="
http.SetRequestHeader "Accept","application/json"

Dim bdZip As Chilkat.BinData
Set bdZip = Chilkat.NewBinData
success = http.QuickGetBd("https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/getZipByFilename?filename=IT01879020517_jtlk1.xml.p7m",bdZip)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


respStatusCode = http.LastStatus
Debug.Print "response status code = "; respStatusCode

If (respStatusCode <> 200) Then
    ' If it failed, the response body will not contain the .zip file data.
    ' It will likely contain an error message.
    Debug.Print bdZip.GetString("utf-8")
    Debug.Print "Failed."
    Exit Sub
End If

' Open the zip and extract the .p7m
Dim zip As Chilkat.Zip
Set zip = Chilkat.NewZip

success = zip.OpenBd(bdZip)
If (success = False) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

' If desired, we can unzip to the filesystem..

numUnzipped = zip.Unzip("c:/mySignedInvoices")
If (numUnzipped < 0) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

' Alternatively, we can unzip into memory..

Set entry = zip.GetEntryByIndex(0)
If (zip.LastMethodSuccess = False) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

Dim bdP7m As Chilkat.BinData
Set bdP7m = Chilkat.NewBinData
success = entry.UnzipToBd(bdP7m)
If (success = False) Then
    Debug.Print entry.LastErrorText
    Exit Sub
End If

' Verify the signature and extract the XML from the p7m
' If the signature verification is successful, the contents of bdP7m are unwrapped and what
' remains is the original signed document..
Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
success = crypt.OpaqueVerifyBd(bdP7m)
If (success = False) Then
    Debug.Print crypt.LastErrorText
    Exit Sub
End If

Debug.Print "The signature was verified."

' The bdp7m now contains the XML that was originally signed.
Debug.Print "Original XML:"
Debug.Print bdP7m.GetString("utf-8")