(Excel) PEPPOL Document Validation

Demonstrates how to call a Web service to validate your PEPPOL documents according to the latest PEPPOL rules. The validation service requires UBL files.

For more information, see https://peppol.helger.com/public/locale-en_US/menuitem-validation-ws2

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' We are sending the following POST:

' POST /wsdvs HTTP/1.1
' Host: peppol.helger.com
' Content-Type: application/soap+xml; charset=utf-8
' Content-Length: <length>
' 
' <?xml version="1.0"?>
' <S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
' <S:Body>
' <validateRequestInput xmlns="http://peppol.helger.com/ws/documentvalidationservice/201701/" VESID="eu.peppol.bis2:t10:3.3.0" displayLocale="en">
' <XML>...ENTITY_ENCODED_INVOICE_XML_GOES_HERE...</XML>
' </validateRequestInput>
' </S:Body>
' </S:Envelope>

' Build the SOAP XML shown above.
' First load the PEPPOL invoice that will be the data contained in the <XML>...</XML> SOAP element.
' We are using the XML invoice obtained from https://github.com/austriapro/ebinterface-standards/blob/master/schemas/ebInterface5p0/samples/ebinterface_5p0_sample_ecosio.xml
Dim sbPeppolInvoiceXml As Chilkat.StringBuilder
Set sbPeppolInvoiceXml = Chilkat.NewStringBuilder

success = sbPeppolInvoiceXml.LoadFile("qa_data/xml/peppol_invoice.xml","utf-8")

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
xml.Tag = "S:Envelope"
success = xml.AddAttribute("xmlns:S","http://schemas.xmlsoap.org/soap/envelope/")
success = xml.UpdateAttrAt("S:Body|validateRequestInput",True,"xmlns","http://peppol.helger.com/ws/documentvalidationservice/201701/")
success = xml.UpdateAttrAt("S:Body|validateRequestInput",True,"VESID","at.ebinterface:invoice:5.0")
success = xml.UpdateAttrAt("S:Body|validateRequestInput",True,"displayLocale","en")
xml.UpdateChildContent "S:Body|validateRequestInput|XML",sbPeppolInvoiceXml.GetAsString()

' Set the Content-Type of the request.
http.SetRequestHeader "Content-Type","text/xml"

' We don't need to specify the Content-Length or Host headers.  Chilkat automatically adds them.

' Send the request...

Set resp = http.PostXml("https://peppol.helger.com/wsdvs",xml.GetXml(),"utf-8")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code = "; resp.StatusCode

Dim respXml As Chilkat.Xml
Set respXml = Chilkat.NewXml
success = respXml.LoadXml(resp.BodyStr)

Debug.Print "Response XML:"
Debug.Print respXml.GetXml()

' A success repsonse looks like this:

' <?xml version="1.0" encoding="UTF-8"?>
' <S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
'     <S:Body>
'         <validateResponseOutput xmlns="http://peppol.helger.com/ws/documentvalidationservice/201701/" success="true" interrupted="false" mostSevereErrorLevel="SUCCESS">
'             <Result success="true" artifactType="xsd" artifactPath="/schemas/ebinterface/ebinterface-5.0.xsd"/>
'         </validateResponseOutput>
'     </S:Body>
' </S:Envelope>