Sample code for 30+ languages & platforms
VBScript Requires Chilkat v11.0.0+

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.

PayPal documentation

Chilkat VBScript Downloads

VBScript
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