subscription_levels

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

Overview

Name	subscription_levels
Type	Resource
Id	azure_extras.saas.subscription_levels

Fields

Name	Datatype	Description
id	string	The resource uri
name	string	The name of the resource
properties	object	saas properties
tags	object	the resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId	Gets information about the specified Subscription Level SaaS.
list_by_azure_subscription	SELECT	subscriptionId	Gets information about all the Subscription Level SaaS in a certain Azure subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets information about all the Subscription Level SaaS in a certain resource group.
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId	Creates or updates a SaaS resource.
delete	DELETE	resourceGroupName, resourceName, subscriptionId	Deletes the specified SaaS.
update	UPDATE	resourceGroupName, resourceName, subscriptionId	Updates a SaaS Subscription Level resource.
move_resources	EXEC	resourceGroupName, subscriptionId	Move a specified Subscription Level SaaS.
validate_move_resources	EXEC	resourceGroupName, subscriptionId	Validate whether a specified Subscription Level SaaS can be moved.

SELECT examples

Gets information about all the Subscription Level SaaS in a certain Azure subscription.

SELECT
id,
name,
properties,
tags,
type
FROM azure_extras.saas.subscription_levels
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.saas.subscription_levels (
resourceGroupName,
resourceName,
subscriptionId,
name,
tags,
location,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ name }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: tags
      value: []
    - name: location
      value: string
    - name: properties
      value:
        - name: offerId
          value: string
        - name: publisherId
          value: string
        - name: quantity
          value: number
        - name: skuId
          value: string
        - name: paymentChannelType
          value: string
        - name: paymentChannelMetadata
          value: object
        - name: saasResourceName
          value: string
        - name: termId
          value: string
        - name: autoRenew
          value: boolean
        - name: publisherTestEnvironment
          value: string
        - name: saasSubscriptionId
          value: string
        - name: saasSessionId
          value: string

UPDATE example

Updates a subscription_levels resource.

/*+ update */
UPDATE azure_extras.saas.subscription_levels
SET 
name = '{{ name }}',
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified subscription_levels resource.

/*+ delete */
DELETE FROM azure_extras.saas.subscription_levels
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';