Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Asana.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Asana, along with an indication of whether the procedure succeeded or failed.

CData Power BI Connector for Asana 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.