Skip to main content

proto_orgs

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

Overview​

Nameproto_orgs
TypeResource
Idnvidia.orgs.proto_orgs

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
proto_org_idstringProto Org identifier. (wire: protoOrgId)
emailstringEmail address of the user.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
validateselectinvitation_tokenValidate org creation from proto org
createinsertCreate a new organization based on the org info retrieved from the ProtoOrg.

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
invitation_tokenstringJWT that contains org owner email and proto org identifier

SELECT examples​

Validate org creation from proto org

SELECT
proto_org_id,
email
FROM nvidia.orgs.proto_orgs
WHERE invitation_token = '{{ invitation_token }}' -- required
;

INSERT examples​

Create a new organization based on the org info retrieved from the ProtoOrg.

INSERT INTO nvidia.orgs.proto_orgs (
country,
description,
display_name,
initiator,
is_internal,
name,
nca_id,
nca_number,
org_owner,
pec_name,
pec_sfdc_id,
product_enablements,
product_subscriptions,
proto_org_id,
salesforce_account_industry,
send_email,
type
)
SELECT
'{{ country }}',
'{{ description }}',
'{{ display_name }}',
'{{ initiator }}',
{{ is_internal }},
'{{ name }}',
'{{ nca_id }}',
'{{ nca_number }}',
'{{ org_owner }}',
'{{ pec_name }}',
'{{ pec_sfdc_id }}',
'{{ product_enablements }}',
'{{ product_subscriptions }}',
'{{ proto_org_id }}',
'{{ salesforce_account_industry }}',
{{ send_email }},
'{{ type }}'
RETURNING
organizations,
request_status
;