UpdateContactAccessLevel
Updates access level of an already existing contact.
Stored Procedures Specific Information
Process of updating access level of an already existing contact
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 UpdateContactAccessLevel are ContactId, Type, Id, AccessorType and Name. For example:
INSERT INTO AccessorAggregate#TEMP (Id, AccessorType, Name) VALUES ('123456', 'Accessor Type Value', 'Accessor Name');
EXEC UpdateContactAccessLevel AccessorAggregate = 'AccessorAggregate#TEMP', ContactId = '567890', Type = 'Public';
The second way of using the Stored Procedure is by adding the aggregate itself:
EXECUTE UpdateContactAccessLevel AccessorAggregate = '{
"Id": "123456",
"AccessorType": "Accessor Type",
"Name": "Accessor Name"
}', ContactId = '567890', Type = 'Public'
Input
| Name | Type | Description |
| ContactId | String | The unique identifier (id) for a given contact. |
| Type | String | The type of the contact |
| Id | String | The unique identifier (id) for a given accessor. This column can only be specified as part of AccessorAggregate when using a temp table. |
| AccessorType | String | The type of the accessor. This column can only be specified as part of AccessorAggregate when using a temp table. |
| Name | String | The name of the accessor. This column can only be specified as part of AccessorAggregate when using a temp table. |
| AccessorAggregate | String | This is a map of your property names to the values for this object. These are the values that we will sync into corresponding Accessor object. Use this input to specify the Id, AccessorType, and Name values for the accessor. |
Result Set Columns
| Name | Type | Description |
| Status | String | Whether or not the access level was updated. |