API Data Provider - Online Help
ZohoDesk Profile
Connecting to ZohoDesk
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
AccessibleOrganizations
AccountComments
AccountContacts
AccountContracts
AccountDeDuplicationDefaultFieldName
AccountFollowers
AccountHistory
AccountProducts
Accounts
AccountSearch
AccountSla
AccountStatistics
AccountTickets
AccountTimeEntry
AccountTimeEntrySummation
ActiveTimer
ActivitiesSearch
AgentAvailability
AgentAvailabilityConfiguration
AgentByEmail
AgentByIds
Agents
AgentSignatures
AgentSkills
AgentTeams
AgentTicketsCount
TicketsTimeEntry
AgentTimeEntrySummation
AllActiveTimers
ArchivedTickets
ArticleComments
ArticleFeedbacks
ArticleHistory
ArticleInsights
Articles
ArticleSearch
ArticleTranslations
ArticleTranslationSearch
ArticleTranslationSearchByTag
AssociatedTickets
Attachments
AutomationFeatureCount
AvailableBadgeIcons
AvailableDependencyMappings
Badges
BadgeUsers
Blueprints
BugTickets
BulkExport
BusinessHourRelatedRules
BusinessHours
CallComments
Calls
CallSearch
Channels
CommentHistory
CommunityCategory
CommunityCategoryByPermalink
CommunityCategoryFollowers
CommunityModeratedTopics
CommunityModeratedUsers
CommunityModerationComments
CommunityModerationCounts
CommunityModerationTopics
CommunityMyDraftedTopics
CommunityPreferences
CommunityTopicComments
CommunityTopicFollowerParticipantVoter
CommunityTopicPermalinks
CommunityTopics
CommunityTopicTypes
CommunityUserComments
CommunityUserFollowers
CommunityUsers
CommunityUserTopics
ContactAccounts
ContactByIds
ContactComments
ContactDeDuplicationDefaultFieldName
ContactFollowers
ContactHelpCenters
ContactHistory
ContactProducts
ContactProfiles
Contacts
ContactSearch
ContactStatistics
ContactTickets
ContactTimeEntry
ContactTimeEntrySummation
ContractComments
Contracts
Countries
Credits
CreditUsers
CustomerHappiness
CustomerHappinessContent
CustomerHappinessLinkHolder
CustomFieldCount
DashboardResponseCount
DashboardResponseTime
DashboardTickets
DashboardTicketsResolutionTime
DataSharingRules
DepartmentAgents
DepartmentByIds
DepartmentCheckExists
DepartmentMailConfigurations
Departments
DepartmentTeams
DependencyMappings
Domains
DuplicateAccountDetails
DuplicateContactDetails
EmailFailureAlerts
EventComments
Events
EventSearch
Followers
GroupDuplicateValues
Groups
GroupUsers
HelpCenters
HolidayList
IMCannedMessages
IMChannels
IMMetricSessionTimeSeries
Imports
IMSessions
InvoiceTickets
JiraIssueTickets
KbCategoryRepositionArticles
KbRootCategories
KbRootCategoriesCategoryTree
KbRootCategoriesReviewOwners
KbSections
Labels
LabelUsers
Languages
LastAccessedView
LayoutProfiles
LayoutRuleCriteriaFields
LayoutRules
Layouts
Levels
LightAgentProfile
MailConfigurations
MailReplyAddress
MetricsAgents
MyActiveTimers
MyForm
Myinfo
MyModules
MyPendingApprovals
MyPreferences
MyProfile
MyProfilePermissions
OfflineAgents
OnlineAgents
OrganizationFieldCriteriaReferences
OrganizationFieldPermissions
OrganizationFields
OrganizationModules
Organizations
PermalinkAvailability
PersonalRole
ProductAccounts
ProductContacts
Products
ProductSearch
ProductSearchDuplicates
ProductTickets
ProfileAgents
Profiles
RecycleBin
RoleAgents
RoleByIds
Roles
RoleTeams
RoutingPreferences
Search
SkillConfiguration
SkillCriteriaFields
SkillRelatedRules
Skills
SkillTypes
StandardLayoutFormat
StarredViews
SubjectAccessRequestFieldsAndConditions
SubjectAccessRequests
SupportEmailDomain
SupportEmailDomain
SupportPlans
TagSearch
TagTickets
TaskComments
Tasks
TaskSearch
TaskTimeEntry
TaskTimeEntrySummation
TeamAssociables
TeamMembers
Teams
TemplateFolders
TemplatePlaceholders
Templates
ThreadOriginalContent
TicketActivities
TicketApprovals
TicketArticleSuggestion
TicketBlueprint
TicketCalls
TicketComments
TicketConversations
TicketCountByFieldValues
TicketEvents
TicketFollowers
TicketHistory
TicketLatestThread
TicketMetrics
TicketPins
TicketResolution
TicketResolutionHistory
Tickets
TicketSearch
TicketTags
TicketTasks
TicketTemplates
TicketThreads
TicketTimeEntry
TicketTimeEntryByBillingType
TicketTimeEntrySummation
TicketTransitionForm
TicketsTimer
TimeTrackHistory
TimeTrackSettings
TimeZones
TranslationAttachments
TranslationComments
TranslationFeedbacks
TranslationPermalinks
UserBadges
UserGroups
UserLabels
Users
ValidationRuleCriteriaFields
ValidationRules
Views
VoterTrend
ZohoFinanceEstimates
ZohoFinanceInvoices
TimeZones
Retrieve TimeZones data from Zoho Desk.
Columns
Name
Type
References
Id [KEY]
String
Name
String