Transaction Statement API

The Transaction Statement API fetches the card network transactions made on the Prepaid card.

Environment


Sandbox	https://kong-pp-hexappiuat.pc.enstage-sas.com/hexappiuat/api/v2/qa/payuppi/api/onboarding/v1/transactionStatement
Production	Contact your WIBMO KAM or support.

Sample request

curl --request POST \
     --url https://kong-pp-hexappiuat.pc.enstage-sas.com/hexappiuat/api/v2/qa/payuppi/api/onboarding/v1/transactionStatement \
     --header 'X-Consumer-Custom-ID: 8654891RYY57Q0C54329BAD9C7A2DU0G1' \
     --header 'bankId: 6060' \
     --header 'clientId: 2040' \
     --header 'content-type: application/json' \
     --header 'entityId: 100' \
     --header 'secureCode: FSeAh0yFMopKgU6UNuYLk6' \
     --header 'x-api-key: 4A02C4267C9A97A1488AB3259FD1A725' \
     --data '
{
  "token": "HDrFFKWTsRmWMJ4tUArEi8wSijgmgxNT161QxEc/r2z7useq/7M2vHpV3Sp9aYhEUAeXNacwa5vNZ1mdi2nbV81kexv2q/attYu6zlGNhatmOLfwTddqIVwgASaJ6Y6+mR1CzwEJK3RwxvoUg+GUpUbfsQuIU8eT6No68eo6F7NDSnl0pfAMk5kyg3YqXb45oC+ppKua6JYX7fS5A6eeSiYcSGY7ZAmzxZlUYS951IVTx3QXR6wLFW081ZV3rVpFch2wAHs1/hI1jbCD9EdghIzcmkiyQGJUg4O3svYbSuiR9fTEIE4p1jnOo2od+GA+"
}
'

Response parameters (Decrypted)

This API will provide a token in the response that must be decrypted using the Decrypt API. The decrypted response is similar to the following:

Parameter	Type	Parameter Requirement	Description
messageCode	numeric(4)	Mandatory	Code to Identify "Transaction Statement Inquiry" API response
clientTxnId	string(100)	Mandatory	Echoed from the request
bankId	Numeric(4)	Mandatory	Value echoed from the request header.
clientId	String(15)	Mandatory	Value echoed from the request header.
responseDateTime	numeric(14)	Mandatory	Response date time in the format YYYYMMDDHHMMSS with time in 24-hour format
urn	Numeric(10)	Mandatory	Echoed from the request.
customerId	String(20)	Mandatory	Echoed from the request.
accosaTransactionId	numeric(10)	Mandatory	Unique ID for a particular transaction generated in the Prepaid system.
responseCode	string(4)	Mandatory	Represents the status of the transaction.
responseMessage	string(100)	Mandatory	Response message based on the response code.
description	String(100)	Optional	Reserved field to send information to client.
transactionDetails	Object array	Mandatory	This object array will contain the complete transaction information list.

Sample response (Decrypted)

{
    "urn": 70000000884,
    "customerId": "000000000021",
    "description": "Transaction Statement Details",
    "responseCode": "00",
    "messageCode": 3541,
    "clientTxnId": "BDO_TransactionStatement_Inquiry11",
    "clientId": "1040",
    "responseDateTime": "20231220122317",
    "accosaTransactionId": 10578,
    "responseMessage": "SUCCESS",
    "bankId": 6010,
    "transactionDetails": [
        {
            "txnId": 2089,
            "txnDateTime": "2023-09-24 12:46:02.0",
            "txnAmount": "2730.00",
            "txnType": "AUTHORIZATION_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "Merchant name",
            "mcc": "5999",
            "approvalCode": "060WN5",
            "txnCurrencyCode": "840",
            "eventId": "105010",
            "closingBal": "355.00",
            "rrn": "085001200001"
        },
        {
            "txnId": 2090,
            "txnDateTime": "2023-09-24 12:46:44.0",
            "txnAmount": "2730.00",
            "txnType": "AUTHORIZATION_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "Merchant name",
            "mcc": "5999",
            "approvalCode": "060WN6",
            "txnCurrencyCode": "840",
            "eventId": "105010",
            "closingBal": "355.00",
            "rrn": "085001200002"
        },
        {
            "txnId": 2074,
            "txnDateTime": "2023-09-24 11:59:49.0",
            "txnAmount": "234.26",
            "txnType": "ATM_CASH_WITHDRAWAL_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "MSR MERCHANT",
            "mcc": "6011",
            "approvalCode": "060H7L",
            "txnCurrencyCode": "978",
            "eventId": "130030",
            "closingBal": "0.00",
            "rrn": "085000400003"
        },
        {
            "txnId": 2092,
            "txnDateTime": "2023-09-24 12:47:21.0",
            "txnAmount": "2730.00",
            "txnType": "AUTHORIZATION_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "Merchant name",
            "mcc": "5999",
            "approvalCode": "060WN7",
            "txnCurrencyCode": "840",
            "eventId": "105010",
            "closingBal": "8350.00",
            "rrn": "085001200003"
        }
    ]
}

Error codes

Error Code	Description
WAL292	MALFORMED_REQUEST
WAL293	PRODUCT NOT ALLOWED
WAL294	SYSTEM_ERROR
WAL295	INVALID_CLIENT_CHANNEL
WAL296	OPERATION NOT ALLOWED
WAL297	IP_NOT_ALLOWED
WAL298	INVALID SECURE CODE
WAL299	CHECKSUM FAILURE
WAL264	INVALID CLIENT TXN ID
WAL300	REQUEST_DATETIME_IS_MANDATORY
WAL301	INVALID BANK ID
WAL302	BANK ID NOT PRESENT
WAL303	CLIENT ID NOT PRESENT
WAL304	XCONSUMERKEY NOT PRESENT
WAL260	INVALID MESSAGE
WAL305	SECURE CODE NOT PRESENT
WAL46	INVALID DATE FORMAT
WAL306	NO API RESPONSE DUMP AVAILABLE FOR THE CLIENT TXN ID

Request parameters