Projects
To Create, Update, Delete and Query the Projects 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 本製品.
- Id supports the '=' comparison.
- workspaceId supports the '=' comparison.
- TaskId supports the '=' comparison.
- TeamId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM projects WHERE workspaceId = '1126938837961830' SELECT * FROM projects WHERE Id = '1128092864672888' SELECT * FROM projects WHERE TaskId = '1130092964672468' SELECT * FROM projects WHERE TeamId = '1129514033997890'
Insert
WorkspaceId or TeamId is a mandatory column for inserting into Projects table. For example:
INSERT INTO Projects (Name, Color, StartOn, WorkspaceId, DueOn, public, UserId) VALUES ('ProjectName', 'dark-pink', '2020-03-01', '1126938837961830', '2020-04-30', false, '1130062547672468')
Inserting multiple Followers into Projects table. For example:
INSERT INTO Projects (WorkspaceId, Followers) VALUES ('1126938837961830', '1206414724399714,1207035318501516' )
Update
Following is an example of how to update a Projects table:
UPDATE Projects SET TeamId = '1129514033997890' WHERE Id = '1128092864672888'
Delete
Following is an example of how to delete from Projects table:
DELETE FROM Projects WHERE Id = '1128092864672888'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique ID of the project. | |
Name | String | False |
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. | |
Color | String | False |
Color of the project. Must be either null or one of: dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-yellow, light-orange, light-purple, light-warm-gray. 使用できる値は次のとおりです。dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-brown, light-orange, light-purple, light-warm-gray, green, yellow, red | |
CreatedAt | Datetime | True |
The time at which this project was created. | |
ModifiedAt | Datetime | True |
The time at which this project was last modified. | |
StartOn | Date | False |
The day on which work for this project begins, or null if the project has no start date. This takes a date with YYYY-MM-DD format. Note: due_on must be present in the request when setting or unsetting the start_on parameter. | |
DueOn | Date | False |
The day on which this project is due. This takes a date with format YYYY-MM-DD. | |
DefaultView | String | False |
The default view of a project. 使用できる値は次のとおりです。list, board, calendar, timeline | |
Followers | String | False |
Followers are a subset of members who receive all notifications for a project. | |
Archived | Boolean | False |
True if the project is archived, false if not. Archived projects do not show in the UI by default and may be treated differently for queries. | |
UserId | String | False |
Users.Id |
The current owner of the project. |
TeamId | String | False |
Teams.Id |
The team that this project is shared with. This field only exists for projects in organizations. |
WorkspaceId | String | True |
Workspaces.Id |
The workspace or organization this project is associated with. Once created, projects cannot be moved to a different workspace. This attribute can only be specified at creation time. |
Public | Boolean | False |
True if the project is public to the organization. If false, do not share this project with other users in this organization without explicitly checking to see if they have access. For new integrations, please refer to PrivacySetting column. | |
Notes | String | False |
More detailed, free-form textual information associated with the project. | |
HTMLNotes | String | False |
The notes of the project with formatting as HTML. | |
IsTemplate | Boolean | False |
Determines if the project is a template. | |
Layout | String | True |
The layout (board or list view) of a project. | |
Members | String | True |
Array of users who are members of this project. | |
SectionMigrationStatus | String | True |
The section migration status of this project. | |
PrivacySetting | String | False |
The privacy setting of the project. | |
TaskId | String | True |
Tasks.Id |
Globally unique ID of the Task. |
ItemURL | String | True |
A url that points directly to the object within Asana. |