To Create, Update, Delete and Query the Projects table
Table Specific Information
The cmdlet 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 cmdlet.
- Id supports the '=' comparison.
- workspaceId supports the '=' comparison.
- TaskId 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'
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')
Following is an example of how to update a Projects table:
UPDATE Projects SET TeamId = '1129514033997890' WHERE Id = '1128092864672888'
Following is an example of how to delete from Projects table:
DELETE FROM Projects WHERE Id = '1128092864672888'
Globally unique ID of the project.
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 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
The allowed values are 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.
The time at which this project was created.
The time at which this project was last modified.
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.
The day on which this project is due. This takes a date with format YYYY-MM-DD.
The default view of a project.
The allowed values are list, board, calendar, timeline.
Followers are a subset of members who receive all notifications for a project
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.
The current owner of the project.
The team that this project is shared with. This field only exists for projects in organizations.
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.
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.
More detailed, free-form textual information associated with the project.
The notes of the project with formatting as HTML.
Determines if the project is a template.
The layout (board or list view) of a project
Array of users who are members of this project.
The section migration status of this project.
Globally unique ID of the Task.