PowerBuilder

Royal Mail OBA Web Service -- Get Accounts

See more Royal Mail OBA Examples

Royal Mail OBA Web Service -- Get Accounts. PowerBuilder

integer li_rc
long li_Success
oleobject loo_Xml
oleobject loo_Http
string ls_EndpointUrl
oleobject loo_Resp
string ls_AccountName
string ls_AccountNumber
long i
long li_NumAccounts

li_Success = 0

//  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>

loo_Xml = create oleobject
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")
if li_rc < 0 then
    destroy loo_Xml
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Xml.EmitXmlDecl = 0
loo_Xml.Tag = "soapenv:Envelope"
loo_Xml.AddAttribute("xmlns:soapenv","http://schemas.xmlsoap.org/soap/envelope/")
loo_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".
loo_Xml.UpdateChildContent("soapenv:Header|epro:Authentication|epro:Username","my_username")
loo_Xml.UpdateChildContent("soapenv:Header|epro:Authentication|epro:Password","my_password")
loo_Xml.UpdateChildContent("soapenv:Header|epro:Authentication|epro:AccessCode","my_accessCode")
loo_Xml.UpdateChildContent("soapenv:Header|epro:Authentication|epro:Version","1.0")

//  Literally use the string "mysecuritytoken" here.
loo_Xml.UpdateChildContent("soapenv:Header|epro:Authentication|epro:SecurityToken","mysecuritytoken")
loo_Xml.UpdateChildContent("soapenv:Body|epro:GetAccounts","")

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.SetRequestHeader("SOAPAction","urn:schemas-royalmail-com/webservice/epro/GetAccounts")

//  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
ls_EndpointUrl = "http://interfaces.oba-v.royalmail.com/legacyws/EProImport.asmx"

loo_Resp = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

li_Success = loo_Http.HttpStr("POST",ls_EndpointUrl,loo_Xml.GetXml(),"utf-8","text/xml",loo_Resp)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Xml
    destroy loo_Http
    destroy loo_Resp
    return
end if

Write-Debug "response status code = " + string(loo_Resp.StatusCode)
Write-Debug loo_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>
//  

loo_Xml.LoadXml(loo_Resp.BodyStr)

i = 0
li_NumAccounts = loo_Xml.NumChildrenHavingTag("SOAP-ENV:Body|ns1:GetAccountsResponse|ns1:GetAccountsResult|ns1:Accounts|ns1:Account")
do while i < li_NumAccounts
    loo_Xml.I = i
    ls_AccountName = loo_Xml.ChilkatPath("SOAP-ENV:Body|ns1:GetAccountsResponse|ns1:GetAccountsResult|ns1:Accounts|ns1:Account[i]|(AccountName)")
    ls_AccountNumber = loo_Xml.ChilkatPath("SOAP-ENV:Body|ns1:GetAccountsResponse|ns1:GetAccountsResult|ns1:Accounts|ns1:Account[i]|(AccountNumber)")
    Write-Debug ls_AccountName + ": " + ls_AccountNumber
    i = i + 1
loop


destroy loo_Xml
destroy loo_Http
destroy loo_Resp