AddOrRemoveOpportunitiesToContact
Associate or dissociate one or more opportunities to a contact.
Stored Procedures Specific Information
Process of adding or removing opportunities to contact
This stored procedure associates or dissociates one or more opportunities to a contact. The required parameter ContactId 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 Contact
EXEC AddOrRemoveOpportunitiesToContact ContactId = 'a58016a6-780c-48c0-84ff-b6b6b085eb8c', OpportunityIds = '4a6ffff1-5872-42a6-b98c-4a24a19ba585', Type = 'add'
For Removing Opportunities From Contact
EXEC AddOrRemoveOpportunitiesToContact ContactId = 'a58016a6-780c-48c0-84ff-b6b6b085eb8c', OpportunityIds = '4a6ffff1-5872-42a6-b98c-4a24a19ba585', Type = 'remove'
Input
| Name | Type | Description |
| ContactId | String | The unique identifier (id) for a given contact. |
| 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 |