TaskTemplates
To delete and query the task templates.
Table Specific Information
Select
The connector 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 connector.
- 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. |