BI Search Transactions (Synchronous)

Gather Business Insights (BI) by analyzing the transactions for a Business Account and its Child Business Accounts.

Use this API to search transactions based on filters such as the transaction type, status, and amount. The API returns an array of transactions based on the provided filters.

Note  The search is limited to the Business Account associated with the request access token. To include the Business Account’s Child Business Accounts, set nestedTransactions to true.

Endpoint

POST /v1/search/sync/transactions

Authorization Header

Authorization: Bearer <access_token>

Query Parameters

filter

object

Search filters.

pageNumber  REQUIRED

integer (int32)

Page number to return, based on zero-based page indexing.

pageSize  REQUIRED

integer (int32)

Maximum number of results to return per page.

nestedTransactions  REQUIRED

boolean

Whether to include Child Business Accounts in the search.

  • If false, only the Business Account associated with the request access token will be included.
  • If true, all Child Business Accounts of the Business Account associated with the request access token will also be included.

solution

string enum, values: PUSH_TO_CARD, ACH, ADJUSTMENT, TRANSFER

RocketKOR solution. This filter will return transactions created for the specified solution.

fromFinancialAccount

array of strings (UUID)

List of Financial Account IDs for the debit account (the source of funds) for a transaction. This filter will return transactions with these Financial Accounts as the credit account.

toFinancialAccount

array of strings (UUID)

List of Financial Account IDs for the credit account (the destination account) for a transaction. This filter will return transactions with these Financial Accounts as the credit account.

fromCreatedAt

string (date), format: yyyy-MM-dd

Date the transaction was created in the RocketKOR system. This filter will return transactions created on or after this date.

toCreatedAt

string (date), format: yyyy-MM-dd

Date the transaction was created in the RocketKOR system. This filter will return transactions created on or before this date.

fromAmount

number

Transaction amount. This filter will return transactions with an amount equal to or greater than this amount.

toAmount

number

Transaction amount. This filter will return transactions with an amount equal to or less than this amount.

transactionStatus

string enum, values: NEW, PENDING, PROCESSING, APPROVED, SETTLED, CLEARED, DECLINED, ERROR

Transaction status. The following values are supported:

  • NEW  The transaction has been created in RocketKOR.
  • PENDING  The transaction has been moved from the Transaction Domain to one of the Processing Domains. The transaction is still in the RocketKOR system (meaning it has not been transmitted to the Provider for processing) and is in a state where it can be cancelled.
  • PROCESSING  One of the following is true: (a) the transaction is in a Processing Domain in the RocketKOR system but can no longer be cancelled, or (b) the transaction has been transmitted to the Provider for processing.
  • APPROVED  Disbursement has been approved by the Provider.
  • SETTLED  The transaction has been settled by the Provider.
  • CLEARED  The Sponsor has indicated that funds movement for the transaction is complete. The funds are now available in the Master Settlement Account (MSA). This status is only applicable to “received” transactions.
  • DECLINED  Disbursement has been declined by the Provider.
  • ERROR  The transaction could not be processed due to one or more errors (for example, the Provider system is unavailable after a number of retries). The Error status is only activated after RocketKOR determines that it cannot continue processing the transaction.

transactionType

string enum, values: SEND, REQUEST, DEPOSIT, WITHDRAWAL, REVERSAL, RETURN, ADJUSTMENT

Type of transaction. The following values are supported:

  • SEND  Push funds from the debit Financial Account to the credit Financial Account. For example, a SEND transaction would be used if a Business Account (owner of the debit Financial Account) is sending a refund to a Customer (owner of the credit Financial Account).
  • REQUEST  Pull funds to the credit Financial Account from the debit Financial Account. For example, a REQUEST transaction would be used if a Business Account (owner of the credit Financial Account) is collecting a rent payment from a Customer (owner of the debit Financial Account).
  • DEPOSIT  Push funds into a Financial Account where the push is originated outside RocketKOR.
  • WITHDRAWAL  Pull funds from a Financial Account where the pull is originated outside RocketKOR.
  • REVERSAL  A transaction created by RocketKOR to reverse a SETTLED or CLEARED transaction.
  • RETURN  A RETURN transaction cancels the original transaction.
  • ADJUSTMENT  An ADJUSTMENT transaction is used to correct a human or system error with a transaction or to record a transaction that originated outside of RocketKOR.

Request Body

None

Returns

Returns a paginated response with an array of BI Transaction objects.

SAMPLE RESPONSE

				
					{
  "totalPages": 10,
  "page": 0,
  "totalVolume": 100, // total number of transactions matching the search criteria
  "totalValue": 3200.50, // total value of all transactions matching the search criteria
  "hasNext": true,
  "content": [
    {
      "rowNum": 1,
      "adjustmentReason": "",
      "amount": 250.00,
      "batchId": "",
      "businessAccountId": "a7e8f66d-38e7-4715-b4b9-d143f50ae4f9",
      "createdAt": "2024-12-27T22:13:45.123Z",
      "createdById": "703408e2-0e08-4cf6-b808-fbe2f30c3644",
      "createdByType": "service-account",
      "creditFinancialAccountId": "f201b990-db39-40ad-9f3d-89a016817dc6",
      "creditFinancialAccountVersion": 1,
      "currency": "USD",
      "debitFinancialAccountId": "ed9216bc-15c7-4543-a6d7-315443db11d1",
      "debitFinancialAccountVersion": 1,
      "description": "Monthly payment",
      "externalTransactionInitiatorId": "50d9c1d5-8796-449c-b367-23c69b1d39e7",
      "id": "982b8213-c105-4c59-9db4-249e453292d5",
      "idempotencyKey": "e810c892-3db2-4f60-bf61-6f9e8e29944c",
      "initiatorAccountHolderId": "c8b51c3b-1c5f-48a2-96f1-960d4a9204a3",
      "korMetadata": "",
      "latestTransactionStatus": "PENDING",
      "latestTransactionStatusId": "01d9ca2d-e068-40f4-be7c-18c3b739b3c9",
      "latestTransactionStatusJson": "",
      "maskedCreditAccountNumber": "******4242",
      "maskedDebitAccountNumber": "******5687",
      "memo": "",
      "metadata": "",
      "multiLegTransactionId": "",
      "originatingChannel": "EXTERNAL",
      "parentTransactionId": "",
      "paymentReasonId": "bill-payment",
      "processedStatusEventIds": "",
      "provider": "",
      "requestedSendDate": "2024-12-27T22:13:45.123Z",
      "reversalReason": "",
      "scheduledTransactionId": "",
      "settlementPriority": "SAME_DAY",
      "solution": "ach",
      "sponsor": "",
      "transactionType": "SEND",
      "updatedAt": "2024-12-27T22:13:45.123Z"
    }
  ]
}
				
			
Exit mobile version