Stored Procedures

Stored procedures are function-like interfaces that enable the connector 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 Power BI Connector for Zoho Projects Stored Procedures


Name	Description
AssociateContacts	Associate a client contact to a project.
AssociateIssues	Associate related issues to a task.
AssociateTags	Associates a tag with a specific entity in a specific project. This will replace the current associated tags with the new tag IDs if the previous tag IDs are not included in the request.
AssociateIssues	Associate related issues to a task.
DisassociateContacts	Disassociate a client contact from a project.
DisassociateIssue	Disassociate an issue from a task.
DisassociateTags	Disassociates a tag with a specific entity in a specific project.
DisassociateIssue	Disassociate an issue from a task.
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.
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 within a task list in the given project. Task will be reordered in-between two tasks based on the before and after task IDs.
TaskUnfollow	Unfollow a task in the given project.