Reporting APIs

Version

Current Specification Version: V7.1.0

View Change History

General Information


Overview  

The purpose of this document is to provide documentation for 3rd parties to integrate with UniCharge reporting module.

Connectivity Information  

The connection URL for the sandbox server is: https://[server-name]/reports/[report-name].[report-format]?[parameters], where
  • [report-name] is a name of a report;
  • [report-format] - format in which the report is generated, see integration notes for more information;
  • [parameters] - fields in the report request, indicating what data is going to be included in the report.

For example, to generate a merchant-statement-list report in the CSV format, connection URL should look similar to the following one:
https://[server-name]/reports/merchant-statement-list.csv?userName=myUsername&password=myP%40ssword&fromDate=10180101&toDate=20180131&accountId=2001

Authorization is done via service users. To access the API, a service user is required to be granted with a corresponding privilege. A user can submit API requests using either associated credentials or temporary password generated via authentication operation. See Security Management guide for more information.

Request method is GET. The content-type must be set to application/x-www-form-urlencoded.
Request fields are passed within HTTPS request body (including cases with callbacks) and are required to be URL-encoded.
Response fields are passed within HTTPS response body.
Both request and response field values are passed using name1=key1&name2=key2 format.

Supported Reports

Database Export

statement-list   
Corresponds to StatementListExport database table. The table contains general information about merchant statements including submissions, fees, reserves, splits, etc.
statement-detail-list   
Corresponds to StatementDetailListExport database table. The table contains the full information about each statement including amounts of submissions, declines, returns, chargebacks, credits, voids, blacklisted transactions for all brands, fees, and statement adjustments
statement-fee-detail-list   
Corresponds to StatementFeeDetailListExport database table. The table contains information about all fee amounts and rates present in the merchant statements.
transaction-list   
Corresponds to TransactionListExport database table. The table contains information about transaction totals for all transaction types and brands for a particular account and related fees amounts.
data-registry   
Corresponds to DataRegistryExport database table. The table contains information about each record (i.e. merchant statement) generated and exported by the gateway, such as it’s data type, associated entities’ identifiers, and dates.

merchant-statement-list   
Provides all merchant statements associated with the specified account. The report is uzed to analyze all fees and deposits processed by the account within a specified date range. Generated in CSV and data formats.
merchant-statement   
Provides a deposit or reconciliation statement associated with the specified statement identifier. Generated in PDF format.
reseller-statement-list   
Provides all reseller statements associated with the specified reseller. The report is used to analyze all fees and deposits processed by the merchants/accounts under the reseller within a specified date range. Generated in CSV and data formats.
reseller-statement   
Provides a reseller statement with aggregated information across all merchants associated with a particular reseller. Generated in PDF format.
reseller-statement-breakdown   
Provides a reseller statement with information for one merchant associated with the specified reseller. Generated in PDF format.
deposit-list   
Provides a list of deposits received by the account within a specified date range. Generated in CSV and data formats.
transaction-list   
Provides a list of transactions associated with the specified account. Generated in CSV and data formats.
transaction-list~related   
Provides a list of the related transactions associated with the specified one. Generated in CSV and data formats.
Note: This report is available for Vantiv Tandem and TrustCommerce processors only.

transaction-receipt   
Provides a gateway-generated receipt associated with the specified transaction identifier. Generated in PDF format.
terminal-list   
Provides a list of terminals associated with the specified reseller or account. Generated in CSV and data formats.
split-list   
Provides a list of split transactions associated with the specified account. The report is available for the transactions that are not older than 92 days. Generated in CSV and data formats.

Message Formats


Usage:

R - required in request/always present in response for direct debit transactions and credit card transactions of all levels (I, II, III).
O - optional in request/not always present in response.
C - conditional; conditions of the usage are defined below the corresponding section.
E - echo back from request; if present in request, it is present in response, if it is not present in request, it is not present in response.
R2 - required in request/always present in response for credit card transactions of level II and III only; optional for direct debit and level I credit card transactions.
R3 - required in request/always present in response for credit card transactions of III only; optional for direct debit and level I, II credit card transactions.
SR - required in request/always present in response for split transactions only.
I - for internal use only.
N - not used.
* - required fields in these specific sections are only required if this specific feature is used.