GET

/BizTransaction

When to Use

Retrieve specific transactions using BizTransactionID or ExternalBizTransactionId for direct lookups
Filter transactions by account, investment, product, or transaction type using dot operators
Track transaction activity by date ranges for reconciliation and reporting workflows
Monitor transaction status changes for operational oversight and exception handling
Build comprehensive financial reports with detailed transaction-level data
Synchronize transaction changes with external systems using date-based filtering

Common Scenarios

Single Transaction Lookup: Use BizTransactionID=12345 or ExternalBizTransactionId="DEP-2024-001" for direct retrieval
Account Activity Reports: Use AccountID.Equal=789 or AccountNumber.BeginsWith="7G-" to get all transactions for specific accounts
Transaction Type Analysis: Use BizTransactionTypeID.In=1,2,4 to analyze deposits, redemptions, and allotments together
Date Range Reporting: Use TransactionDate.GreaterThan=2024-01-01 and TransactionDate.LessThan=2024-12-31 for period analysis
Investment Performance Tracking: Use InvestmentID.Equal=25 to get all transactions for a specific investment class
Status Monitoring: Use Status="Updated" to find transactions that have been modified post-settlement
Product-Level Analysis: Combine ProductID + TransactionDate filters for product performance reporting

Prerequisites

Valid Bearer token with transaction read permissions
Account or investment identifiers for targeted filtering

Considerations

Performance: Native IDs (BizTransactionID, AccountID, InvestmentID) provide better performance than external ID filtering
Pagination Strategy: Large result sets are automatically paginated. Use PageNumber (starts from 1) and PageSize (max 1000) parameters. Check response recordCount to determine if additional pages exist
Closing Balances: Set ShowClosing=true only when required as it significantly increases CPU usage and response time
Date Filtering: TransactionDate uses DateOnly format (YYYY-MM-DD), not full datetime. Use for efficient period-based queries
Status Values: Complete=settled transactions, Updated=modified post-settlement, RolledBack=reversed transactions
Transaction Relationships: ParentBizTransactionID links related transactions (conversions, transfers, allotments)
Filter Combinations: Multiple filters use AND logic - combine strategically to avoid empty result sets

Description

Retrieves business transactions with comprehensive filtering options using dot operators for advanced querying. Returns complete transaction records including account details, investment information, pricing data, status tracking, and optional closing balance calculations. Supports efficient filtering, pagination, and detailed transaction analysis across the entire 7G transaction ecosystem.

Required Headers - See Authentication

Header	Value	Description
Authorization	{accessToken}	Bearer token for API access
Version	2.0	API 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 'Content-Type: application/json' \
  -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 'Content-Type: application/json' \
  -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 'Content-Type: application/json' \
  -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 'Content-Type: application/json' \
  -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 'Content-Type: application/json' \
  -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 'Content-Type: application/json' \
  -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 'Content-Type: application/json' \
  -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"
    }
  ]
}

When to Use

Common Scenarios

Prerequisites

Considerations

Description

Required Headers - See Authentication

Query Parameters

Query & Filtering

🔍 7G Transaction Filtering with Dot Operators

Example Requests

Response Examples

Related Endpoints

Connection Lost