private_store_admin_request_approvals

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

Overview

Name	private_store_admin_request_approvals
Type	Resource
Id	azure_extras.marketplace.private_store_admin_request_approvals

Fields

vw_private_store_admin_request_approvals

Name	Datatype	Description
id	text	The resource ID.
name	text	The name of the resource.
adminRequestApprovalId	text	field from the properties object
admin_action	text	field from the properties object
administrator	text	field from the properties object
approved_plans	text	field from the properties object
collection_ids	text	field from the properties object
comment	text	field from the properties object
display_name	text	field from the properties object
icon	text	field from the properties object
offer_id	text	field from the properties object
plans	text	field from the properties object
privateStoreId	text	field from the properties object
publisherId	text	field from the properties object
publisher_id	text	field from the properties object
system_data	text	field from the properties object
type	text	The type of the resource.

private_store_admin_request_approvals

Name	Datatype	Description
id	string	The resource ID.
name	string	The name of the resource.
properties	object	Admin approval request resource properties
systemData	object	Read only system data
type	string	The type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	adminRequestApprovalId, privateStoreId, publisherId	Get open approval requests
update	REPLACE	adminRequestApprovalId, privateStoreId	Update the admin action, weather the request is approved or rejected and the approved plans

SELECT examples

Get open approval requests

vw_private_store_admin_request_approvals

SELECT
id,
name,
adminRequestApprovalId,
admin_action,
administrator,
approved_plans,
collection_ids,
comment,
display_name,
icon,
offer_id,
plans,
privateStoreId,
publisherId,
publisher_id,
system_data,
type
FROM azure_extras.marketplace.vw_private_store_admin_request_approvals
WHERE adminRequestApprovalId = '{{ adminRequestApprovalId }}'
AND privateStoreId = '{{ privateStoreId }}'
AND publisherId = '{{ publisherId }}';

private_store_admin_request_approvals

SELECT
id,
name,
properties,
systemData,
type
FROM azure_extras.marketplace.private_store_admin_request_approvals
WHERE adminRequestApprovalId = '{{ adminRequestApprovalId }}'
AND privateStoreId = '{{ privateStoreId }}'
AND publisherId = '{{ publisherId }}';

REPLACE example

Replaces all fields in the specified private_store_admin_request_approvals resource.

/*+ update */
REPLACE azure_extras.marketplace.private_store_admin_request_approvals
SET 
properties = '{{ properties }}'
WHERE 
adminRequestApprovalId = '{{ adminRequestApprovalId }}'
AND privateStoreId = '{{ privateStoreId }}';