POST Get Transaction Summary
You retrieve a summary of transactions by sending an HTTP POST request with the required information to the /get_summary endpoint.
Endpoint: /get_summary
Request Body Payload Example
The request body includes the following parameters:
| PARAMETER |
DESCRIPTION |
TYPE |
SIZE |
MANDATORY |
DEFAULT VALUE |
currency_from |
Specify a currency ID to filter transactions that have only used a specific from currency. |
Varchar |
10 |
No |
- |
bank_id_from |
Specific a home/company bank ID to filter transactions for that specific bank account. |
Integer |
- |
No |
- |
ref_number |
Specify a batch (B) or transaction (T) number to filter transactions associated with that B or T number. If included, this field cannot be left blank. Must contain a T or B followed by at least 6 digits. |
Varchar |
20 |
No |
- |
username |
Specify a user name to filter transactions associated with that user. |
Varchar |
20 |
No |
- |
beneficiary |
Specific a beneficiary ID to filter transactions for that beneficiary. |
Integer |
- |
No |
- |
reconciliation_id |
Apply a full or partial case-sensitive search on the stored client_data field. This field is used in combination with other search parameters (such as bank_id_from or beneficiary) for optimum performance. |
Varchar |
- |
No |
- |
date_from |
Specify a date (in the format dd/mm/yyyy) to filter transactions that occurred after that date. |
Date |
- |
No |
- |
date_to |
Specify a date (in the format dd/mm/yyyy) to filter transactions that occurred before that date. |
Date |
- |
No |
- |
transactions_statuses |
Specify one or more status values to use to filter transactions. See Payment Status Code for possible values. |
List/Integer |
- |
No |
- |
client_transaction_id |
Specify a client_transaction_id to filter transactions associated with that client_transaction_id. If this field is used, other fields in the request will be ignored. Max number of IDs that can be input is 30. If you require the full list, please use the batch number. |
Varchar |
- |
Yes |
- |
Example Request
An example of a request with just the ref_number:
{
"ref_number": "B544748"
}
An example of a request with multiple TID's:
{
"ref_number": "T3587618, T3587619, T3587620"
}
An example of a request with date, to and from, and the id of the origin bank:
{
"bank_id_from": "45240",
"date_from": "01/01/2022",
"date_to": "30/01/2022"
}
An example of a request searching for specific status:
{
"transactions_statuses": [
1,
6
]
}
An example of a request searching for ONE specific status:
{
"transactions_statuses": 6
}
An example of a request searching for a certain client:
{
"client_transaction_id": "12345678"
}
Response Body Payload Example
If the request is successful, the response includes the following parameters:
| FIELD |
DESCRIPTION |
TYPE |
transactions |
A list of one or more payment transactions. |
List |
benef_id |
The ID of the beneficiary. |
Varchar |
payee_name |
The name of the beneficiary. |
Varchar |
t_datetime_submitted |
The date and time at which the transaction was submitted. |
Varchar |
foreign_amount |
The amount to be paid in the source bank's currency. |
Varchar |
currency_rate_per_unit |
The currency exchange rate and its inverse. |
Varchar |
amount_from_ben_fee |
The amount on which the transaction fee is based. |
Decimal |
fee |
The fee for the payment transaction. |
Decimal |
total_trans_amount_from |
The total amount for the transaction, which includes the transaction fee. |
Decimal |
reference |
A reference for the payment transaction. |
Varchar |
tran_type |
The payment transaction type. See Payment Method/Transaction Type Values for possible values. |
Varchar |
bene_payment_type |
The beneficiary payment type. See Payment Method/Transaction Type Values for possible values. |
Varchar |
batch_ref_num |
The reference number of a batch process into which several payment transactions are combined. |
Varchar |
ref_num |
The reference number of a payment transaction. |
Varchar |
payment_status |
The status of a payment transaction. See Payment Status Codes for possible values. |
Varchar |
payment_status_abrv |
An abbreviation of the payment status. |
Varchar |
client_data |
A custom statement associated with the payment transaction. |
Varchar |
client_id |
A unique alpha-numeric string which may be given in order to identify the beneficiary account. |
Varchar |
user_uid |
The client_transaction_id which may be passed in at the time of booking. This is a unique alpha-numeric string to identify the transaction. |
Varchar |
metadata |
A list of metadata associated with the batch payment transaction. |
List |
batch_sum_details |
A text description that summarizes the batch transaction. |
Varchar |
usr_bank_from_data |
A text description that summarizes the source bank account information. |
Varchar |
transfer_type |
The type of payment transaction. |
Varchar |
currency |
The currency of the payment transaction. |
Varchar |
amount |
The payment transaction amount with currency indicated. |
Varchar |
particular |
A custom statement associated with the batch payment transaction. |
Varchar |
account_name |
The name of the source bank account. |
Varchar |
bank_name |
The name of the source bank. |
Varchar |
bank_country |
The country of the source bank. |
Varchar |
account_number |
The source bank account number. |
Varchar |
transit_code |
The transit code. See Transit Code Values for possible values. |
Varchar |
swift |
The SWIFT or Bank Identification Code (BIC) of the source bank account. |
Varchar |
ref_number |
The reference number of the batch in which multiple payment transactions are included for approval. |
Varchar |
Example Success Response
An example of the JSON structure in the response is as follows. In this case, the request returns all transactions that have a batch_ref_num value of B544748.
{
"transactions": [
{
"benef_id": "231426",
"payee_name": "China Beneficiary 1003",
"t_datetime_submitted": "2022-01-11 09:52:00",
"foreign_amount": "USD 2106.00",
"currency_rate_per_unit": "0.77352",
"amount_from_bef_fee": "CAD 2722.62",
"fee": "5.00",
"total_trans_amount_from": "CAD 2727.62",
"reference": "tst ref 246",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": "B544748",
"ref_number": "T784880",
"payment_status": "Awaiting Funds",
"payment_status_abrv": "pending",
"client_data": "Some Reconcile Ident",
"user_uid": "123456"
},
{
"benef_id": "231427",
"payee_name": "China Beneficiary 963",
"t_datetime_submitted": "2022-01-11 09:52:00",
"foreign_amount": "USD 2107.00",
"currency_rate_per_unit": "0.77352",
"amount_from_bef_fee": "CAD 2723.91",
"fee": "5.00",
"total_trans_amount_from": "CAD 2728.91",
"reference": "tst ref 246",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": "B544748",
"ref_number": "T784881",
"payment_status": "Awaiting Funds",
"payment_status_abrv": "pending",
"client_data": "Some Reconcile Ident 2",
"user_uid": null
}
],
"metadata": [
{
"batch_sum_details": "Domestic Amount: CAD 5,456.53 Reference Number: B544748",
"usr_bank_from_data": "Wire Transfer from your bank account: Bank Name: TORONTO DOMINION BANK Bank Country: Canada Account Number: 1xxxxxx-xx11 Transit Number & Institution Number: 0xx-xxxx-xx60 SWIFT/BIC Code: Txx-xxxx-xxOR Currency: CAD",
"transfer_type": "Country Local Bank Transfer",
"currency": "CAD",
"amount": "CAD 5456.53",
"particular": "Mr Test Test",
"account_name": "Interpay Ltd",
"bank_name": "ROYAL BANK OF CANADA",
"bank_country": "Canada",
"account_number": "1071596",
"transit_code": "000306702",
"swift": "ROYCCAT2",
"ref_number": "B544748"
}
]
}
The following is a second example. In this case, the request returns transactions where the source bank ID, bank_id_from is 45240 and the transaction date is between September 1 and September 30, 2018.
{
"transactions": [
{
"benef_id": "231426",
"payee_name": "China Beneficiary 1003",
"t_datetime_submitted": "2022-01-11 09:52:00",
"foreign_amount": "USD 2106.00",
"currency_rate_per_unit": "0.77352",
"amount_from_bef_fee": "CAD 2722.62",
"fee": "5.00",
"total_trans_amount_from": "CAD 2727.62",
"reference": "tst ref 246",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": "B544748",
"ref_number": "T784880",
"payment_status": "Awaiting Funds",
"approve": null,
"payment_status_abrv": "pending",
"client_data": "Some Reconcile Ident",
"user_uid": null
},
{
"benef_id": "231427",
"payee_name": "China Beneficiary 963",
"t_datetime_submitted": "2022-01-11 09:52:00",
"foreign_amount": "USD 2107.00",
"currency_rate_per_unit": "0.77352",
"amount_from_bef_fee": "CAD 2723.91",
"fee": "5.00",
"total_trans_amount_from": "CAD 2728.91",
"reference": "tst ref 246",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": "B544748",
"ref_number": "T784881",
"payment_status": "Awaiting Funds",
"approve": null,
"payment_status_abrv": "pending",
"client_data": "Some Reconcile Ident 2",
"user_uid": null
},
{
"benef_id": "197279",
"payee_name": "Singapore Beneficiary 1",
"t_datetime_submitted": "2022-01-11 11:02:00",
"foreign_amount": "USD 428.00",
"currency_rate_per_unit": "0.77173",
"amount_from_bef_fee": "CAD 554.60",
"fee": "15.00",
"total_trans_amount_from": "CAD 569.60",
"reference": "api ref 98",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": null,
"ref_number": "T763646",
"payment_status": "Awaiting Authorization",
"approve": "\n ",
"payment_status_abrv": "await_auth",
"client_data": "Immedis59",
"user_uid": null
}
],
"metadata": []
}
The following is a third example. In this case, the request returns transactions where the status matches the status sent in the call, "transactions_statuses" : [1, 6], Awaiting Funds and Cancelled by approver.
{
"transactions": [
{
"benef_id": "489337",
"payee_name": "Dupe Harryp",
"t_datetime_submitted": "2022-01-11 09:51:00",
"foreign_amount": "EUR 103.00",
"currency_rate_per_unit": "0.88979",
"amount_from_bef_fee": "USD 115.76",
"fee": "10.00",
"total_trans_amount_from": "USD 125.76",
"reference": "api ref 8",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": "B954972",
"ref_number": "T1554224",
"payment_status": "Awaiting Funds",
"approve": null,
"payment_status_abrv": "pending",
"client_id": "225523",
"client_data": "6300fb78-fa97-4f2a-9b6e-1028199a35ea",
"user_uid": null
},
{
"benef_id": "483809",
"payee_name": "Boris Bene",
"t_datetime_submitted": "2022-01-11 08:55:00",
"foreign_amount": "GBP 500.00",
"currency_rate_per_unit": "0.90358",
"amount_from_bef_fee": "EUR 553.35",
"fee": "0.00",
"total_trans_amount_from": "EUR 553.35",
"reference": "Bill Payment",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": null,
"ref_number": "T1554071",
"payment_status": "Cancelled by approver",
"approve": null,
"payment_status_abrv": "cancelled_by_approver",
"client_id": null,
"client_data": null,
"user_uid": null
}
],
"metadata": []
}
The following is a fourth example. In this case, the request returns transactions where the status matches the status sent in the call, "transactions_statuses" : 6, Cancelled by approver.
{
"transactions": [
{
"benef_id": "483809",
"payee_name": "Boris Bene",
"t_datetime_submitted": "2022-01-11 08:55:00",
"foreign_amount": "GBP 500.00",
"currency_rate_per_unit": "0.90358",
"amount_from_bef_fee": "EUR 553.35",
"fee": "0.00",
"total_trans_amount_from": "EUR 553.35",
"reference": "Bill Payment",
"tran_type": "Wire Transfer",
"bene_payment_type": "Wire Transfer",
"batch_ref_num": null,
"ref_number": "T1554071",
"payment_status": "Cancelled by approver",
"approve": null,
"payment_status_abrv": "cancelled_by_approver",
"client_id": null,
"client_data": null,
"user_uid": null
}
],
"metadata": []
}
Example Error Responses
If the get transaction summary request is not successful, the service responds with an error code, rejects the request, and does not return any transaction data. An example error response is provided.
The JSON structure associated with the error responses has the following parameters:
| FIELD |
DESCRIPTION |
TYPE |
stat |
A status message that describes the error encountered. |
Varchar |
Error Code 200 - No data
{
"stat": "no data for given search criteria"
}