getTransactionReport

Pull a transaction report.

Description

This method retrieves a report from the merchant console. Any reports, including custom reports, may be retrieved. The returned data is base 64 encoded. The format of the returned data can be HTML, comma separated (cvs), or tab separated (tab).

Names of built-in reports are prefaced with either "CreditCard:" or "Check:" For example, to pull "Sales by Date" for credit cards, the "Report" parameter would be set to "CreditCard:Sales by Date."

To pull a custom credit card or check report, prefix the name with "Custom:" or "CustomCheck:" For example, to pull a custom report titled "Recurring Declines" set the "Report" parameter to "Custom:Recurring Declines."

See also getTransactionStatus, getTransactionCustom, searchTransactions, searchTransactionsCustom, getTransaction

Syntax

string getTransactionReport ( ueSecurityToken Token, string StartDate, string EndDate, string Report, string Format )

Arguments

Type Name Description
ueSecurityToken Token Merchant security token: used to identify merchant and validate transaction.
string StartDate The earliest report date to retrieve.
string EndDate The latest report date to retrieve.
string Report Name of report to retrieve.
string Format Format of returned report data. Possible values are: html, csv, or tab.

Return Value

Type Description
string Returns specified report data according to parameters set in search.

Available Reports

Credit Card Reports
creditcard:errors by date Credit card transactions resulting in errors, sorted by date
creditcard:errors by source Credit card transactions resulting in errors, sorted by source key
creditcard:errors by reason Credit card transactions resulting in errors, sorted by reason
creditcard:errors by user Credit card transactions resulting in errors, sorted by user
creditcard:declines by date Credit card transactions resulting in declines, sorted by date
creditcard:declines by source Credit card transactions resulting in declines, sorted by source key
creditcard:declines by reason Credit card transactions resulting in declines, sorted by reason
creditcard:declines by user Credit card transactions resulting in declines, sorted by user
creditcard:sales by date Credit card transactions resulting in approval, sorted by date
creditcard:sales by source Credit card transactions resulting in approval, sorted by source key
creditcard:sales by reason Credit card transactions resulting in approval, sorted by reason
creditcard:sales by user Credit card transactions resulting in approval, sorted by user
Check Reports
check:Deposit Report Check transactions sorted by estimated deposit date
check:All Transactions by Date All Check transactions sorted by date (does not include errors)
check:settled by date Check transactions that have been marked as settled, sorted by date
check:settled by source Check transactions that have been marked as settled, sorted by source
check:settled by users Check transactions that have been marked as settled, sorted by user
check:returns by date Check transactions that have been marked as returned, sorted by date
check:returns by source Check transactions that have been marked as returned, sorted by source
check:returns by reason Check transactions that have been marked as returned, sorted by reason
check:returns by user Check transactions that have been marked as returned, sorted by user
check:declines by date Check transactions were rejected by check processor, sorted by date
check:declines by source Check transactions were rejected by check processor, sorted by sourcekey
check:declines by reason Check transactions were rejected by check processor, sorted by reason
check:declines by user Check transactions were rejected by check processor, sorted by user

Examples

PHP

For directions on how to set up the WSDL link, create "$token" and "$client", go to PHP Soap How-to.

    <?php

    try {

      $StartDate='2007/01/01';
      $EndDate='2007/04/10';
      $Format='csv';
      $Report='CreditCard:Errors By Date';

      $res=$client->getTransactionReport($token, $StartDate, $EndDate, $Report, $Format);  
      $data=base64_decode($res);
      print_r($data);

    }

    catch (SoapFault $e) {
      die("Get Transaction failed :" .$e->getMessage());
      }

    ?>

Java

This example uses the Newtek Gateway Java library. For directions on how to install the library and create the token/client objects, go to the Java JAX-WS Howto.

    try {
      String StartDate = "2009/01/01";
      String EndDate = "2009/09/09";
      String Format = "html";
      String Report = "CreditCard:Errors By Date";

      String response = client.getTransactionReport(token, StartDate, EndDate, Report, Format);

      BASE64Decoder decoder = new BASE64Decoder();
      byte[] decodedBytes = decoder.decodeBuffer(response);

      String report = new String(decodedBytes);
      System.out.println(report);
    } catch (Exception e) {
        System.out.println("Soap Exception: " + e.getMessage());
    }

.NET VB

    Dim start As String
            start = "2010-08-01"
            Dim endd As String
            endd = "2010-08-09"
            Dim format As String
            format = "html"
            Dim report As String
            report = "CreditCard:Sales By Date"

            Dim response As String
            response = client.getTransactionReport(token, start, endd, report, format)
            Dim decbuff() As Byte
            decbuff = Convert.FromBase64String(response)
            MsgBox(Encoding.UTF8.GetString(decbuff))

.NET C

For directions on how to set up the WSDL link and create the "token" and "client" variables, go to the C Sharp .Net Soap How-to.

    string start = "2010-08-01";
                string end = "2010-08-09";
                string format = "html";
                string report = "CreditCard:Sales By Date";

                try
                {
                    string response = client.getTransactionReport(token, start, end, report, format);
                    byte[] decbuff = Convert.FromBase64String(response);
                    MessageBox.Show(Encoding.UTF8.GetString(decbuff));
                }

                catch (Exception err)
                {
                    MessageBox.Show(err.Message);
                }