VBScript Requires Chilkat v11.0.0+
VBScript
Extract signed invoice XML from an Italian PEC message
See more Email Object Examples
Search the PEC folder by subject, fetch one envelope by UID, and inspect the attachments of each nested email. Match .xml.p7m by filename and verify the opaque CMS signature before loading the XML. This checks signature integrity. Certificate trust and invoice schema validation are separate application decisions.
Chilkat VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
success = 0
' Assumes Chilkat is unlocked. See Global Unlock Sample.
set imap = CreateObject("Chilkat.Imap")
imap.Ssl = 1
imap.Port = 993
imap.RequireSslCertVerify = 1
imap.PeekMode = 1
imap.AutoDownloadAttachments = 1
success = imap.Connect("imap.example.com")
If (success <> 1) Then
outFile.WriteLine(imap.LastErrorText)
WScript.Quit
End If
success = imap.Login("IMAP_USERNAME","IMAP_PASSWORD")
If (success <> 1) Then
outFile.WriteLine(imap.LastErrorText)
WScript.Quit
End If
success = imap.SelectMailbox("INBOX/postacert")
If (success <> 1) Then
outFile.WriteLine(imap.LastErrorText)
WScript.Quit
End If
set messages = CreateObject("Chilkat.MessageSet")
success = imap.QueryMbx("SUBJECT ""POSTA CERTIFICATA: Invio File""",1,messages)
If (success <> 1) Then
outFile.WriteLine(imap.LastErrorText)
WScript.Quit
End If
If (messages.Count = 0) Then
outFile.WriteLine("No matching PEC envelope.")
success = imap.Disconnect()
WScript.Quit
End If
set envelope = CreateObject("Chilkat.Email")
success = imap.FetchEmail(0,messages.GetId(0),1,envelope)
If (success <> 1) Then
outFile.WriteLine(imap.LastErrorText)
WScript.Quit
End If
success = imap.Disconnect()
set nested = CreateObject("Chilkat.Email")
set name = CreateObject("Chilkat.StringBuilder")
verified = 0
i = 0
Do While (i < envelope.NumAttachedMessages)
success = envelope.GetAttachedEmail(i,nested)
If (success <> 1) Then
outFile.WriteLine(envelope.LastErrorText)
WScript.Quit
End If
j = 0
Do While (j < nested.NumAttachments)
success = name.SetString(nested.GetAttachmentFilename(j))
If (name.EndsWith(".xml.p7m",0) = 1) Then
set data = CreateObject("Chilkat.BinData")
success = nested.GetAttachmentBd(j,data)
If (success <> 1) Then
outFile.WriteLine(nested.LastErrorText)
WScript.Quit
End If
set cms = CreateObject("Chilkat.Crypt2")
success = cms.OpaqueVerifyBd(data)
If (success <> 1) Then
outFile.WriteLine(cms.LastErrorText)
WScript.Quit
End If
set invoice = CreateObject("Chilkat.Xml")
success = invoice.LoadBd(data,1)
If (success <> 1) Then
outFile.WriteLine(invoice.LastErrorText)
WScript.Quit
End If
outFile.WriteLine(name.GetAsString() & " XML root: " & invoice.Tag)
verified = verified + 1
End If
j = j + 1
Loop
i = i + 1
Loop
outFile.WriteLine("Verified XML invoices: " & verified)
outFile.Close