(Excel) palena.sii.cl getToken SOAP Request

Demonstrates how to call getToken SOAP request at palena.sii.cl

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.

' Create the XML to be signed...
Dim xmlToSign As Chilkat.Xml
Set xmlToSign = Chilkat.NewXml
xmlToSign.Tag = "getToken"
' This is the seed obtained from palena.sii.cl getSeed
xmlToSign.UpdateChildContent "item|Semilla","033878794660"

Dim gen As Chilkat.XmlDSigGen
Set gen = Chilkat.NewXmlDSigGen

gen.SigLocation = "getToken"
gen.SigLocationMod = 0
gen.SigNamespacePrefix = ""
gen.SigNamespaceUri = "http://www.w3.org/2000/09/xmldsig#"
gen.SignedInfoCanonAlg = "EXCL_C14N"
gen.SignedInfoDigestMethod = "sha1"

Dim success As Boolean
success = gen.AddSameDocRef("","sha1","","","")

' Provide a certificate + private key. (PFX password is test123)
Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert
success = cert.LoadPfxFile("qa_data/pfx/cert_test123.pfx","test123")
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

success = gen.SetX509Cert(cert,True)

gen.KeyInfoType = "X509Data"
gen.X509Type = "Certificate"

' Load XML to be signed...
Dim sbXml As Chilkat.StringBuilder
Set sbXml = Chilkat.NewStringBuilder
xmlToSign.EmitXmlDecl = False
success = xmlToSign.GetXmlSb(sbXml)

gen.Behaviors = "IndentedSignature"

' Sign the XML...
success = gen.CreateXmlDSigSb(sbXml)
If (success <> True) Then
    Debug.Print gen.LastErrorText
    Exit Sub
End If

' -----------------------------------------------

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

http.UncommonOptions = "AllowEmptyHeaders"
http.SetRequestHeader "SOAPAction",""

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

' The endpoint for this soap service is:

endPoint = "https://palena.sii.cl/DTEWS/GetTokenFromSeed.jws"

' Send the following SOAP XML

' <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:def="http://DefaultNamespace">
'    <soapenv:Header/>
'    <soapenv:Body>
'       <def:getToken soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
'          <pszXml>SIGNED_XML_GOES_HERE</pszXml>
'       </def:getToken>
'    </soapenv:Body>
' </soapenv:Envelope>

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
xml.Tag = "soapenv:Envelope"
success = xml.AddAttribute("xmlns:xsi","http://www.w3.org/2001/XMLSchema-instance")
success = xml.AddAttribute("xmlns:xsd","http://www.w3.org/2001/XMLSchema")
success = xml.AddAttribute("xmlns:soapenv","http://schemas.xmlsoap.org/soap/envelope/")
success = xml.AddAttribute("xmlns:def","http://DefaultNamespace")
xml.UpdateChildContent "soapenv:Header",""
success = xml.UpdateAttrAt("soapenv:Body|def:getToken",True,"soapenv:encodingStyle","http://schemas.xmlsoap.org/soap/encoding/")
xml.UpdateChildContent "soapenv:Body|def:getToken|pszXml","SIGNED_XML_GOES_HERE"

' We must replace the "SIGNED_XML_GOES_HERE" with the exact contents of the signed XML to ensure the signed XML is not modified in any way.
Dim sbSoapXml As Chilkat.StringBuilder
Set sbSoapXml = Chilkat.NewStringBuilder
success = sbSoapXml.Append(xml.GetXml())

numReplaced = sbXml.Replace("&","&amp;")
numReplaced = sbXml.Replace(">","&gt;")
numReplaced = sbXml.Replace("<","&lt;")
numReplaced = sbXml.Replace("""","&quot;")
numReplaced = sbSoapXml.Replace("SIGNED_XML_GOES_HERE",sbXml.GetAsString())


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

responseStatusCode = resp.StatusCode

Debug.Print "Response Status Code: "; responseStatusCode

' You may examine the exact HTTP header sent with the POST like this:
Debug.Print "LastHeader:"
Debug.Print http.LastHeader

' Examine the XML returned by the web service:
Debug.Print "XML Response:"
Dim xmlResp As Chilkat.Xml
Set xmlResp = Chilkat.NewXml
success = xmlResp.LoadXml(resp.BodyStr)
Debug.Print xmlResp.GetXml()

' Use this online tool to generate parsing code from response XML: 
' Generate Parsing Code from XML