Get Cardholder Transaction History
Action: POST
Endpoint: /api/CoreCredit/Transactions/GetCHTransactionHistory
Use this API is to bring monetary transactions posted on the account. Multiple filters can be used to fetch records based on date range, transaction ID, minimum transaction amount, maximum transaction amount, and transaction type with values as all transactions, settled transactions, outstanding transactions, expired transactions, unbilled transactions etc.
Request fields details
Fields | Description |
---|---|
Source string Mandatory |
Source of API Consumer For external system expected sources will be WEB. Allowable Values: 50 |
IPAddress string Optional |
IP Address of Client / Application Hosting Server Example: 10.206.0.204 Allowable Values: 15 |
DateFormat string Optional |
Place Holder for Future Use. Values are: 1 : MM/dd/yyyy HH:MM:SS (Default) 2 : MM/dd/yy HH:MM:SS 3 : dd/MM/yyyy HH:MM:SS Allowable Values: 25 |
CurrencyCode string Optional |
Currency Code Place Holder for Future Use. Valid Values: Refer Appendix Section - Currency Code Example:840 = US Dollar Condition:If no value is passed, default value = 840 Allowable Values: 10 |
CurrencySymbolType string Optional |
Place Holder for Future Use. CurrencySymbolType: 1: Currency Sign like $ 2: 3 ALPHA Currency Code like USD Allowable Values: 10 |
Language string Optional |
Place Holder for Future Use. Language: en: means use English Default: en - English Allowable Values: 10 |
ExternalIP string Mandatory |
IP Address of end user of API Allowable Values: 50 |
SessionID string Optional |
Session identifier of the API Example: 000028;026;1349906692 Allowable Values: 100 |
APIVersion string Mandatory |
Version of the API to be invoked. Example: 2.0 API Version Current Version 2.0 Allowable Values: 10 |
CallerID string Optional |
Caller ID of source from where API is initiated it is End User Caller ID Example: 7204454214 (phone number applicable in Case of IVR) Allowable Values: 20 |
CalledID string Optional |
Called ID of destination for which API is initiated It is Destination Called ID Example: 7314145404 (phone number applicable in Case of IVR) Allowable Values: 20 |
RequestTime datetime Optional |
Request Date Time of API Format: MM/dd/yyyy HH:mm:ss Example:01/15/2020 10:05:23 |
AccountNumber string Conditional |
Card Holder's Account Number. Valid Values: 0-9 Format:XXXXXXXXXXXXXXXX Example:1236547896325874 Condition:At least one of AccountNumber/AccountID is required. Allowable Values: 19 |
AdminNumber int64 Optional |
Admin Number. Valid Values:0-9 Example:7485122 |
AccountID integer Conditional |
Account ID represents Unique Identity of Account (CoreCard Bsegment Entitity, i.e., the Account ID of program card account). Valid Values:0-9 Example:7485122 Condition:At least one of AccountNumber/AccountID is required. |
FromDate datetime Optional |
Starting date of Transaction search. Valid Values:01/15/2020 Format: MM/dd/yyyy HH:mm:ss Example:01/15/2020 10:05:23 |
ToDate datetime Optional |
End date of Transaction search. Valid Values:01/15/2020 Format: MM/dd/yyyy HH:mm:ss Example:01/15/2020 10:05:23 |
TransactionType string Optional |
Type of Transaction. Valid Values:0 = All,1 = ATM,3 = Fees,4 = Purchase,7 = Transfers,8 = Disputed,9 = Payments,10 = Payment Example:Fees/Purchase/ATM. Allowable Values: 2 |
TransactionID int64 Optional |
Transaction ID of a Transaction. Example:8574152. |
TransactionHistoryType integer Mandatory |
Type of Transaction's History. Valid Values:1,2,3,4,5 Example:0=All,1 = Settled, 2 = OutStanding , 3 = Expired, 4 = Warehoused , 5 = Unbilled |
Merchant string Optional |
Name of the Merchant. Valid Values:a-z,0-9 Example:Wallmart Allowable Values: 50 |
MinTransactionAmount decimal Optional |
Minimum Transaction Amount on the Account. Valid Values:0-9 Example:200.00 |
MaxTransactionAmount decimal Optional |
Maximum Transaction Amount on the Account. Valid Values:0-9 Example:200.00 |
BatchSize integer Optional |
Number of Transaction which can be view in one Batch. BatchSize can have value 1-100,On the basis of PageIndex and BatchSize paging will be done. BatchSize can not exceed 100. Default Batch Size should be 100. Valid Values:0-100 Example:10,50. |
PageIndex integer Optional |
Number of page. PageIndex can not exceed 999. Valid Values:0-999 Example:1. |
IdentifierToken string Conditional |
A generated token that is not expired can be used as an input field to access API. If we are passing this field in input, user should not pass any other account identifier. Condition:At least one account identifier is required. Allowable Values: 800 |
AMEXTID string Optional |
A unique number given by the Network to identify a Cardmember Transaction throughout its life cycle. Valid Values: 0-9 Format: 999999999999999 Allowable Values: 15 |
TransactionLifeCycleUniqueID string Optional |
Lifecycle Transaction ID of a Transaction.This is the unique id for all types of transactions including dispute, clearing, reversal etc. Valid Values: 0 - 9,a-z Format: 0000xxxx Allowable Values: 25 |
CurrentAdminNumber integer Optional |
CurrentAdminNumber Valid Values: 0 - 9,a-z Format: 0000xxxx |
Sample request body
{ "Source": "Web", "IPAddress": "10.120.0.1", "DateFormat": null, "CurrencyCode": null, "CurrencySymbolType": null, "Language": null, "ExternalIP": "10.120.0.0", "SessionID": null, "APIVersion": "2.0", "CallerID": null, "CalledID": null, "RequestTime": null, "AccountNumber": "9000000900000010", "AdminNumber": null, "AccountID": 87307, "FromDate": null, "ToDate": null, "TransactionType": null, "TransactionID": null, "TransactionHistoryType": 1, "Merchant": null, "MinTransactionAmount": null, "MaxTransactionAmount": null, "BatchSize": 50, "PageIndex": 0, "IdentifierToken": null, "AMEXTID": "253652365985632", "TransactionLifeCycleUniqueID": "123372036855012417", "CurrentAdminNumber": 0 }
Response fields details
Fields | Description |
---|---|
TotalRecordCount integer |
Total No of records. |
TransactionHistoryList array |
Transaction History List. |
Sample response body
{ "Message": "Success", "Status": true, "ErrorCode": "Err00017", "ResponseData": { "AvailableBalance": 0.0, "CurrentBalance": 0.0, "LastTransactionDate": null, "LastCreditDate": null, "LastCreditAmount": 0.0, "LastPaymentDate": null, "LastPaymentAmount": 0.0, "TotalRecordCount": 1, "TransactionHistoryList": [ { "ReturnReasonCode": "", "CardAcceptorNameAndLocation": "", "MerchantNameAndLocation": "Demo A", "TimeZone": "", "TransactionID": "117675465", "AuthTranID": null, "TransactionDateTime": "03/31/2016 00:00:00", "TransactionPostTime": "03/31/2016 00:00:00", "TransactionAmountCurrencyCode": "840", "TransactionAmount": -5.0, "AccountNumber": "9000000900000010", "PostingFlag": "", "PostingReference": "Transaction posted successfully", "TransactionSource": "Clearing", "TransactionDescription": "454304 = DISPUTE RELEASE - (NO INTEREST/CHG FEE)", "CurrentBalance": -679.79, "ExternalResponseCode": "", "IsDeclined": false, "HoldAmount": 0.0, "TransactionHistoryType": "Settled", "ReverseFlag": true, "ResubmitChargebackFlag": 0, "CardNumberLast4Digit": "6392", "ProductBIN": "525751", "EffectiveDate": null, "AdminNumber": 98385, "ServiceResponsecode": "", "ServicepostingReference": "", "InternalTranCode": "454304", "InternalTranCodeDesc": "DISPUTE RELEASE - (NO INTEREST/CHG FEE)", "RaiseDisputeFlag": false, "DisputeStatus": "", "DisputeStatusDesc": null, "AllowOutstandingClearing": false, "CardType": "Primary Card", "AuthCategory": "", "MerchantType": "", "MerchantName": null, "MerchantCategoryCode": null, "PlanMaster": 21701, "InvoiceNumber": "", "ChangePlanFlag": false, "ADCInternalResponseCode": "", "ApprovalCode": "", "AVSDataindicator": false, "SentResponseCode": "", "BatchNumber": 0, "TransmissionDateTime": "03/31/2016 00:00:00", "IsDisputedTransaction": false, "DisputeAllowedViaSS": false, "IsFees": false, "IsCharges": false, "IsCredit": true, "IsDebit": false, "TokenWalletID": "", "DisputeAmount": null, "PaymentTranId": null, "TokenTransaction": "", "TokenRequesterID": "", "RewardPoints": 0.0, "AuthRewardPoints": null, "PaymentReferenceID": "", "BankNameAccount": "", "SendChargebackFlag": false, "ResolveDispute": false, "CancelDispute": false, "DisputeReason": null, "DisputeOTBReleaseFlag": 0, "VROLCaseNumber": null, "CardPresenceIndicator": 1, "PreAuthTimestamp": null, "LocalTransactionCurrencyCode": "840", "CardholderBillingCurrencyCode": "840", "SettlementCurrencyCode": "840", "CardholderBillingAmount": 100.0, "TransactionSourceAmount": 100.0, "HoldStatus": null, "HoldReleaseDate": null, "TransactionLifeCycleUniqueID": null, "AcquirerReferenceNumber": null, "SchemeTransactionID": null, "MerchantFraudScore": null, "STIPTransaction": null, "AMEXTID": "253652365985632", "ECIUCAFIndicator": null, "CardSequenceNumber": 12, "IsSafeReported": null, "TransactionFraudStatus": null, "ThirdPartyFraudAction": null, "ThirdPartyFraudScore": null } ] } }