TeamMembership
To represents a users connection to a team.
Table Specific Information
Select
The component 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 component.
- Id supports the '=' comparison.
- UserId supports the '=' comparison.
- WorkspaceId supports the '=' comparison.
- TeamId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM TeamMembership WHERE UserId = '1126938691750986' AND WorkspaceId = '1126938837961830' SELECT * FROM TeamMembership WHERE TeamId = '1126938837961832' SELECT * FROM TeamMembership WHERE Id = '1126938837961832'
Insert
UserId and TeamId is a mandatory column for inserting into TeamMembership table. For example:
INSERT INTO TeamMembership (UserId, TeamId) VALUES ('1161963899354167', '1126938837961832')
Delete
Following is an example of how to delete from TeamMembership table:
DELETE FROM TeamMembership WHERE UserId = '1161963899354167' AND TeamId = '1126938837961832'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique identifier of the resource, as a string. | |
userId | String | True |
Globally unique ID of the user. | |
userName | String | True |
The users name. | |
TeamId | String | True |
Globally unique ID of the team. | |
TeamName | String | True |
The name of the team. | |
IsGuest | Boolean | True |
Describes if the user is a guest in the team. | |
ResourceType | String | True |
The base type of this resource. | |
WorkspaceId | String | True |
Globally unique ID of the workspace. |