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. |
AccessorType | String | The type of the accessor |
Name | String | The name of the accessor |
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. |
Result Set Columns
Name | Type | Description |
Status | String | Whether or not the access level was updated. |