post https://payusandbox-kong.pc.enstage-sas.com/uat/sbx/api/onboarding/v3/statementInquiry
The Statement Inquiry API fetches the transactions on a wallet/card within the specified date range and the balance. This API includes the following financial and non-financial transactions:
- Financial: network transactions and wallet (load, unload, fund transfer).
- Non-financial: reset PIN, block, and unblock.
Note:
The Card Inquiry API will not provide the transaction history of the card.
| Sandbox | https://payusandbox-kong.pc.enstage-sas.com/uat/sbx/api/onboarding/v3/statementInquiry |
| Production | Contact your WIBMO KAM or support. |
Sample request
curl --request POST \
--url https://payusandbox-kong.pc.enstage-sas.com/uat/sbx/api/onboarding/v3/statementInquiry \
--header 'X-Consumer-Custom-ID: F42BC4E7B801C834B630DE498473533F' \
--header 'bankId: 6060' \
--header 'clientId: 1060' \
--header 'content-type: application/json' \
--header 'entityId: 100' \
--header 'secureCode: pu8gSMLNE7pNv36IlUmstU' \
--header 'x-api-key: 4A02C4267C9A97A1488AB3259FD1A725' \
--data '
{
"token": "PvLNIjKAREzAVW6+GKpbcmtepBQ5LfPNuRoVWhf0oyBaFYFDSCY9LxfrGa39nj7Ff0wnoj4L31uFU2kXrc/WSeTuURE4CGm4Lgzl61DHQLQQ8n4Gcm25YE8UQaHBJsQwugGMWUmIw3yrtRpKS1b0z679bLT1wtaFjF2TvUbXfI0e/0AGd/4WvbvcDChXQ6LUIFC80mxjinbTp6V4CYgIxCP0O7zaZYJ8I1nput5ZiV9WbWHR9CroIWe7Cs108Y2jD+mbyUAXKP4C3IqySZCQqNVqrf9ev6GWNZvx5aN9Af5Rlh+wh7VFyvvNXZGd/SrdDUDCPNIjAvLYlwVkunKovsnnl+wVNBIcVkB06O/K9JfBoJIl3u2BhbRwCg7MD89s"
}
'
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 (Decrypted)
| Error Code | Description |
|---|---|
| 00 | SUCCESS |
| 1001 | CARD_NOT_FOUND |
| 1030 | INVALID MESSAGE COD |
| 1031 | INVALID BANK ID |
| 1032 | INVALID_CLIENT_CHANNEL |
| 1049 | INVALID SECURE CODE |
| 1052 | SYSTEM_ERROR |
| 1055 | MALFORMED_REQUEST |
| 1056 | INVALID MESSAGE CODE |
| 1081 | OPERATION NOT ALLOWED |
| 1083 | URN AND LAST 4 DIGITS MISMATCH |
| 1084 | URN AND CUSTOMER ID MISMATCH |
| 1085 | REQUESTOR UNAUTHORIZED FOR URN OR PRODUCT |
| 1088 | INVALID DATE format |
| 1093 | INVALID CLIENT TXN ID |
| 1116 | CARD AML PROFILE MISSING |
| 1262 | CLIENT ID NOT PRESENT |
| 1264 | BANK ID NOT PRESENT |
| 1310 | XCONSUMERKEY NOT PRESENT |
| 1311 | SECURE CODE NOT PRESENT |
| 1320 | REQUEST_DATETIME_IS_MANDATORY |
| 1346 | URN_IS_MANDATORY |
| 1500 | SYSTEM ERROR |
| 1501 | SYSTEM ERROR(DB) |
| 1501 | SYSTEM ERROR |
| 5003 | CLIENT_NOT_CONFIGURED_UNDER_BANK_ID |
| 9329 | LAST 4 DIGITS IS MANDATORY |
| 9343 | CLIENT TXN ID IS MANDATORY |
| 9344 | FROM DATE CANNOT BE GREATER THAN TO DATE |
| 9345 | DIFFERENCE BETWEEN FROM DATE AND TO DATE GREATER THAN DEFINED IN DB |
| 10108 | CUSTOMER ID MISSING |