GET

/BizTransaction

Usage Notes

When

  • Retrieve transactions by ID for confirmation or audit
  • Filter by account, investment, product, or date range
  • Track transaction activity for reconciliation workflows

Requirements

  • At least one filter parameter or use pagination for bulk retrieval

Notes

  • Native IDs provide better performance than external ID filtering
  • ShowClosing=true significantly increases response time and CPU usage
  • TransactionDate uses DateOnly format (YYYY-MM-DD)
  • Status values: Complete (settled), Updated (modified post-settlement), RolledBack (reversed)

Description

Retrieves transactions with comprehensive filtering using dot operators. Returns complete transaction details including pricing, status, and parent transaction links for dual-transaction operations.

Required Headers - See Authentication

HeaderValueDescription
Authorization{accessToken}Bearer token for API access
Version2.0API version identifier

Query Parameters

Parameter Type Required Description
ProductID
 integer
Optional
Filter transactions by product for product-level analysis and fund reporting.
ExternalProductId
 string
Optional
Filter transactions by external product reference for cross-system integration.
Status
 string
Optional
Transaction status filter for operational monitoring (values: 'Complete', 'Updated', 'RolledBack').
ShowClosing
 boolean
Optional
Include closing balance calculations in response (warning: significantly increases response time and CPU usage, default: false).
BizTransactionID
 FilterOfInt64
Optional
Filter by native transaction identifier for direct transaction lookup and audit trail verification.
ExternalBizTransactionId
 FilterOfString
Optional
Filter by external transaction identifier for cross-system integration and idempotency checking.
BizTransactionTypeID
 FilterOfInt32
Optional
Filter by transaction type classification for operational reporting and transaction type analysis.
AccountID
 FilterOfInt32
Optional
Filter by native account identifier for account-level transaction history and investor statement generation.
ExternalAccountId
 FilterOfString
Optional
Filter by external account reference for cross-system account correlation.
AccountNumber
 FilterOfString
Optional
Filter by account number for flexible account-based queries and pattern matching.
InvestmentID
 FilterOfInt32
Optional
Filter by investment class for investment-level performance analysis and unit class reporting.
ExternalInvestmentId
 FilterOfString
Optional
Filter by external investment identifier for cross-platform investment mapping.
TransactionDate
 FilterOfDateOnly
Optional
Filter by transaction settlement date for period-based reporting and financial year analysis (format: YYYY-MM-DD).
PageNumber
 integer
Optional
Page number for result set pagination (1-indexed, default: 1).
PageSize
 integer
Optional
Number of transactions per page (maximum 1000 records).
ProductID
integer
Optional
Filter transactions by product for product-level analysis and fund reporting.
ExternalProductId
string
Optional
Filter transactions by external product reference for cross-system integration.
Status
string
Optional
Transaction status filter for operational monitoring (values: 'Complete', 'Updated', 'RolledBack').
ShowClosing
boolean
Optional
Include closing balance calculations in response (warning: significantly increases response time and CPU usage, default: false).
BizTransactionID
FilterOfInt64
Optional
Filter by native transaction identifier for direct transaction lookup and audit trail verification.
ExternalBizTransactionId
FilterOfString
Optional
Filter by external transaction identifier for cross-system integration and idempotency checking.
BizTransactionTypeID
FilterOfInt32
Optional
Filter by transaction type classification for operational reporting and transaction type analysis.
AccountID
FilterOfInt32
Optional
Filter by native account identifier for account-level transaction history and investor statement generation.
ExternalAccountId
FilterOfString
Optional
Filter by external account reference for cross-system account correlation.
AccountNumber
FilterOfString
Optional
Filter by account number for flexible account-based queries and pattern matching.
InvestmentID
FilterOfInt32
Optional
Filter by investment class for investment-level performance analysis and unit class reporting.
ExternalInvestmentId
FilterOfString
Optional
Filter by external investment identifier for cross-platform investment mapping.
TransactionDate
FilterOfDateOnly
Optional
Filter by transaction settlement date for period-based reporting and financial year analysis (format: YYYY-MM-DD).
PageNumber
integer
Optional
Page number for result set pagination (1-indexed, default: 1).
PageSize
integer
Optional
Number of transactions per page (maximum 1000 records).

Query & Filtering

🔍 7G Transaction Filtering with Dot Operators

BizTransaction is 7G's comprehensive financial transaction engine supporting advanced typed filtering for efficient transaction analysis, reporting, and reconciliation workflows.

FilterOfInt64 Large transaction IDs
.equal .in .greaterThan .lessThan
BizTransactionID.equal=12345 BizTransactionID.in=1001,1002,1003
FilterOfInt32 Classifications & IDs
.equal .in .greaterThan .lessThan
BizTransactionTypeID.equal=1 AccountID.in=100,101,102
FilterOfString Text pattern matching
.equal .contains .beginsWith .endsWith
AccountNumber.beginsWith=7G- ExternalAccountId.contains=SMSF
FilterOfDateOnly Date ranges (YYYY-MM-DD)
.equal .greaterThan .lessThan .in
TransactionDate.greaterThan=2024-01-01 TransactionDate.lessThan=2024-12-31
🎯 Key BizTransaction Scenarios: Transaction Types → BizTransactionTypeID.in=1,2,4 (deposits, redemptions, allotments) Account Activity → AccountNumber.beginsWith=7G- (pattern matching) Date Reporting → TransactionDate.greaterThan=2024-01-01 (period analysis) Large IDs → BizTransactionID.in=100001,100002 (bulk lookups)
📖 Complete Query & Filtering Guide

