API Data Provider - Online Help

Contacts

To view the Contacts in the Zoho Desk

Columns

Name Type ReadOnly References Description
Id [KEY] String True

ID of the contact

FirstName String False

First name of the contact

LastName String False

Last name of the contact

LayoutName String True

Name of the Layout

Title String False

Contact title

Email String False

Email ID of the contact

SecondaryEmail String False

Secondary email ID of the contact

Type String True

Contact type

CreatedTime Datetime True

Time of creating the contact

ModifiedTime Datetime True

Time of modifying the contact

Description String False

Contact description

AccountId String False

Account to which the contact is mapped

City String False

Contact's city of residence

Country String False

Contact's country of residence

CustomerHappinessBadPercentage Double True

customerHappiness badPercentage

CustomerHappinessGoodPercentage Double True

customerHappiness goodPercentage

CustomerHappinessOkPercentage Double True

customerHappiness okPercentage

Facebook String True

Facebook ID of the contact

IsAnonymous Boolean True

Indicates whether the contact is anonymous

IsDeleted Boolean True

Indicates whether the contact has been deleted

IsEndUser Boolean True

Indicates whether the contact is an end user

IsFollowing Boolean True

Indicates whether you are following this contact

IsSpam Boolean True

Indicates whether the contact is marked as spam

IsTrashed Boolean True

Indicates whether the contact is in trash

LayoutId String True

ID of the layout assigned to this contact

Mobile String False

Mobile phone number of the contact

OwnerId String False

ID of the user who owns this contact

Phone String False

Primary phone number of the contact

PhotoURL String True

URL of the contact's photo

State String False

State of residence for the contact

Street String False

Street address of the contact

Twitter String True

Twitter handle of the contact

WebUrl String True

Web URL to access the contact record

Zip String False

Zip code of the contact's address

ZohoCRMContact String True

Associated contact details from Zoho CRM

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
Include String

Additional related data to include in the response

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0