Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Zoho Projects.

Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from Zoho Projects, along with an indication of whether the procedure succeeded or failed.

CData JDBC Driver for Zoho Projects Stored Procedures


Name	Description
AddUserToClientCompany	Adds user to an existing client company.
ApproveTimelog	Approve general/bug/task time log.
AssociateBugs	Associate related bugs to a task.
AssociateContacts	Associates a tag with a specific entity in a specific project.
AssociateTags	Associates a tag with a specific entity in a specific project.
DissociateBugs	Associate related bugs to a task.
DissociateContacts	Dissociate a client contact from a project.
DissociateTags	Dissociates a tag with a specific entity in a specific project.
ForumFollow	Follow a forum post.
ForumSelectBestAnswer	Unfollow a forum post.
ForumUnfollow	Unfollow a forum post.
ForumUnselectBestAnswer	Unfollow a forum post.
GetOAuthAccessToken	Gets an authentication token from ZohoProjects.
GetOAuthAuthorizationURL	Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with ZohoProjects.
SelectTeamLead	Update the team lead.
TaskFollow	Follow a task in the given project.
TaskMove	Moves a task from one tasklist to another tasklist. The target tasklist can be of the same project or different project.
TaskReorder	Reorders the tasks in the given project. Task will be reordered in-between two tasks based on the previous and next task IDs.
TaskUnfollow	Unfollow a task in the given project.