Excel Add-In for Zoho CRM

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060