ADO.NET Provider for Asana

Build 20.0.7655

SubTasks

To Create, update, delete, and query from SubTasks table.

Table Specific Information

Select

The 本製品 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 本製品.

  • 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'

Insert

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')

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the Subtask.

ParentTaskId String True

Globally unique ID of the task

Name String False

Name of the Subtask.

Assignee String False

User to which this subtask is assigned

AssigneeStatus String False

Scheduling status of this subtask for the user it is assigned to.

使用できる値は次のとおりです。today, upcoming, later, new, inbox

CreatedAt Datetime True

The time at which this subtask was created.

ModifiedAt Datetime True

The time at which this subtask was last modified.

startOn Date False

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.

DueAt Datetime False

Date and time on which this subtask is due, or null if the subtask has no due time.

DueOn Date False

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

Completed Boolean False

True if the subtask is currently marked complete, false if not.

CompletedAt Datetime True

The time at which this subtask was completed, or null if the subtask is incomplete.

completed_by String True

The user who completed this task

ProjectId String False

Projects.Id

Globally unique ID of the Project

WorkspaceId String False

Workspaces.Id

Globally unique ID of the Workspace

Notes String False

More detailed, free-form textual information associated with the subtask.

ApprovalStatus String False

Reflects the approval status of this task.

使用できる値は次のとおりです。pending, approved, rejected, changes_requested

ResourceSubType String False

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.

使用できる値は次のとおりです。default_task, milestone, section, approval

HtmlNotes String False

The notes of the text with formatting as HTML.

Dependencies String True

Array of resources referencing tasks that this task depends on.

Memberships String True

Array of projects this task is associated with and the section it is in.

Dependents String True

Array of resources referencing tasks that depend on this task.

Liked Boolean False

True if the task is liked by the authorized user, false if not.

NumberofLikes Integer True

The number of users who have liked this Task.

LikedBy String True

Array of likes for users who have liked this task.

ResourceType String True

The base type of this resource.

IsRenderedAsSeparator Boolean True

In some contexts tasks can be rendered as a visual separator

Followers String False

Array of users following this task.

Tags String False

Array of tags associated with this task.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655