(Excel) SOAP e-factura.sunat.gob.pe getStatusCdr

Make a SOAP call to https://e-factura.sunat.gob.pe/ol-it-wsconscpegem/billConsultService

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 http As Chilkat.Http
Set http = Chilkat.NewHttp

' <soapenv:Envelope xmlns:ser="http://service.sunat.gob.pe"
'   xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
'   xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
'  <soapenv:Header>
'   <wsse:Security>        
'    <wsse:UsernameToken>          
'     <wsse:Username>MY_USERNAME</wsse:Username>
'     <wsse:Password>MY_PASSWORD</wsse:Password>
'    </wsse:UsernameToken>      
'   </wsse:Security>
'  </soapenv:Header>
'  <soapenv:Body>
'   <ser:getStatus>
'    <rucComprobante>99999999999</rucComprobante>
'    <tipoComprobante>01</tipoComprobante>
'    <serieComprobante>F001</serieComprobante>
'    <numeroComprobante>55555</numeroComprobante>
'   </ser:getStatus>
'  </soapenv:Body>
'  </soapenv:Envelope> 
' 

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
xml.Tag = "soapenv:Envelope"
success = xml.AddAttribute("xmlns:ser","http://service.sunat.gob.pe")
success = xml.AddAttribute("xmlns:soapenv","http://schemas.xmlsoap.org/soap/envelope/")
success = xml.AddAttribute("xmlns:wsse","http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd")
xml.UpdateChildContent "soapenv:Header|wsse:Security|wsse:UsernameToken|wsse:Username","MY_USERNAME"
xml.UpdateChildContent "soapenv:Header|wsse:Security|wsse:UsernameToken|wsse:Password","MY_PASSWORD"
xml.UpdateChildContent "soapenv:Body|ser:getStatus|rucComprobante","99999999999"
xml.UpdateChildContent "soapenv:Body|ser:getStatus|tipoComprobante","01"
xml.UpdateChildContent "soapenv:Body|ser:getStatus|serieComprobante","F001"
xml.UpdateChildContent "soapenv:Body|ser:getStatus|numeroComprobante","55555"


strXml = xml.GetXml()

http.SetRequestHeader "SOAPAction","urn:getStatusCdr"
http.SetRequestHeader "Content-Type","text/xml; charset=utf-8"


endPoint = "https://e-factura.sunat.gob.pe/ol-it-wsconscpegem/billConsultService"


Set resp = http.PostXml(endPoint,strXml,"utf-8")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


statusCode = resp.StatusCode
If (statusCode <> 200) Then
    Debug.Print "Non-success status code: "; statusCode
    Debug.Print "Response header: "; resp.Header
    Debug.Print "Response body: "; resp.BodyStr
    Debug.Print "Unsuccessful."

    Exit Sub
End If

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

Debug.Print xmlResp.GetXml()

' A sample response:

' <?xml version="1.0" encoding="UTF-8"?>
' <S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
'     <S:Body>
'         <ns0:getStatusResponse xmlns:ns0="http://service.sunat.gob.pe">
'             <status>
'                 <statusCode>0001</statusCode>
'                 <statusMessage>El comprobante existe y est aceptado.</statusMessage>
'             </status>
'         </ns0:getStatusResponse>
'     </S:Body>
' </S:Envelope>
' 

' Parse the response...

S_Envelope_xmlns_S = xml.GetAttrValue("xmlns:S")

ns0_getStatusResponse_xmlns_ns0 = xml.ChilkatPath("S:Body|ns0:getStatusResponse|(xmlns:ns0)")
statusCode = xml.GetChildIntValue("S:Body|ns0:getStatusResponse|status|statusCode")

statusMessage = xml.GetChildContent("S:Body|ns0:getStatusResponse|status|statusMessage")