ストアドプロシージャ

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

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

CData SSIS Components for Asana ストアドプロシージャ


Name	Description
AddDependenciesToTask	To set of tasks as dependencies of this task, if they are not already dependencies. A task can have at most 15 dependencies.
AddDependentsToTask	To Set or Unlink dependents to the task.
AddFollowers	To add followers to the tasks or projects.
AddProjectToTask	Add a project to a task.
AddTagsToTask	To Set or Unlink dependents to the task.
AddTaskToSection	Add a task to a specific, existing section. This will remove the task from other sections of the project.
DownloadAttachment	To Download an Attachment.
DuplicateProject	To create a duplicate copy of the project.
DuplicateTask	To Set or Unlink dependencies to the task.
GetOAuthAccessToken	Gets an authentication token from Asana.
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.
MoveSectionsinProject	To reorder the section in the project.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Asana.
RemoveDependenciesFromTask	To Set or Unlink dependencies to the task.
RemoveDependentsFromTask	To Set or Unlink dependents to the task.
RemoveFollowers	To remove followers from the tasks or projects.
RemoveProjectsFromTask	Remove a project from a task.
RemoveTagsFromTask	To Set or Unlink dependents to the task.
SetParentofTask	To Set the parent of a task.
UploadAttachment	Uploads an Attachment to Asana.