Transactions and Statements

Know how to manage transactions and statements of a retail co-branded credit card.

Below are the action codes to manage transactions and statements.

FETCH_ALL_TRANSACTIONS

Use this action code to fetch transactions. To fetch billed transactions, send the statementReferenceNumber parameter in the request. Without the statementReferenceNumberIt will return all the transactions starting from the unbilled ones.

{
  'accountId': 'replace_with_account_id',
  'userId': 'a5a1c639-52ca-4146-a8e4-92fdabe304af',
  'statementReferenceNumber': 'replace_with_statement_ref'
}
{
  "accountId": "12315611010000000",
  "transactionDetails": {
    "transactionId": "11921315190000050",
    "transactionDate": "2021-11-21 00:38:11",
    "transactionType": "Spend",
    "transactionStatus": "Authorised",
    "cardId": "28598783-cba0-47e0-bdd6-9ab5368fa1d8",
    "merchantName": "Amazon India",
    "channel": "ECOM",
    "mcc": "01201",
    "mid": "201567",
    "externalReferenceId": "e6ef5e95-2bab-4ec2-a7cc-4d2bbd9840ab",
    "totalAmount": 570,
    "transactionAmount": 570,
    "transactionFee": 15,
    "transactionTax": 5,
    "narration": "Burberry cuffs"
  }
}

Request Parameters

ParametersData TypeMandatory/OptionalDescription
accountIdstringMandatoryThe unique identifier of an account.
userIdstringMandatoryThe unique identifier of a user.
statementReferenceNumberstringMandatoryThe statement reference number.

Response Parameters

ParametersData TypeDescription
accountIdstringThe unique identifier of the account.
transactionDetailsobjectThe transaction details.
transactionDetails[].transactionIdstringThe transaction ID.
transactionDetails[].transactionDatestringThe transaction date.
transactionDetails[].transactionTypestringThe transaction type.
transactionDetails[].transactionStatusstringThe transaction status.
transactionDetails[].cardIdstringThe card ID.
transactionDetails[].merchantNamestringThe merchant's name.
transactionDetails[].channelstringThe transaction channel.
transactionDetails[].mccstringThe merchant category code.
transactionDetails[].midstringThe merchant's MID.
transactionDetails[].externalReferenceIdstringThe external reference ID.
transactionDetails[].totalAmountstringThe total amount.
transactionDetails[].transactionAmountstringThe transaction amount.
transactionDetails[].transactionFeestringThe transaction fee.
transactionDetails[].transactionTaxstringThe transaction tax.
transactionDetails[].narrationstringThe transaction narration.

FETCH_BILLED_TRANSACTIONS

Use this action code to fetch billed transactions of an account.

{
  'statementId': 'STAT1222'
}
{
  "statementId":"12315611010000000",
  "accountId":"12315611010000000",
  "outstandingAmount":"12315611010000000",
  "minimumAmountDue":"12315611010000000",
  "totalAmountDue":"12315611010000000",
  "statementStartDate":"12315611010000000",
  "statementEndDate":"12315611010000000",
  "dueDate":"12315611010000000",
  "transactionList":[
    {
      "transactionId":"11921315190000050",
      "transactionDate":"2021-11-21 00:38:11",
      "transactionType":"Spend",
      "transactionStatus":"Authorised",
      "cardId":"28598783-cba0-47e0-bdd6-9ab5368fa1d8",
      "merchantName":"Amazon India",
      "channel":"ECOM",
      "mcc":"01201",
      "mid":"201567",
      "externalReferenceId":"e6ef5e95-2bab-4ec2-a7cc-4d2bbd9840ab",
      "totalAmount":570,
      "transactionAmount":570,
      "transactionFee":15,
      "transactionTax":5,
      "narration":"Burberry cuffs"
    }
  ],
  "total_count":1
}

Request Parameters

HeaderData TypeMandatory/OptionalDescription
statementIdstringMandatoryThe unique identifier of a statement.

Response Parameters

ParametersData TypeDescription
statementIdstringThe unique identifier of the statement.
accountIdstringThe unique identifier of the account.
outstandingAmountstringThe outstanding amount.
minimumAmountDuestringThe minimum amount due.
totalAmountDuestringThe total amount due.
statementStartDatestringThe statement start date.
statementEndDatestringThe statement end date.
dueDatestringThe due date.
transactionDetailsobjectThe transaction details.
transactionDetails[].transactionIdstringThe transaction ID.
transactionDetails[].transactionDatestringThe transaction date.
transactionDetails[].transactionTypestringThe transaction type.
transactionDetails[].transactionStatusstringThe transaction status.
transactionDetails[].cardIdstringThe card ID.
transactionDetails[].merchantNamestringThe merchant's name.
transactionDetails[].channelstringThe transaction channel.
transactionDetails[].mccstringThe merchant category code.
transactionDetails[].midstringThe merchant's MID.
transactionDetails[].externalReferenceIdstringThe external reference ID.
transactionDetails[].totalAmountstringThe total amount.
transactionDetails[].transactionAmountstringThe transaction amount.
transactionDetails[].transactionFeestringThe transaction fee.
transactionDetails[].transactionTaxstringThe transaction tax.
transactionDetails[].narrationstringThe transaction narration.

FETCH_STATEMENTS

Use this action code to fetch a month’s credit card statement.

{
  'accountId': '{accountId}',
  'UserId': 'a5a1c639-52ca-4146-a8e4-92fdabe304af'
}
{
  "openingbalance":1000,
  "closingbalance":10000,
  "statementdate":"2022-11-21 00:00:00",
  "duedate":"2022-12-11 00:00:00",
  "creditlimit":100000,
  "availablecredit":90000,
  "pastdueamount":0,
  "purchases":9000,
  "interest":0,
  "fees":0,
  "openingdate":"2022-11-21 00:00:00",
  "closingdate":"2022-11-21 00:00:00",
  "createdtime":"2022-11-21 01:10:55",
  "transactions_array":[
    {
      "transactions_array":500,
      "transactiontype_array":"Dr",
      "transactiondescription_array":"Zomato"
    }
  ]
}

Request Parameters

ParametersData TypeMandatory/OptionalDescription
accountIdstringMandatoryThe unique identifier of an account.
UserIdstringMandatoryThe unique identifier of an account.

Response Parameters

ParametersData TypeDescription
openingbalancestringThe opening balance.
closingbalancestringThe closing balance.
statementdatestringThe statement date.
statementdatestringThe statement date.
dueDatestringThe due date.
creditlimitobjectThe credit limit.
availablecreditstringThe available credit.
pastdueamountstringThe past due amount.
purchasesstringThe purchases.
intereststringThe interest.
feesstringThe fees.
openingdatestringThe opening date.
closingdatestringThe closing date.
createdtimestringThe statement creation time.
transactions_arrayobjectThe transaction array details.
transactions_array[].transactions_arraystringThe transaction array.
transactions_array[].transactiontype_arraystringThe transaction type.
transactions_array[].transactiondescription_arraystringThe transaction description.

Related Information

Refer to the following pages for additional information about integrating retail co-branded credit cards.