(Excel) Mastercard ICCP Get Data Source with OAuth1

See more Mastercard Examples

Demonstrates OAuth1 authentication with the Mastercard SOAP API's. This example sends a POST to the sandbox endpoint for the "In Control for Commercial Payments" (ICCP) API.

Note: This example requires Chilkat v9.5.0.91 or later.

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.

' First build the XML body of the SOAP request:

'     <soapenv:Envelope
' 	    xmlns:ser="http://mastercard.com/sd/pc/service"
' 	    xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
' 	    <soapenv:Header>
' 	    </soapenv:Header>
' 	    <soapenv:Body>
' 		    <ser:getDataSourcesRequest></ser:getDataSourcesRequest>
' 	    </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:ser","http://mastercard.com/sd/pc/service")
success = xml.AddAttribute("xmlns:soapenv","http://schemas.xmlsoap.org/soap/envelope/")
xml.UpdateChildContent "soapenv:Header",""
xml.UpdateChildContent "soapenv:Body|ser:getDataSourcesRequest",""

' We'll need to get our signing RSA key from the PFX (provided by Mastercard)
Dim pfx As Chilkat.Pfx
Set pfx = Chilkat.NewPfx

success = pfx.LoadPfxFile("qa_data/pfx/MCD_Sandbox_chilkat_iccp_API_Keys/chilkat_iccp-sandbox.p12","keystorepassword")
If (success = False) Then
    Debug.Print pfx.LastErrorText
    Exit Sub
End If


Set privKey = pfx.GetPrivateKey(0)
If (pfx.LastMethodSuccess = False) Then
    Debug.Print pfx.LastErrorText
    Exit Sub
End If

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

http.OAuth1 = True
' Use your own consumer key (this is not a valid consumer key)
http.OAuthConsumerKey = "MLBRl0-xxxxxxxxxxxxxxxxxxxxxxxxxx_BUNtu5xxxxx20b!a075a714a5fxxxxxxxxxxxxx59cd02b60000000000000000"
http.OAuthSigMethod = "RSA-SHA256"
success = http.SetOAuthRsaKey(privKey)
If (success = False) Then
    Debug.Print http.LastErrorText

    Exit Sub
End If

' Tell Chilkat to automatically calculate and add the oauth_body_hash field when sending the request.
' This property was added in Chilkat v9.5.0.91.
http.OAuthBodyHash = True

' Send the SOAP XML request and get the response.
' Chilkat automaticaly adds the OAuth1 authentication.

Set resp = http.PostXml("https://sandbox.api.mastercard.com/iccp/financial",xml.GetXml(),"utf-8")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Examine the response status code and the XML response body.
Debug.Print "Response status code = "; resp.StatusCode

Dim respXml As Chilkat.Xml
Set respXml = Chilkat.NewXml
success = resp.GetBodyXml(respXml)

Debug.Print "Response XML:"
Debug.Print respXml.GetXml()

' If desired, use this online tool to generate parsing code from response XML.
' (Run your code once to get a representative sample response, and then generate the parsing code.)
' Generate Parsing Code from XML