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.
POST /v1/search/sync/transactions
Authorization: Bearer <access_token>
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.
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:
transactionType
string enum, values: SEND, REQUEST, DEPOSIT, WITHDRAWAL, REVERSAL, RETURN, ADJUSTMENT
Type of transaction. The following values are supported:
None
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"
}
]
}
Step into the future of Finance with RocketKOR! Simplify payments, banking, lending, and data analytics using our versatile KOR Platform.
A Rocket Financial Inc. company
@ 2024 RocketKOR, Inc. All rights reserved.