Stored Procedures
Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
Asana Adapter Stored Procedures
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. |