Example Requests

bash
# Get a specific transaction by native ID (fastest lookup)
curl -X GET 'https://api.7g.com.au/BizTransaction?BizTransactionID.equal=12345' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

# Get transaction by external ID (dual-ID system)
curl -X GET 'https://api.7g.com.au/BizTransaction?ExternalBizTransactionId.equal=DEP-2024-001' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

# Get all deposit transactions for specific accounts with pagination
curl -X GET 'https://api.7g.com.au/BizTransaction?BizTransactionTypeID.equal=1&AccountID.in=100,101,102&PageSize=50' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

# Advanced filtering: Multiple transaction types in date range (exclude conversions)
curl -X GET 'https://api.7g.com.au/BizTransaction?BizTransactionTypeID.in=1,2,4&BizTransactionTypeID.notIn=5&TransactionDate.greaterThan=2024-01-01&TransactionDate.lessThan=2024-12-31&PageNumber=1&PageSize=100' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

# Pattern matching: 7G account transactions with closing balances (CPU intensive)
curl -X GET 'https://api.7g.com.au/BizTransaction?AccountNumber.beginsWith=7G-&ShowClosing=true&PageSize=25' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

# Investment-specific analysis: All transactions for growth investment class
curl -X GET 'https://api.7g.com.au/BizTransaction?InvestmentID.equal=25&ExternalInvestmentId.contains=GROWTH&TransactionDate.greaterThanOrEqual=2024-06-01' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

# Status monitoring: Find all updated/modified transactions since date
curl -X GET 'https://api.7g.com.au/BizTransaction?Status=Updated&TransactionDate.greaterThan=2024-08-01&PageSize=50' \
  -H 'Authorization: {accessToken}' \
  -H 'Version: 2.0'

Response Examples

json
{
  "result": true,
  "message": null,
  "recordCount": 2,
  "data": [
    {
      "bizTransactionID": 1001,
      "externalBizTransactionId": "DEP-2024-001",
      "bizTransactionTypeID": 1,
      "typeName": "Deposit",
      "movementReasonCode": "NEW_INVESTMENT",
      "parentBizTransactionID": null,
      "transactionDate": "2025-08-14T10:30:00Z",
      "productID": 10,
      "externalProductId": "FUND-001",
      "accountID": 12345,
      "externalAccountId": "ACC-12345",
      "accountNumber": "ACC001234",
      "bizEntityName": "Smith Family Trust",
      "investmentID": 25,
      "externalInvestmentId": "INV-GROWTH",
      "securityCode": "GRW001",
      "investmentName": "Growth Investment Class A",
      "investmentPrice": 1.2500,
      "comment": "Initial deposit via bank transfer",
      "corporateActionID": null,
      "externalCorporateActionId": null,
      "corporateActionName": null,
      "amount": 50000.00,
      "quantity": 40000.00,
      "transactionClosingAmount": 50000.00,
      "transactionClosingQuantity": 40000.00,
      "accountClosingAmount": 50000.00,
      "accountClosingQuantity": 40000.00,
      "createdDate": "2025-08-14T10:30:15Z",
      "updatedDate": null,
      "bizTransactionStatusID": 1,
      "statusName": "Complete"
    },
    {
      "bizTransactionID": 1002,
      "externalBizTransactionId": "RED-2024-001",
      "bizTransactionTypeID": 2,
      "typeName": "Redemption",
      "movementReasonCode": "PARTIAL_WITHDRAWAL",
      "parentBizTransactionID": null,
      "transactionDate": "2025-08-15T14:15:00Z",
      "productID": 10,
      "externalProductId": "FUND-001",
      "accountID": 12345,
      "externalAccountId": "ACC-12345",
      "accountNumber": "ACC001234",
      "bizEntityName": "Smith Family Trust",
      "investmentID": 25,
      "externalInvestmentId": "INV-GROWTH",
      "securityCode": "GRW001",
      "investmentName": "Growth Investment Class A",
      "investmentPrice": 1.2750,
      "comment": "Partial redemption for education expenses",
      "corporateActionID": null,
      "externalCorporateActionId": null,
      "corporateActionName": null,
      "amount": 12750.00,
      "quantity": 10000.00,
      "transactionClosingAmount": 37250.00,
      "transactionClosingQuantity": 30000.00,
      "accountClosingAmount": 37250.00,
      "accountClosingQuantity": 30000.00,
      "createdDate": "2025-08-15T14:15:30Z",
      "updatedDate": null,
      "bizTransactionStatusID": 1,
      "statusName": "Complete"
    }
  ]
}
POST Deposit POST Redemption POST Transfer GET Get Account Holdings