offers

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

Overview

Name	offers
Type	Resource
Id	azure_stack.subscriptions_admin.offers

Fields

vw_offers

Name	Datatype	Description
id	text	URI of the resource.
name	text	Name of the resource.
description	text	field from the properties object
addon_plans	text	field from the properties object
base_plan_ids	text	field from the properties object
display_name	text	field from the properties object
external_reference_id	text	field from the properties object
location	text	Location of the resource
max_subscriptions_per_account	text	field from the properties object
offer	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
subscription_count	text	field from the properties object
tags	text	List of key-value pairs.
type	text	Type of resource.

offers

Name	Datatype	Description
id	string	URI of the resource.
name	string	Name of the resource.
location	string	Location of the resource
properties	object	Represents an offering of services against which a subscription can be created.
tags	object	List of key-value pairs.
type	string	Type of resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	offer, resourceGroupName, subscriptionId	Get the specified offer.
list	SELECT	resourceGroupName, subscriptionId	Get the list of offers under a resource group.
list_all	SELECT	subscriptionId	Get the list of offers.
create_or_update	INSERT	offer, resourceGroupName, subscriptionId	Create or update the offer.
delete	DELETE	offer, resourceGroupName, subscriptionId	Delete the specified offer.
link	EXEC	offer, resourceGroupName, subscriptionId	Links a plan to an offer.
unlink	EXEC	offer, resourceGroupName, subscriptionId	Unlink a plan from an offer.

SELECT examples

Get the list of offers.

vw_offers

SELECT
id,
name,
description,
addon_plans,
base_plan_ids,
display_name,
external_reference_id,
location,
max_subscriptions_per_account,
offer,
resourceGroupName,
state,
subscriptionId,
subscription_count,
tags,
type
FROM azure_stack.subscriptions_admin.vw_offers
WHERE subscriptionId = '{{ subscriptionId }}';

offers

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_stack.subscriptions_admin.offers
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_stack.subscriptions_admin.offers (
offer,
resourceGroupName,
subscriptionId,
properties,
location
)
SELECT 
'{{ offer }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: name
          value: string
        - name: displayName
          value: string
        - name: description
          value: string
        - name: externalReferenceId
          value: string
        - name: state
          value: []
        - name: subscriptionCount
          value: integer
        - name: maxSubscriptionsPerAccount
          value: integer
        - name: basePlanIds
          value:
            - string
        - name: addonPlans
          value:
            - - name: planId
                value: string
              - name: maxAcquisitionCount
                value: integer
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified offers resource.

/*+ delete */
DELETE FROM azure_stack.subscriptions_admin.offers
WHERE offer = '{{ offer }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';