To Create, Delete and Query memberships in the Portfolio
Table Specific Information
The connector will use the Asana API to process WHERE clause conditions built with the following column and operator. The [WorkspaceId AND UserId] OR PortfolioId OR Id is required to make a request and rest of the filter is executed client side within the connector.
- Id supports the '=' comparison.
- WorkspaceId supports the '=' comparison.
- UserId supports the '=' comparison.
- PortfolioId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PortfolioMembership WHERE WorkspaceId='1172686716695308' AND UserId='1172686741877880' SELECT * FROM PortfolioMembership WHERE PortfolioId='1172684730399265' SELECT * FROM PortfolioMembership WHERE Id='1172684730399266'
PortfolioId and UserId is a mandatory column for inserting into PortfolioMembership table. For example:
INSERT INTO PortfolioMembership (PortfolioId, UserId) VALUES ('1172684730399265', '1172686741877880')
Following is an example of how to delete from PortfolioMembership table:
DELETE FROM PortfolioMembership WHERE PortfolioId='1172684730399265' AND UserId='1172686741877880'
Globally unique ID of the portfoolio membership.
The portfolio the user is a member of.
The name of the portfolio.
Globally unique ID of the user.
The users name.
The resource type of this resource.
Globally unique ID of the workspace. This column is a Pseudocolmn and its used in SELECT Query.