API Data Provider - Online Help
ZohoProjects Profile
Connecting to ZohoProjects
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
BugActivities
BugAttachments
BugComments
BugCustomViews
BugFollowers
BugResolution
Bugs
BugTimelogs
Events
Folders
Forums
Layouts
Milestones
MyBugs
MyTaskCustomViews
MyTasks
MyTimelogs
Portals
PortalUsers
ProjectActivities
ProjectCustomFields
ProjectGroups
Projects
ProjectStatuses
ProjectUsers
Subtasks
Tags
TaskActivities
TaskAttachments
TaskComments
TaskCustomViews
Tasklists
TasklistTasks
Tasks
TaskTimelogs
Timelogs
BugCustomViews
Returns customviews for bugs..
Columns
Name
Type
References
PortalId
Integer
Portals
.Id
ProjectId
Long
Projects
.Id
Id [KEY]
String
Name
String
IsFavorite
Boolean