Skip to main content

team_invitations

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

Overview​

Nameteam_invitations
TypeResource
Idnvidia.orgs.team_invitations

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringUnique invitation ID
namestringuser name
created_datestringDate on which the invitation was created. (ISO-8601 format) (wire: createdDate)
emailstringEmail address of the user.
is_processedbooleanFlag indicating if the invitation has already been accepted by the user. (wire: isProcessed)
orgstringOrg to which a user was invited.
rolesarrayList of roles that the user have.
teamstringTeam to which a user was invited.
typestringType of invitation. The invitation is either to an organization or to a team within organization. (ORGANIZATION, TEAM)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectteam_namepage_number, page_size, order_by, qList invitations in a team. (Team User Admin privileges required)
create_ncainsertteam_nameInvites and creates a User in team
deletedeleteteam_name, idDelete a specific invitation in an team. (Org Admin or Team User Admin privileges required)
resend_emailexecteam_name, idResend email of a specific invitation in a team (Org or Team User Admin privileges required).

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
team_namestring
order_bystring (wire: orderBy)
page_numberinteger (int32)The page number of result
page_sizeinteger (int32)The page size of result
qobjectUser Search Parameters

SELECT examples​

List invitations in a team. (Team User Admin privileges required)

SELECT
id,
name,
created_date,
email,
is_processed,
org,
roles,
team,
type
FROM nvidia.orgs.team_invitations
WHERE team_name = '{{ team_name }}' -- required
AND page_number = '{{ page_number }}'
AND page_size = '{{ page_size }}'
AND order_by = '{{ order_by }}'
AND q = '{{ q }}'
;

INSERT examples​

Invites and creates a User in team

INSERT INTO nvidia.orgs.team_invitations (
email,
invitation_expiration_in,
invite_as,
message,
team_name
)
SELECT
'{{ email }}',
{{ invitation_expiration_in }},
'{{ invite_as }}',
'{{ message }}',
'{{ team_name }}'
RETURNING
activation_token,
nca_role,
request_status,
user,
user_roles
;

DELETE examples​

Delete a specific invitation in an team. (Org Admin or Team User Admin privileges required)

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

Lifecycle Methods​

EXEC variables use wire (API) names.

Resend email of a specific invitation in a team (Org or Team User Admin privileges required).

EXEC nvidia.orgs.team_invitations.resend_email
@team_name='{{ team_name }}' --required,
@id='{{ id }}' --required
;