DELETE

/Investment/Price

When to Use

  • Test Environment Cleanup: Remove all pricing data for test investments created during development, UAT, or system integration testing before production deployment
  • Data Import Error Recovery: Delete all pricing records after discovering systematic errors in bulk price uploads from fund administrators or data feeds
  • Investment Deletion Preparation: Remove all price history as required prerequisite before deleting investment records (Investment DELETE requires no price records exist)
  • Cancelled Product Cleanup: Delete pricing data for investment products cancelled before launch or investor activity commenced
  • Migration Data Correction: Remove duplicate or incorrect pricing records from data migration processes before production use

Common Scenarios

  • Test Data Cleanup Before Production: Remove all pricing for test investments created during system configuration and testing phases
  • Bulk Import Error Recovery: Delete all pricing after discovering data feed mapping errors affecting NAV calculations or price precision
  • Investment Record Deletion Sequence: Delete all price history first, then delete investment record (cascading deletion prevention)
  • Pre-Launch Data Correction: Remove incorrect pricing loaded before investment product launch and investor transactions

Prerequisites

  • Valid Bearer token with investment price deletion permissions and administrative authority for pricing data management
  • Price records must exist for the specified investment - verify via GET /Investment/Price before deletion
  • Verification that NO transactions reference this pricing - system validates no BizTransaction records exist using these prices
  • Administrative approval and documentation for pricing data deletion meeting audit trail requirements
  • Understanding of ALL deletion scope - endpoint deletes ALL price records for investment, not individual dates
  • Backup of pricing data if recovery might be needed - deletion is permanent and irreversible

Important Considerations

⚠️ Critical Deletion Restrictions and Scope

  • Complete Investment Price Deletion: Endpoint deletes ALL price records for specified investment - not individual price dates. All historical pricing data permanently removed
  • Transaction Dependency Protection: Cannot delete if ANY transactions processed using this investment's pricing on same or later dates - protects transaction valuation integrity
  • Portfolio Valuation Impact: Deletion removes historical pricing needed for portfolio valuation history and performance calculations - affects BizEntity Account Holdings displays
  • Irreversible Operation: Price deletion is permanent with no recovery mechanism - ensure backup exists before proceeding with deletion
  • Distribution Calculation Dependencies: Cannot delete if distribution records reference this pricing for distribution amount calculations or ex-distribution pricing
  • Investment Deletion Sequencing: Required step before investment deletion - Investment DELETE endpoint requires no price records exist for validation

Description

Permanently deletes investment price records from the 7G platform. This operation has strict business rules to prevent deletion of pricing data that has been used for transaction processing or regulatory reporting.

⚠️ Price Deletion Scope

This endpoint deletes ALL price records for the specified investment:

  • All historical price data will be permanently removed
  • Cannot delete prices if transactions exist on those dates
  • Cannot delete if distribution calculations reference the prices
  • Deletion is irreversible - backup data before proceeding

Note: To delete or correct a specific price date, use PUT to update or contact support.

Required Headers - See Authentication

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

Query Parameters

Parameter Type Required Description
ProductID >
integer
Native product identifier for product ownership validation (verifies investment belongs to product before deleting ALL price records).
ExternalProductId >
string
External product identifier for cross-system integration (alternative to ProductID, resolves to native ProductID for validation).
InvestmentID >
integer
Native investment identifier specifying which investment's ALL price records will be permanently deleted (validates no transaction dependencies or distribution references).
ExternalInvestmentId >
string
External investment identifier for cross-system price deletion (must be combined with ProductID or ExternalProductId for scoping).
ProductID
integer
Native product identifier for product ownership validation (verifies investment belongs to product before deleting ALL price records).
ExternalProductId
string
External product identifier for cross-system integration (alternative to ProductID, resolves to native ProductID for validation).
InvestmentID
integer
Native investment identifier specifying which investment's ALL price records will be permanently deleted (validates no transaction dependencies or distribution references).
ExternalInvestmentId
string
External investment identifier for cross-system price deletion (must be combined with ProductID or ExternalProductId for scoping).

Parameter Combinations

Investment identification (choose one):

  • Option 1: InvestmentID + ProductID
  • Option 2: ExternalInvestmentId + ProductID
  • Option 3: ExternalInvestmentId + ExternalProductId

Note: The system will delete ALL price records for the specified investment. To delete a specific price date, contact support for data correction procedures.

Example Requests

bash
# Delete all prices for an investment using native IDs
curl -X DELETE "https://api.7g.com.au/Investment/Price?ProductID=100&InvestmentID=12345" \
  -H "Authorization: {accessToken}" \
  -H "Version: 2.0"

# Delete using external IDs
curl -X DELETE "https://api.7g.com.au/Investment/Price?ExternalProductId=FUND-001&ExternalInvestmentId=INV-001" \
  -H "Authorization: {accessToken}" \
  -H "Version: 2.0"

# Delete using mixed ID types
curl -X DELETE "https://api.7g.com.au/Investment/Price?ProductID=100&ExternalInvestmentId=INV-001" \
  -H "Authorization: {accessToken}" \
  -H "Version: 2.0"

Response Examples

json
{
  "result": true,
  "message": "Investment price deleted successfully",
  "recordCount": 0,
  "data": null
}
GET Get investment prices DELETE Delete investment POST Create investment prices