private_store_collection_offers

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

Overview

Name	private_store_collection_offers
Type	Resource
Id	azure_extras.marketplace.private_store_collection_offers

Fields

vw_private_store_collection_offers

Name	Datatype	Description
id	text	The resource ID.
name	text	The name of the resource.
collectionId	text	field from the properties object
created_at	text	field from the properties object
e_tag	text	field from the properties object
icon_file_uris	text	field from the properties object
modified_at	text	field from the properties object
offerId	text	field from the properties object
offer_display_name	text	field from the properties object
plans	text	field from the properties object
privateStoreId	text	field from the properties object
private_store_id	text	field from the properties object
publisher_display_name	text	field from the properties object
specific_plan_ids_limitation	text	field from the properties object
system_data	text	field from the properties object
type	text	The type of the resource.
unique_offer_id	text	field from the properties object
update_suppressed_due_idempotence	text	field from the properties object

private_store_collection_offers

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	collectionId, offerId, privateStoreId	Gets information about a specific offer.
list	SELECT	collectionId, privateStoreId	Get a list of all private offers in the given private store and collection
list_by_contexts	SELECT	collectionId, privateStoreId	Get a list of all offers in the given collection according to the required contexts.
create_or_update	INSERT	collectionId, offerId, privateStoreId	Update or add an offer to a specific collection of the private store.
delete	DELETE	collectionId, offerId, privateStoreId	Deletes an offer from the given collection of private store.
post	EXEC	collectionId, offerId, privateStoreId	Delete Private store offer. This is a workaround.
upsert_offer_with_multi_context	EXEC	collectionId, offerId, privateStoreId	Upsert an offer with multiple context details.

SELECT examples

Get a list of all private offers in the given private store and collection

vw_private_store_collection_offers

SELECT
id,
name,
collectionId,
created_at,
e_tag,
icon_file_uris,
modified_at,
offerId,
offer_display_name,
plans,
privateStoreId,
private_store_id,
publisher_display_name,
specific_plan_ids_limitation,
system_data,
type,
unique_offer_id,
update_suppressed_due_idempotence
FROM azure_extras.marketplace.vw_private_store_collection_offers
WHERE collectionId = '{{ collectionId }}'
AND privateStoreId = '{{ privateStoreId }}';

private_store_collection_offers

SELECT
id,
name,
properties,
systemData,
type
FROM azure_extras.marketplace.private_store_collection_offers
WHERE collectionId = '{{ collectionId }}'
AND privateStoreId = '{{ privateStoreId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.marketplace.private_store_collection_offers (
collectionId,
offerId,
privateStoreId,
properties
)
SELECT 
'{{ collectionId }}',
'{{ offerId }}',
'{{ privateStoreId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: []
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: uniqueOfferId
          value: string
        - name: offerDisplayName
          value: string
        - name: publisherDisplayName
          value: string
        - name: eTag
          value: string
        - name: privateStoreId
          value: string
        - name: createdAt
          value: string
        - name: modifiedAt
          value: string
        - name: specificPlanIdsLimitation
          value:
            - string
        - name: updateSuppressedDueIdempotence
          value: boolean
        - name: iconFileUris
          value: object
        - name: plans
          value:
            - - name: skuId
                value: string
              - name: planId
                value: string
              - name: planDisplayName
                value: string
              - name: accessibility
                value: string
              - name: altStackReference
                value: string
              - name: stackType
                value: string

DELETE example

Deletes the specified private_store_collection_offers resource.

/*+ delete */
DELETE FROM azure_extras.marketplace.private_store_collection_offers
WHERE collectionId = '{{ collectionId }}'
AND offerId = '{{ offerId }}'
AND privateStoreId = '{{ privateStoreId }}';