ADO.NET Provider for Asana

Build 20.0.7655

WorkspaceMembership

To Create, Delete and Query memberships in the Workspace

Table Specific Information

Select

The provider 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 provider.

  • 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