ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Zoho Projects の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、該当する場合は、プロシージャが成功したか失敗したかを示すとともにZoho Projects から関連するレスポンスデータを返します。

CData JDBC Driver for Zoho Projects ストアドプロシージャ


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.