Skip to main content

team_members

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

Overview​

Nameteam_members
TypeResource
Idnvidia.orgs.team_members

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
activation_tokenstringtoken needed to activate the user to enable login and other features (wire: activationToken)
nca_rolestringNCA role (UNKNOWN, ADMINISTRATOR, MEMBER, OWNER, PENDING) (wire: ncaRole)
request_statusobject (wire: requestStatus)
userobjectinformation about the user
user_rolesarrayDEPRECATED - Please use roles inside user (wire: userRoles)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_by_starfleet_idselectteam_name, starfleet_idGet User details in team by starfleet Id
getselectteam_name, user_email_or_idGet info and role/invitation in a team by email or id
listselectteam_namepage_number, page_size, qGet list of users in team. (User Admin in team privileges required)
addinsertteam_name, idAdd a User to team
createinsertteam_name, emailsend_email, idp_idCreates a User and add them to a team within the org.
removedeleteteam_name, idanonymizeRemove User from team.

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
idstring
starfleet_idstring
team_namestring
user_email_or_idstring
anonymizebooleanIf anonymize is true, then org owner permission is required.
idp_idstringIf the IDP ID is provided then it is used instead of the one configured for the organization
page_numberinteger (int32)The page number of result
page_sizeinteger (int32)The page size of result
qobjectUser Search Parameters. Only 'filters' and 'orderBy' for 'name' and 'email' are implemented
send_emailboolean

SELECT examples​

Get User details in team by starfleet Id

SELECT
activation_token,
nca_role,
request_status,
user,
user_roles
FROM nvidia.orgs.team_members
WHERE team_name = '{{ team_name }}' -- required
AND starfleet_id = '{{ starfleet_id }}' -- required
;

INSERT examples​

Add a User to team

INSERT INTO nvidia.orgs.team_members (
team_name,
id
)
SELECT
'{{ team_name }}',
'{{ id }}'
RETURNING
request_status
;

DELETE examples​

Remove User from team.

DELETE FROM nvidia.orgs.team_members
WHERE team_name = '{{ team_name }}' --required
AND id = '{{ id }}' --required
AND anonymize = '{{ anonymize }}'
;