# Asana: Task ## Description * An enriched task table consisting of base task info + aggregated metrics and lists ## Supported Data Sources * Asana ## Columns | Type | Name | Description | | -------- | ------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | INTEGER | task\_id | System generated unique ID of the task. | | INTEGER | assignee\_user\_id | Foreign key referencing the ASANA\_USER that is currently assigned the task. | | BOOLEAN | is\_completed | Boolean that is true if the task is currently marked complete. | | DATETIME | completed\_at | Timestamp of when the task was marked complete. | | INTEGER | completed\_by\_user\_id | Foreign key referencing the USER who completed the task. Note that this may be different than the assignee | | DATETIME | created\_at | Timestamp of when the task was created | | DATETIME | due\_date | Date the task is due, if provided. | | DATETIME | modified\_at | Timestamp of when the task was last modified | | STRING | task\_name | User-facing name of the task | | INTEGER | parent\_task\_id | Self-referential id of the parent TASK that this is a subtask of. | | DATETIME | start\_date | The start date of the task, if a date range is given. | | STRING | task\_description | Free-form text describing the task, as seen in the UI. | | BOOLEAN | is\_liked | Boolean that is true if the task is liked by the authorized user. | | INTEGER | number\_of\_likes | Number of users who have liked this task. | | INTEGER | workspace\_id | Foreign key reference to the workspace | | STRING | task\_link | URL formatted to bring you directly to the task in asana. | | STRING | assignee\_name | Name of the user that the task is currently assigned to. | | STRING | assignee\_email | Email of the user that the task is currently assigned to. | | INTEGER | days\_open | The number of days the task has been/was open (creation -> completion) | | BOOLEAN | is\_currently\_assigned | Boolean, true if the task is *currently* assigned | | BOOLEAN | has\_been\_assigned | Boolean, true if the task has at one point been assigned, even if currently not. | | INTEGER | days\_since\_last\_assignment | The number of days the task has been/was open and assigned to to the most recent user (last assignment -> completion) | | INTEGER | days\_since\_first\_assignment | The number of days the task has been/was open and assigned at all (first time assigned -> completion) | | DATETIME | last\_assigned\_at | Timestamp of when the task was last assigned (to the current user if still assigned) | | DATETIME | first\_assigned\_at | Timestamp of when the task was first assigned to someone | | INTEGER | first\_modifier\_user\_id | Foreign key referencing the ASANA\_USER who made the first modification to the task (ie added a description). A proxy for task creator. | | STRING | first\_modifier\_name | Name of the user who made the first modification to the task | | STRING | conversation | The task's comments and authors aggregated into an ordered conversation, with authors + time sent | | INTEGER | number\_of\_comments | Count of comments made on the task | | STRING | followers | A list of the names of the users who follow the task. | | INTEGER | number\_of\_followers | Count of the users following the task | | STRING | tags | A list of the tags associated with the task. | | INTEGER | number\_of\_tags | Count of the tags associated with the task. | | STRING | project\_ids | List of all `project_ids` associated with the task. You can parse or explode the items in the list using a comma + space (`", "`) as a delimiter. To keep the table grain at the task\_id level, this list is not parsed by default. | | STRING | project\_names | List of all `project_names` associated with the task. You can parse or explode the items in the list using a comma + space (`", "`) as a delimiter. To keep the table grain at the task\_id level, this list is not parsed by default. | | STRING | projects\_sections | A list of the projects + sections that this task is listed under. You can parse or explode the items in the list using a comma + space (`", "`) as a delimiter. To keep the table grain at the task\_id level, this list is not parsed by default. | | INTEGER | number\_of\_projects | The number of projects associated with the task. | | BOOLEAN | is\_subtask | Boolean that's true if the task is a subtask of another. | | STRING | parent\_task\_name | User-facing name of the task's parent task. | | INTEGER | parent\_assignee\_user\_id | Foreign key referencing the ASANA\_USER who is assigned the parent task | | STRING | parent\_assignee\_name | Name of the user assigned this task's parent task | | DATETIME | parent\_due\_date | Date on which the parent task is due, if given | | DATETIME | parent\_created\_at | Timestamp of when the parent task was created | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/asana-task.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.