Teams
A team is used to group related projects and people together within an organization. Each project in an organization is associated with a team.
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.
- UserId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Teams WHERE Id = '1126938837961832' SELECT * FROM Teams WHERE WorkspaceId = '1126938837961830' SELECT * FROM Teams WHERE UserId = '1126938691750986' AND workspaceid = '1126938837961830'
Insert
WorkspaceId is a mandatory column for inserting into Teams table.In the WorkspaceId only the organisation ID can be used to create teams. Teams can not be created for workspaces which are not part of a organisation. For example:INSERT INTO Teams (Name, Description, HTMLDescrption, WorkspaceId) VALUES ('Salessssk', 'sales developers should be members of this team.', '<body> <em>All</em> developers should be members of this team.</body>', '1126938837961830')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique ID of the team. | |
| Name | String | False |
The name of the team. | |
| Description | String | False |
The description of the team. | |
| WorkspaceId | String | True |
Workspaces.Id |
The workspace or organization this team is associated with. |
| HTMLDescrption | String | False |
The description of the team with formatting as HTML. | |
| ResourceType | String | True |
The resource type of this resource. | |
| ItemURL | String | True |
A url that points directly to the object within Asana. | |
| Visibility | String | False |
The visibility of the team to users in the same organization. 使用できる値は次のとおりです。secret, request_to_join, public | |
| TeamContentManagementAccessLevel | String | False |
Controls who can create and share content with the team. 使用できる値は次のとおりです。no_restriction, only_team_admins | |
| EditTeamNameOrDescriptionAccessLevel | String | True |
Controls who can edit team name and description. 使用できる値は次のとおりです。all_team_members, only_team_admins | |
| EditTeamVisibilityOrTrashTeamAccessLevel | String | True |
Controls who can edit team visibility and trash teams. 使用できる値は次のとおりです。all_team_members, only_team_admins | |
| MemberInviteManagementAccessLevel | String | True |
Controls who can accept or deny member invites for a given team. 使用できる値は次のとおりです。all_team_members, only_team_admins | |
| GuestInviteManagementAccessLevel | String | True |
Controls who can accept or deny guest invites for a given team. 使用できる値は次のとおりです。all_team_members, only_team_admins | |
| JoinRequestManagementAccessLevel | String | True |
Controls who can accept or deny join team requests for a Membership by Request team. 使用できる値は次のとおりです。all_team_members, only_team_admins | |
| TeamMemberRemovalAccessLevel | String | True |
Controls who can remove team members. 使用できる値は次のとおりです。all_team_members, only_team_admins | |
| UserId | String | True |
Users.Id |
Globally unique ID of the user. |