JDBC Driver for Asana

Build 23.0.8839

WorkspaceMembership

To Create, Delete and Query memberships in the Workspace.

Table Specific Information

Select

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

  • 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

Users.Id

Globally unique ID of the user.

userName String True

The user`s name.

WorkspaceId [KEY] String True

Workspaces.Id

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.

VacationStartDate String True

The day on which the user's vacation in this workspace starts.

VacationEndDate String True

The day on which the user's vacation in this workspace ends.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839