C# Requires Chilkat v11.0.0+

PayPal: Reconcile a transaction ID in a reporting window

See more PayPal Examples

Supply the reporting transaction ID and a window containing the activity. Return all matches: transaction IDs are not necessarily unique in the report. Include non-balance-affecting records when reconciling an event.

PayPal documentation

C#

bool success = false;

//  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.
Chilkat.Http http = new Chilkat.Http();
http.AuthToken = "SANDBOX_ACCESS_TOKEN";
Chilkat.HttpResponse resp = new Chilkat.HttpResponse();
//  Use the UTC window containing the transaction (at most 31 days per request).
Chilkat.CkDateTime dt = new Chilkat.CkDateTime();
dt.SetFromCurrentSystemTime();
Chilkat.JsonObject query = new Chilkat.JsonObject();
query.UpdateString("end_date",dt.GetAsTimestamp(false));
dt.AddDays(-1);
query.UpdateString("start_date",dt.GetAsTimestamp(false));
query.UpdateString("fields","transaction_info");
query.UpdateInt("page_size",100);
query.UpdateString("transaction_id","REPORT_TRANSACTION_ID");
query.UpdateString("balance_affecting_records_only","N");
int page = 1;
int lastPage = 1;
while ((page <= lastPage)) {
    query.UpdateInt("page",page);
    success = http.HttpParams("GET","https://api-m.sandbox.paypal.com/v1/reporting/transactions",query,resp);
    if (success != true) {
        Debug.WriteLine("No HTTP response: " + http.LastErrorText);
        return;
    }

    if ((resp.StatusCode < 200) || (resp.StatusCode >= 300)) {
        Chilkat.JsonObject errorInfo = new Chilkat.JsonObject();
        errorInfo.Load(resp.BodyStr);
        Debug.WriteLine("HTTP " + Convert.ToString(resp.StatusCode) + " " + errorInfo.StringOf("name") + " " + errorInfo.StringOf("details[0].issue"));
        Debug.WriteLine("PayPal debug ID: " + errorInfo.StringOf("debug_id"));
        return;
    }

    Chilkat.JsonObject result = new Chilkat.JsonObject();
    bool parsed = result.Load(resp.BodyStr);
    if (parsed != true) {
        Debug.WriteLine("Expected a JSON response; HTTP " + Convert.ToString(resp.StatusCode));
        return;
    }

    int i = 0;
    int count = result.SizeOfArray("transaction_details");
    while ((i < count)) {
        result.I = i;
        Debug.WriteLine(result.StringOf("transaction_details[i].transaction_info.transaction_id") + "  " + result.StringOf("transaction_details[i].transaction_info.transaction_event_code")
             + "  " + result.StringOf("transaction_details[i].transaction_info.transaction_status"));
        Debug.WriteLine("  " + result.StringOf("transaction_details[i].transaction_info.transaction_amount.value") + " " + result.StringOf("transaction_details[i].transaction_info.transaction_amount.currency_code"));
        i = i + 1;
    }

    lastPage = result.IntOf("total_pages");
    page = page + 1;
}