To Create, update, delete, and query from SubTasks table.
Table Specific Information
The connector will use 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.
- ParentTaskId supports the '=' comparison.
For example, the following query is processed on server side and it is a required filter:
SELECT * FROM SubTasks WHERE ParentTaskId = '1127092449876457'
ParentTaskId is a mandatory column for inserting into Projects table. For example:
INSERT INTO SubTasks (ParentTaskId, Name, Assignee, AssigneeStatus, startOn, DueOn, Completed, ProjectId, Notes, ApprovalStatus, Followers) VALUES ('1167713816822372', 'subtask1', '1167715005778471', 'later', '2020-03-25', '2020-04-01',false,1167713816822364, 'SubTask Notes', 'changes_requested', '1167715005778471')
Globally unique ID of the Subtask.
Globally unique ID of the task
Name of the Subtask.
User to which this subtask is assigned
Scheduling status of this subtask for the user it is assigned to.
The allowed values are today, upcoming, later, new, inbox.
The time at which this subtask was created.
The time at which this subtask was last modified.
The day on which work begins for the task , or null if the task has no start date. This takes a date with YYYY-MM-DD format.
Date and time on which this subtask is due, or null if the subtask has no due time.
Date on which this task is due, or null if the task has no due date. This takes a date with YYYY-MM-DD format
True if the subtask is currently marked complete, false if not.
The time at which this subtask was completed, or null if the subtask is incomplete.
The user who completed this task
Globally unique ID of the Project
Globally unique ID of the Workspace
More detailed, free-form textual information associated with the subtask.
Reflects the approval status of this task.
The allowed values are pending, approved, rejected, changes_requested.
The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
The allowed values are default_task, milestone, section, approval.
The notes of the text with formatting as HTML.
Array of resources referencing tasks that this task depends on.
Array of projects this task is associated with and the section it is in.
Array of resources referencing tasks that depend on this task.
True if the task is liked by the authorized user, false if not.
The number of users who have liked this Task.
Array of likes for users who have liked this task.
The base type of this resource.
In some contexts tasks can be rendered as a visual separator
Array of users following this task.
Array of tags associated with this task.