(VBScript) Royal Mail OBA Web Service -- Get Accounts

See more Royal Mail OBA Examples

Royal Mail OBA Web Service -- Get Accounts.

For more information, see https://parcel.royalmail.com/eproimport.wsdl

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' --------------------------------------------------------------------------------
' Also see Chilkat's Online WSDL Code Generator
' to generate code and SOAP Request and Response XML for each operation in a WSDL.
' --------------------------------------------------------------------------------

' Create the following XML:

' <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:epro="urn:schemas-royalmail-com/webservice/epro">
'    <soapenv:Header>
'       <epro:Authentication>
'          <epro:Username>my_username</epro:Username>
'          <epro:Password>my_password</epro:Password>
'          <epro:AccessCode>my_accessCode</epro:AccessCode>
'          <epro:Version>1.0</epro:Version>
'          <epro:SecurityToken>mysecuritytoken</epro:SecurityToken>
'       </epro:Authentication>
'    </soapenv:Header>
'    <soapenv:Body>
'       <epro:GetAccounts/>
'    </soapenv:Body>
' </soapenv:Envelope>

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = CreateObject("Chilkat.Xml")
xml.EmitXmlDecl = 0
xml.Tag = "soapenv:Envelope"
success = xml.AddAttribute("xmlns:soapenv","http://schemas.xmlsoap.org/soap/envelope/")
success = xml.AddAttribute("xmlns:epro","urn:schemas-royalmail-com/webservice/epro")

' Replace my_username, my_password, and my_accessCode with your actual values.  Do not replace "mysecuritytoken".
xml.UpdateChildContent "soapenv:Header|epro:Authentication|epro:Username","my_username"
xml.UpdateChildContent "soapenv:Header|epro:Authentication|epro:Password","my_password"
xml.UpdateChildContent "soapenv:Header|epro:Authentication|epro:AccessCode","my_accessCode"
xml.UpdateChildContent "soapenv:Header|epro:Authentication|epro:Version","1.0"

' Literally use the string "mysecuritytoken" here.
xml.UpdateChildContent "soapenv:Header|epro:Authentication|epro:SecurityToken","mysecuritytoken"
xml.UpdateChildContent "soapenv:Body|epro:GetAccounts",""

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

http.SetRequestHeader "SOAPAction","urn:schemas-royalmail-com/webservice/epro/GetAccounts"
http.SetRequestHeader "Content-Type","text/xml; charset=utf-8"

' Use the sandbox endpoint:   http://interfaces.oba-v.royalmail.com/legacyws/EProImport.asmx 
' The live endpoint would be: http://www.epro.royalmail.com/WebServices/import/eproimport.asmx
endpointUrl = "http://interfaces.oba-v.royalmail.com/legacyws/EProImport.asmx"

' resp is a Chilkat.HttpResponse
Set resp = http.PostXml(endpointUrl,xml.GetXml(),"utf-8")
If (http.LastMethodSuccess = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine("response status code = " & resp.StatusCode)
outFile.WriteLine(resp.BodyStr)

' The response looks like this:

' <?xml version="1.0" encoding="utf-8"?>
' <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
'     <SOAP-ENV:Header/>
'     <SOAP-ENV:Body>
'         <ns1:GetAccountsResponse xmlns:ns1="urn:schemas-royalmail-com/webservice/epro">
'             <ns1:GetAccountsResult>
'                 <ns1:Accounts>
'                     <ns1:Account AccountName="DEMO CUSTOMER_Atos" AccountNumber="099986000"/>
'                     <ns1:Account AccountName="CREDIT MANAGEMENT CENTRE" AccountNumber="999386001"/>
'                 </ns1:Accounts>
'             </ns1:GetAccountsResult>
'         </ns1:GetAccountsResponse>
'     </SOAP-ENV:Body>
' </SOAP-ENV:Envelope>
' 

success = xml.LoadXml(resp.BodyStr)

i = 0
numAccounts = xml.NumChildrenHavingTag("SOAP-ENV:Body|ns1:GetAccountsResponse|ns1:GetAccountsResult|ns1:Accounts|ns1:Account")
Do While i < numAccounts
    xml.I = i
    accountName = xml.ChilkatPath("SOAP-ENV:Body|ns1:GetAccountsResponse|ns1:GetAccountsResult|ns1:Accounts|ns1:Account[i]|(AccountName)")
    accountNumber = xml.ChilkatPath("SOAP-ENV:Body|ns1:GetAccountsResponse|ns1:GetAccountsResult|ns1:Accounts|ns1:Account[i]|(AccountNumber)")
    outFile.WriteLine(accountName & ": " & accountNumber)
    i = i + 1
Loop


outFile.Close