Tableau Connector for Asana

Build 20.0.7695

Projects

To Create, Update, Delete and Query the Projects table

Table Specific Information

Select

The connector 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 connector.

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

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

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

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.

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.

The allowed values are 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.

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.

TaskId String True

Globally unique ID of the Task.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695