ADO.NET Provider for Asana

Build 20.0.7655

WorkspaceMembership

To Create, Delete and Query memberships in the Workspace

Table Specific Information

Select

The {i 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 {i.

  • Id supports the '=' comparison.
  • UserId supports the '=' comparison.
  • WorkspaceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkspaceMembership WHERE WorkspaceId = '1126938837961830'

SELECT * FROM WorkspaceMembership WHERE UserId = '1126938691750986'

SELECT * FROM WorkspaceMembership WHERE Id = '1126938837961834'

Insert

UserId and WorkspaceId is a mandatory column for inserting into WorkspaceMembership table. For example:

INSERT INTO WorkspaceMembership (UserId, WorkspaceId) VALUES ('1161963899354167','1126938837961830')

Delete

Following is an example of how to delete from WorkspaceMembership table:

DELETE FROM WorkspaceMembership WHERE UserId = '1161963899354167' AND WorkspaceId = '1126938837961830'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the membership.

userId [KEY] String True

Globally unique ID of the user.

userName String True

The user`s name.

WorkspaceId [KEY] String True

Globally unique ID of the workspace.

WorkspaceName String True

The Workspace name

IsActive Boolean True

Reflects if this user still a member of the workspace.

IsAdmin Boolean True

Reflects if this user is an admin of the workspace.

IsGuest Boolean True

Reflects if this user is a guest of the workspace.

UserTaskListId String True

A user task list represents the tasks assigned to a particular user.

ResourceType String True

The base type of this resource.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655