join_requests

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

Overview

Name	join_requests
Type	Resource
Id	azure_extras.education.join_requests

Fields

vw_join_requests

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
email	text	field from the properties object
first_name	text	field from the properties object
invoiceSectionName	text	field from the properties object
joinRequestName	text	field from the properties object
last_name	text	field from the properties object
status	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"

join_requests

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	Join request 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, joinRequestName	get student join requests
list	SELECT	billingAccountName, billingProfileName, invoiceSectionName	get student join requests
approve	EXEC	billingAccountName, billingProfileName, invoiceSectionName, joinRequestName	Approve student joining the redeemable lab
deny	EXEC	billingAccountName, billingProfileName, invoiceSectionName, joinRequestName	Deny student joining the redeemable lab

SELECT examples

get student join requests

vw_join_requests

SELECT
id,
name,
billingAccountName,
billingProfileName,
email,
first_name,
invoiceSectionName,
joinRequestName,
last_name,
status,
system_data,
type
FROM azure_extras.education.vw_join_requests
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}';

join_requests

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