Skip to main content

members

Creates, updates, deletes, gets or lists a members resource.

Overview

Namemembers
TypeResource
Idanthropic_admin.workspaces.members

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
user_idstringID of the User.
workspace_idstringID of the Workspace.
typestringObject type. Always `workspace_member`. (workspace_member)
workspace_rolestringRole of the Workspace Member. (workspace_admin, workspace_billing, workspace_developer, workspace_restricted_developer, workspace_user)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectworkspace_id, user_idGet a workspace member.
listselectworkspace_idbefore_id, after_idList members of a workspace.
createinsertworkspace_id, user_id, workspace_roleAdd an organization member to a workspace. The role cannot be workspace_billing.
updateupdateworkspace_id, user_id, workspace_roleUpdate a workspace member's role.
deletedeleteworkspace_id, user_idRemove a member from a workspace.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
user_idstringID of the User.
workspace_idstringID of the Workspace.
after_idstringID of the object to use as a cursor for pagination. Returns the page of results immediately after this object.
before_idstringID of the object to use as a cursor for pagination. Returns the page of results immediately before this object.

SELECT examples

Get a workspace member.

SELECT
user_id,
workspace_id,
type,
workspace_role
FROM anthropic_admin.workspaces.members
WHERE workspace_id = '{{ workspace_id }}' -- required
AND user_id = '{{ user_id }}' -- required
;

INSERT examples

Add an organization member to a workspace. The role cannot be workspace_billing.

INSERT INTO anthropic_admin.workspaces.members (
user_id,
workspace_role,
workspace_id
)
SELECT
'{{ user_id }}' /* required */,
'{{ workspace_role }}' /* required */,
'{{ workspace_id }}'
RETURNING
user_id,
workspace_id,
type,
workspace_role
;

UPDATE examples

Update a workspace member's role.

UPDATE anthropic_admin.workspaces.members
SET
workspace_role = '{{ workspace_role }}'
WHERE
workspace_id = '{{ workspace_id }}' --required
WHERE user_id = '{{ user_id }}' --required
AND workspace_role = '{{ workspace_role }}' --required
RETURNING
user_id,
workspace_id,
type,
workspace_role;

DELETE examples

Remove a member from a workspace.

DELETE FROM anthropic_admin.workspaces.members
WHERE workspace_id = '{{ workspace_id }}' --required
AND user_id = '{{ user_id }}' --required
;