action_requests

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

Overview

Name	action_requests
Type	Resource
Id	azure_extras.test_base.action_requests

Fields

vw_action_requests

Name	Datatype	Description
actionRequestName	text	field from the properties object
creation_date	text	field from the properties object
pre_release_access_request_spec	text	field from the properties object
provisioning_state	text	field from the properties object
request_type	text	field from the properties object
resourceGroupName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
testBaseAccountName	text	field from the properties object

action_requests

Name	Datatype	Description
properties	object

Methods

Name	Accessible by	Required Params	Description
get	SELECT	actionRequestName, resourceGroupName, subscriptionId, testBaseAccountName	Get the action request under the specified test base account.
list	SELECT	resourceGroupName, subscriptionId, testBaseAccountName	List all action requests under the specified test base account.
delete	DELETE	actionRequestName, resourceGroupName, subscriptionId, testBaseAccountName	Delete (revoke) an action request. Only requests in review can be deleted.
put	REPLACE	actionRequestName, resourceGroupName, subscriptionId, testBaseAccountName	Create (submit) an action request.

SELECT examples

List all action requests under the specified test base account.

vw_action_requests

SELECT
actionRequestName,
creation_date,
pre_release_access_request_spec,
provisioning_state,
request_type,
resourceGroupName,
status,
subscriptionId,
testBaseAccountName
FROM azure_extras.test_base.vw_action_requests
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

action_requests

SELECT
properties
FROM azure_extras.test_base.action_requests
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

REPLACE example

Replaces all fields in the specified action_requests resource.

/*+ update */
REPLACE azure_extras.test_base.action_requests
SET 
properties = '{{ properties }}'
WHERE 
actionRequestName = '{{ actionRequestName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';

DELETE example

Deletes the specified action_requests resource.

/*+ delete */
DELETE FROM azure_extras.test_base.action_requests
WHERE actionRequestName = '{{ actionRequestName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND testBaseAccountName = '{{ testBaseAccountName }}';