ODBC Driver for Act! CRM

Build 26.0.9770

AddOrRemoveOpportunitiesToCompany

Associate or dissociate one or more opportunities to a company.

Stored Procedures Specific Information

Process of adding or removing opportunities to company

This stored procedure associates or dissociates one or more opportunities to a company. The required parameter CompanyId accepts a single value. The required parameter OpportunityIds accepts a comma-separated list of opportunity Ids. The required parameter Type accepts a single value: 'add' or 'remove'. For example:

For Adding Opportunities To Company

EXEC AddOrRemoveOpportunitiesToCompany CompanyId = '5d940c2d-e09e-4204-ad0a-375f73a550a7', OpportunityIds = '4a6ffff1-5872-42a6-b98c-4a24a19ba585', Type = 'add'

For Removing Opportunities From Company

EXEC AddOrRemoveOpportunitiesToCompany CompanyId = '5d940c2d-e09e-4204-ad0a-375f73a550a7', OpportunityIds = '4a6ffff1-5872-42a6-b98c-4a24a19ba585', Type = 'remove'

Input

Name Type Description
CompanyId String The unique identifier (id) for a given company.
OpportunityIds String A comma-separated list of opportunity ids to associate or dissociate.
Type String Whether to add or remove the opportunities. Set to 'add' or 'remove'.

The allowed values are add, remove.

Result Set Columns

Name Type Description
Status String Stored Procedure Execution Status

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770