ODBC Driver for Zoho CRM

Build 25.0.9434

ContactRoles

Defines the role a contact plays in relation to a deal or account, with support to create, update, or remove 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

Unique identifier for the contact role record.

SequenceNumber Int False

Position of the contact role in the CRM picklist, used to define display order.

Name String False

Name of the contact role, such as decision maker or influencer.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434