Stored Procedures

Stored procedures are function-like interfaces that enable the component to perform actions beyond the scope of basic data access. They accept a list of parameters, perform an action, and return response data from Zoho Projects and/or a confirmation of the success or failure of the procedure.

The full list of procedures is provided below. Navigate to an individual procedure's page for a breakdown of its functionality, inputs, and outputs.

CData SSIS Components 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.