Power BI Connector for Act! CRM

Build 24.0.8963

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963