TaskTemplates
To delete and query the task templates.
Table Specific Information
Select
The add-in uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- Id supports the '=' comparison.
- ProjectId supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM TaskTemplates WHERE Id = '1127092449876457' SELECT * FROM TaskTemplates WHERE ProjectId = '1208149945266501'
Delete
The following is an example of how to delete from the TaskTemplates table:
DELETE FROM TaskTemplates WHERE Id = '1234'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique ID of the user. | |
| ResourceType | String | True |
The base type of this resource. | |
| Name | String | True |
Name of the task template. | |
| ProjectId | String | True |
Projects.Id |
Globally unique identifier of the resource, as a string. |
| ProjectName | String | True |
Name of the project. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer. | |
| TemplateName | String | True |
Globally unique identifier of the resource, as a string. | |
| TemplateTaskResourceSubtype | String | True |
The subtype of the task that will be created from this template. | |
| TemplateDescription | String | True |
Description of the task that will be created from this template. | |
| TemplateHTMLDescription | String | True |
HTML description of the task that will be created from this template. | |
| TemplateMemberships | String | True |
Array of projects that the task created from this template will be added to. | |
| TemplateRelativeStartOn | Integer | True |
The number of days after the task has been instantiated on which that the task will start. | |
| TemplateRelativeDueOn | Integer | True |
The number of days after the task has been instantiated on which that the task will be due. | |
| TemplateDueTime | Time | True |
The time of day that the task will be due. | |
| TemplateDependencies | String | True |
Array of task templates that the task created from this template will depend on. | |
| TemplateDependents | String | True |
Array of task templates that will depend on the task created from this template. | |
| TemplateFollowers | String | True |
Array of users that will be added as followers to the task created from this template. | |
| TemplateAttachments | String | True |
Array of attachments that will be added to the task created from this template. | |
| TemplateSubtasks | String | True |
Array of subtasks that will be added to the task created from this template. | |
| CreatedById | String | True |
Globally unique identifier of the resource, as a string. | |
| CreatedByName | String | True |
The user's name. Read-only except when the same user is the requester. | |
| CreatedAt | Datetime | True |
The time at which this task template was created. |