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