JDBC Driver for Act! CRM

Build 22.0.8462

AddOrRemoveContactToActivity

Add or remove the contact to an activity

Stored Procedures Specific Information

Process of adding or removing contact to activity

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 AddOrRemoveContactToActivity are ContactId, ActivityId and Type. For example:

For Adding Contact

EXEC AddOrRemoveContactToActivity ContactId = '123456', ActivityId = '567890', Type = 'add';

For Removing Contact

EXEC AddOrRemoveContactToActivity ContactId = '123456', ActivityId = '567890', Type = 'remove';

Input

Name Type Description
ActivityId String The Id of the activity to which contact will be associated or disassociated
ContactId String The Id of the contact to be associated or disassociated
Type String Type to specify whether to add or remove contact.

Result Set Columns

Name Type Description
Status String Stored Procedure Execution Status

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462