ODBC Driver for Act! CRM

Build 26.0.9770

AddOrRemoveOpportunitiesToGroup

Associate or dissociate one or more opportunities to a group.

Stored Procedures Specific Information

Process of adding or removing opportunities to group

This stored procedure associates or dissociates one or more opportunities to a group. The required parameter GroupId 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 Group

EXEC AddOrRemoveOpportunitiesToGroup GroupId = '49006ae2-0f89-4e92-9302-2472de8e19f1', OpportunityIds = '4a6ffff1-5872-42a6-b98c-4a24a19ba585', Type = 'add'

For Removing Opportunities From Group

EXEC AddOrRemoveOpportunitiesToGroup GroupId = '49006ae2-0f89-4e92-9302-2472de8e19f1', OpportunityIds = '4a6ffff1-5872-42a6-b98c-4a24a19ba585', Type = 'remove'

Input

Name Type Description
GroupId String The unique identifier (id) for a given group.
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