JDBC Driver for Act! CRM

Build 21.0.8137


Creates a new Opportunity Product

Stored Procedures Specific Information

Process of adding opportunity product

Act! CRM allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for AddOpportunityProduct are OpportunityId, ProductName, ProductCost, ProductDiscount, ProductDiscountPrice, ProductItemNumber, ProductPrice, ProductQuantity and ProductTotal. For example:

Execute AddOpportunityProduct OpportunityId='123456', ProductName='Sample Opportunity Product'


Name Type Description
OpportunityId String The unique identifier (id) for a given opportunity.
ProductName String The name of the product
ProductCost String The cost of the product
ProductDiscount String The discount value
ProductDiscountPrice String The discount price value
ProductItemNumber String The item number of the product
ProductPrice String The price of the product
ProductQuantity String The product quantity
ProductTotal String The product total

Result Set Columns

Name Type Description
Status String Stored Procedure Execution Status

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137