CData Python Connector for Asana

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062