ContactRoles
Get, add, update, or delete the list of contact roles
Table-Specific Information
Select
SELECT * FROM ContactRoles
Insert
Insert INTO ContactRoles(SequenceNumber, Name) VALUES(8, 'TEST3')
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM ContactRoles WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE ContactRoles SET Name='Sales Lead 1' where Id= '2732548000006917001'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
Represents the unique ID of the contact role. |
SequenceNumber | Integer | False |
Represents the position of the contact role in the picklist in CRM UI. |
Name | String | False |
Represents the name of the contact role. |