VBScript Requires Chilkat v11.0.0+
VBScript
PayPal - Show Payment Details
See more PayPal Examples
Shows details for a payment by ID.Chilkat VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
success = 0
' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
' Load our previously obtained access token. (see PayPal OAuth2 Access Token)
set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/paypal.json")
' Build the Authorization request header field value.
set sbAuth = CreateObject("Chilkat.StringBuilder")
' token_type should be "Bearer"
success = sbAuth.Append(jsonToken.StringOf("token_type"))
success = sbAuth.Append(" ")
success = sbAuth.Append(jsonToken.StringOf("access_token"))
' Make the initial connection.
' A single REST object, once connected, can be used for many PayPal REST API calls.
' The auto-reconnect indicates that if the already-established HTTPS connection is closed,
' then it will be automatically re-established as needed.
set rest = CreateObject("Chilkat.Rest")
bAutoReconnect = 1
success = rest.Connect("api.sandbox.paypal.com",443,1,bAutoReconnect)
If (success = 0) Then
outFile.WriteLine(rest.LastErrorText)
WScript.Quit
End If
' ----------------------------------------------------------------------------------------------
' The code above this comment could be placed inside a function/subroutine within the application
' because the connection does not need to be made for every request. Once the connection is made
' the app may send many requests..
' ----------------------------------------------------------------------------------------------
' Clear the REST object of any headers or query params from previous requests.
success = rest.ClearAllHeaders()
success = rest.ClearAllQueryParams()
success = rest.AddHeader("Authorization",sbAuth.GetAsString())
' The payment ID is added to the path.
set sbPath = CreateObject("Chilkat.StringBuilder")
success = sbPath.Append("/v1/payments/payment/payment_id")
numReplaced = sbPath.Replace("payment_id","PAY-62106714J93631829LA44NWI")
' Send the GET request and get the JSON response.
set sbJsonResponse = CreateObject("Chilkat.StringBuilder")
success = rest.FullRequestNoBodySb("GET",sbPath.GetAsString(),sbJsonResponse)
If (success = 0) Then
outFile.WriteLine(rest.LastErrorText)
WScript.Quit
End If
set json = CreateObject("Chilkat.JsonObject")
json.EmitCompact = 0
success = json.LoadSb(sbJsonResponse)
outFile.WriteLine("Response Status Code = " & rest.ResponseStatusCode)
' Did we get a 200 success response?
If (rest.ResponseStatusCode <> 200) Then
outFile.WriteLine(json.Emit())
outFile.WriteLine("Failed.")
WScript.Quit
End If
' Sample JSON response is shown below.
outFile.WriteLine(json.Emit())
outFile.WriteLine("----------------------")
' Show how to get a timestamp, such as update_time.
set dateTime = CreateObject("Chilkat.CkDateTime")
success = dateTime.SetFromTimestamp(json.StringOf("update_time"))
outFile.WriteLine("utc update_time: " & dateTime.GetAsTimestamp(0))
outFile.WriteLine("local update_time: " & dateTime.GetAsTimestamp(1))
outFile.WriteLine("utc rfc822: " & dateTime.GetAsRfc822(0))
outFile.WriteLine("local rfc822: " & dateTime.GetAsRfc822(1))
set dtUtc = CreateObject("Chilkat.DtObj")
dateTime.ToDtObj 0,dtUtc
outFile.WriteLine(dtUtc.Month & "/" & dtUtc.Day & "/" & dtUtc.Year)
outFile.WriteLine("success")
' ------------------------------------------------
' A sample JSON response:
' {
' "id": "PAY-2CY489250W145633HLA3DK3Y",
' "create_time": "2016-11-24T00:33:51Z",
' "update_time": "2016-11-24T00:40:54Z",
' "state": "approved",
' "intent": "authorize",
' "payer": {
' "payment_method": "credit_card",
' "funding_instruments": [
' {
' "credit_card_token": {
' "credit_card_id": "CARD-52W84623JH8043102LA3CLGA",
' "payer_id": "user12345",
' "last4": "9974",
' "type": "visa",
' "expire_month": "9",
' "expire_year": "2021"
' }
' }
' ]
' },
' "transactions": [
' {
' "amount": {
' "total": "6.70",
' "currency": "USD",
' "details": {
' "subtotal": "6.70"
' }
' },
' "description": "This is the payment transaction description.",
' "related_resources": [
' {
' "authorization": {
' "id": "7X8332687A4929542",
' "create_time": "2016-11-24T00:33:51Z",
' "update_time": "2016-11-24T00:33:58Z",
' "amount": {
' "total": "6.70",
' "currency": "USD",
' "details": {
' "subtotal": "6.70"
' }
' },
' "state": "captured",
' "parent_payment": "PAY-2CY489250W145633HLA3DK3Y",
' "valid_until": "2016-12-23T00:33:51Z",
' "links": [
' {
' "href": "https://api.sandbox.paypal.com/v1/payments/authorization/7X8332687A4929542",
' "rel": "self",
' "method": "GET"
' },
' {
' "href": "https://api.sandbox.paypal.com/v1/payments/payment/PAY-2CY489250W145633HLA3DK3Y",
' "rel": "parent_payment",
' "method": "GET"
' }
' ]
' }
' },
' {
' "capture": {
' "id": "1LY5310469661362J",
' "create_time": "2016-11-24T00:40:50Z",
' "update_time": "2016-11-24T00:40:54Z",
' "amount": {
' "total": "4.54",
' "currency": "USD"
' },
' "state": "completed",
' "parent_payment": "PAY-2CY489250W145633HLA3DK3Y",
' "transaction_fee": {
' "value": "0.43",
' "currency": "USD"
' },
' "links": [
' {
' "href": "https://api.sandbox.paypal.com/v1/payments/capture/1LY5310469661362J",
' "rel": "self",
' "method": "GET"
' },
' {
' "href": "https://api.sandbox.paypal.com/v1/payments/capture/1LY5310469661362J/refund",
' "rel": "refund",
' "method": "POST"
' },
' {
' "href": "https://api.sandbox.paypal.com/v1/payments/payment/PAY-2CY489250W145633HLA3DK3Y",
' "rel": "parent_payment",
' "method": "GET"
' }
' ]
' }
' }
' ]
' }
' ],
' "links": [
' {
' "href": "https://api.sandbox.paypal.com/v1/payments/payment/PAY-2CY489250W145633HLA3DK3Y",
' "rel": "self",
' "method": "GET"
' }
' ]
' }
outFile.Close