students

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

Overview

Name	students
Type	Resource
Id	azure_extras.education.students

Fields

vw_students

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
budget	text	field from the properties object
effective_date	text	field from the properties object
email	text	field from the properties object
expiration_date	text	field from the properties object
first_name	text	field from the properties object
invoiceSectionName	text	field from the properties object
last_name	text	field from the properties object
role	text	field from the properties object
status	text	field from the properties object
studentAlias	text	field from the properties object
subscription_alias	text	field from the properties object
subscription_id	text	field from the properties object
subscription_invite_last_sent_date	text	field from the properties object
system_data	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

students

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Student detail properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	billingAccountName, billingProfileName, invoiceSectionName, studentAlias	Get the details for a specific student in the specified lab by student alias
list	SELECT	billingAccountName, billingProfileName, invoiceSectionName	Get a list of details about students that are associated with the specified lab.
create_or_update	INSERT	billingAccountName, billingProfileName, invoiceSectionName, studentAlias	Create and add a new student to the specified lab or update the details of an existing student in a lab. Note the student must have a valid tenant to accept the lab after they have been added to lab.
delete	DELETE	billingAccountName, billingProfileName, invoiceSectionName, studentAlias	Delete the specified student based on the student alias.

SELECT examples

Get a list of details about students that are associated with the specified lab.

vw_students

SELECT
id,
name,
billingAccountName,
billingProfileName,
budget,
effective_date,
email,
expiration_date,
first_name,
invoiceSectionName,
last_name,
role,
status,
studentAlias,
subscription_alias,
subscription_id,
subscription_invite_last_sent_date,
system_data,
type
FROM azure_extras.education.vw_students
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}';

students

SELECT
id,
name,
properties,
systemData,
type
FROM azure_extras.education.students
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}';

INSERT example

Use the following StackQL query and manifest file to create a new students resource.

All Properties

/*+ create */
INSERT INTO azure_extras.education.students (
billingAccountName,
billingProfileName,
invoiceSectionName,
studentAlias,
properties
)
SELECT 
'{{ billingAccountName }}',
'{{ billingProfileName }}',
'{{ invoiceSectionName }}',
'{{ studentAlias }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: firstName
          value: string
        - name: lastName
          value: string
        - name: email
          value: string
        - name: role
          value: string
        - name: budget
          value:
            - name: currency
              value: string
            - name: value
              value: number
        - name: subscriptionId
          value: string
        - name: expirationDate
          value: string
        - name: status
          value: string
        - name: effectiveDate
          value: string
        - name: subscriptionAlias
          value: string
        - name: subscriptionInviteLastSentDate
          value: string

DELETE example

Deletes the specified students resource.

/*+ delete */
DELETE FROM azure_extras.education.students
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}'
AND studentAlias = '{{ studentAlias }}';