(Excel) SOAP Request to farmaclick.infarma.it

Demonstrates how to make a SOAP HTTP request to the FCKLogin method of farmaclick.infarma.it.

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.

' Here is an example of an HTTP POST Request we'll be sending:

' POST /documento.php HTTP/1.1
' Content-Type: text/xml;charset=UTF-8
' SOAPAction: https://conexion.facto.cl/documento.php/emitirDocumento
' 
' <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:api="http://api.farmaclick.infarma.it">
'    <soapenv:Header/>
'    <soapenv:Body>
'       <api:FCKLogin soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
'          <inBean xsi:type="urn:LoginInputBean" xmlns:urn="urn:BeanService">
'             <nomeTerminale xsi:type="soapenc:string" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">?</nomeTerminale>
'             <password xsi:type="soapenc:string" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">?</password>
'             <passwordSH xsi:type="soapenc:string" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">?</passwordSH>
'             <userName xsi:type="soapenc:string" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">?</userName>
'          </inBean>
'       </api:FCKLogin>
'    </soapenv:Body>
' </soapenv:Envelope>

' Use this online tool to generate code from sample XML: 
' Generate Code to Create XML

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
xml.Tag = "soapenv:Envelope"
Dim success As Boolean
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:api","http://api.farmaclick.infarma.it")
xml.UpdateChildContent "soapenv:Header",""
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin",True,"soapenv:encodingStyle","http://schemas.xmlsoap.org/soap/encoding/")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean",True,"xsi:type","urn:LoginInputBean")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean",True,"xmlns:urn","urn:BeanService")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|nomeTerminale",True,"xsi:type","soapenc:string")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|nomeTerminale",True,"xmlns:soapenc","http://schemas.xmlsoap.org/soap/encoding/")
xml.UpdateChildContent "soapenv:Body|api:FCKLogin|inBean|nomeTerminale","?"
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|password",True,"xsi:type","soapenc:string")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|password",True,"xmlns:soapenc","http://schemas.xmlsoap.org/soap/encoding/")
xml.UpdateChildContent "soapenv:Body|api:FCKLogin|inBean|password","?"
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|passwordSH",True,"xsi:type","soapenc:string")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|passwordSH",True,"xmlns:soapenc","http://schemas.xmlsoap.org/soap/encoding/")
xml.UpdateChildContent "soapenv:Body|api:FCKLogin|inBean|passwordSH","?"
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|userName",True,"xsi:type","soapenc:string")
success = xml.UpdateAttrAt("soapenv:Body|api:FCKLogin|inBean|userName",True,"xmlns:soapenc","http://schemas.xmlsoap.org/soap/encoding/")
xml.UpdateChildContent "soapenv:Body|api:FCKLogin|inBean|userName","?"

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

http.SessionLogFilename = "qa_output/sessionLog.txt"

http.SetRequestHeader "Content-Type","text/xml;charset=UTF-8"
' Indicate we want to allow an empty header..
http.UncommonOptions = "AllowEmptyHeaders"
http.SetRequestHeader "SoapAction",""


Set resp = http.PostXml("http://webservice.unicospa.it:8181/Service.svc/FrontEndService/Farmaclick2010001FCKLogin",xml.GetXml(),"utf-8")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A status code = 200 indicates success.
Debug.Print "Response status code = "; resp.StatusCode

Dim xmlResp As Chilkat.Xml
Set xmlResp = Chilkat.NewXml
success = xmlResp.LoadXml(resp.BodyStr)
Debug.Print "Response body text:"
Debug.Print xmlResp.GetXml()