GetDailyTransactionsCSV Request

The GetDailyTransactionsCSV web service is used to obtain a list of all transactions for a merchant on a particular date in a CSV format. This is normally used for reconciliation purposes and can be called at any time. Merchants have the option to specify the transaction status(es) that they’re interested in. For example:

  • If a merchant is interested only in ‘Completed’ transactions, they can specify ‘Completed’ in the TransactionStatusCode parameter when calling the GetDailyTransactions Web Service.
  • If a merchant is interested only in ‘Completed’ and ‘ReceiptUnverified’ transactions, they can specify ‘Completed,ReceiptUnverified’ in the TransactionStatusCode parameter when calling the GetDailyTransactions Web Service.
  • If a merchant is interested in all transactions, the TransactionStatusCode parameter should be left as blank when calling the GetDailyTransactions Web Service.

The First row of the CSV is a header, containing the names of the columns.

GetDailyTransactionsCSV Request

NameType/Length/UsageExample
Date ISO 8601 Calendar Date as a string of format YYYY-MM-DD 2014-06-30
StatusCodes Comma separated list of status codes to filter by. Specifying nothing will return all transactions Completed,Initiated,Failed

GetDailyTransactionsCSV Response

FieldDescriptionData TypePossible Values
AmountPaid The actual amount paid for the transaction. Decimal
BankReceiptNo The internet banking receipt number harvested from internet banking receipt page. String Not all banks provide receipt number. This field will be null if the receipt number is unavailable.
CurrencyCode The currency of the transaction. String Possible values are commensurate with ISO Standard ISO 4217.
EndDateTime The date and time the transaction was completed. Datetime
EstablishedDateTime The date and time of the POLi™ server when the InitiateTransaction request was received. Datetime
FinancialInstitutionCode The code of the Financial Institution the payment was made from. String Consult the POLi™ Console for a complete listing of supported Financial Institutions Codes and Financial Institution Names in your country.
FinancialInstitutionName The name of the Financial Institution the payment was made from. String Consult the POLi™ Console for a complete listing of supported Financial Institutions Codes and Financial Institution Names in your country.
MerchantCode Merchant Code. String Merchant code provided by your POLi™ Implementation Manager
MerchantCommonName The merchant common name. String
MerchantData The merchant data that was passed in the InitiateTransaction request for round trip purposes. String
MerchantReference The merchant reference passed in the InitiateTransaction request. String
PaymentAmount The amount of the transaction. Decimal
TransactionRefNo The POLi ID associated with the transaction. String A unique 12 digit reference to a POLi™ transaction.
TransactionStatusCode A status code that indicates the outcome of the transaction. String
dailycsv.txt · Last modified: 2017/05/16 16:04 (external edit)