To represents a users connection to a team.
Table Specific Information
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.
- 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'
UserId and TeamId is a mandatory column for inserting into TeamMembership table. For example:
INSERT INTO TeamMembership (UserId, TeamId) VALUES ('1161963899354167','1126938837961832')
Following is an example of how to delete from TeamMembership table:
DELETE FROM TeamMembership WHERE UserId = '1161963899354167' AND TeamId = '1126938837961832'
Globally unique identifier of the resource, as a string
Globally unique ID of the user.
The users name.
Globally unique ID of the team.
The name of the team.
Describes if the user is a guest in the team.
The base type of this resource.
Globally unique ID of the workspace.