VBScript Requires Chilkat v11.0.0+
VBScript
PayPal: Remove an external payment recorded on the wrong invoice
See more PayPal Examples
Use the saved external payment record ID. Verify that it belongs to the selected invoice, then remove the bookkeeping entry. The bank transfer itself is unaffected. Record it on the correct invoice as a separate step.
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
' See Unlock Chilkat before making requests.
' For the merchant's internal backoffice application. Load the sandbox token
' from the merchant's credential store. Keep it out of publicly distributed apps.
' See Get a PayPal access token.
set http = CreateObject("Chilkat.Http")
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
set resp = CreateObject("Chilkat.HttpResponse")
success = http.SetUrlVar("id","INVOICE_ID")
success = http.HttpNoBody("GET","https://api-m.sandbox.paypal.com/v2/invoicing/invoices/{$id}",resp)
If (success <> 1) Then
outFile.WriteLine("No HTTP response: " & http.LastErrorText)
WScript.Quit
End If
If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
set errorInfo = CreateObject("Chilkat.JsonObject")
success = errorInfo.Load(resp.BodyStr)
outFile.WriteLine("HTTP " & resp.StatusCode & " " & errorInfo.StringOf("name") & " " & errorInfo.StringOf("details[0].issue"))
outFile.WriteLine("PayPal debug ID: " & errorInfo.StringOf("debug_id"))
WScript.Quit
End If
set result = CreateObject("Chilkat.JsonObject")
parsedResult = result.Load(resp.BodyStr)
If (parsedResult <> 1) Then
outFile.WriteLine("Expected a JSON response; HTTP " & resp.StatusCode)
WScript.Quit
End If
paymentId = "EXTERNAL_PAYMENT_ID"
matched = 0
i = 0
Do While (i < result.SizeOfArray("payments.transactions"))
result.I = i
If ((result.StringOfEquals("payments.transactions[i].payment_id",paymentId,1) = 1) And (result.StringOfEquals("payments.transactions[i].type","EXTERNAL",1) = 1)) Then
matched = 1
End If
i = i + 1
Loop
If (matched <> 1) Then
outFile.WriteLine("This invoice has no matching external payment record.")
WScript.Quit
End If
success = http.SetUrlVar("paymentId",paymentId)
success = http.HttpNoBody("DELETE","https://api-m.sandbox.paypal.com/v2/invoicing/invoices/{$id}/payments/{$paymentId}",resp)
If (success <> 1) Then
outFile.WriteLine("No HTTP response: " & http.LastErrorText)
WScript.Quit
End If
If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
set removeError = CreateObject("Chilkat.JsonObject")
success = removeError.Load(resp.BodyStr)
outFile.WriteLine("HTTP " & resp.StatusCode & " " & removeError.StringOf("name") & " " & removeError.StringOf("details[0].issue"))
outFile.WriteLine("PayPal debug ID: " & removeError.StringOf("debug_id"))
WScript.Quit
End If
outFile.WriteLine("External payment entry removed.")
outFile.Close