private_store_collections

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

Overview

Name	private_store_collections
Type	Resource
Id	azure_extras.marketplace.private_store_collections

Fields

vw_private_store_collections

Name	Datatype	Description
id	text	The resource ID.
name	text	The name of the resource.
all_subscriptions	text	field from the properties object
applied_rules	text	field from the properties object
approve_all_items	text	field from the properties object
approve_all_items_modified_at	text	field from the properties object
claim	text	field from the properties object
collectionId	text	field from the properties object
collection_id	text	field from the properties object
collection_name	text	field from the properties object
enabled	text	field from the properties object
number_of_offers	text	field from the properties object
privateStoreId	text	field from the properties object
subscriptions_list	text	field from the properties object
system_data	text	field from the properties object
type	text	The type of the resource.

private_store_collections

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	collectionId, privateStoreId	Gets private store collection
list	SELECT	privateStoreId	Gets private store collections list
create_or_update	INSERT	collectionId, privateStoreId	Create or update private store collection
delete	DELETE	collectionId, privateStoreId	Delete a collection from the given private store.
approve_all_items	EXEC	collectionId, privateStoreId	Delete all existing offers from the collection and enable approve all items.
disable_approve_all_items	EXEC	collectionId, privateStoreId	Disable approve all items for the collection.
post	EXEC	collectionId, privateStoreId	Delete Private store collection. This is a workaround.
transfer_offers	EXEC	collectionId, privateStoreId	transferring offers (copy or move) from source collection to target collection(s)

SELECT examples

Gets private store collections list

vw_private_store_collections

SELECT
id,
name,
all_subscriptions,
applied_rules,
approve_all_items,
approve_all_items_modified_at,
claim,
collectionId,
collection_id,
collection_name,
enabled,
number_of_offers,
privateStoreId,
subscriptions_list,
system_data,
type
FROM azure_extras.marketplace.vw_private_store_collections
WHERE privateStoreId = '{{ privateStoreId }}';

private_store_collections

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.marketplace.private_store_collections (
collectionId,
privateStoreId,
properties
)
SELECT 
'{{ collectionId }}',
'{{ 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: collectionId
          value: string
        - name: collectionName
          value: string
        - name: claim
          value: string
        - name: allSubscriptions
          value: boolean
        - name: approveAllItems
          value: boolean
        - name: approveAllItemsModifiedAt
          value: string
        - name: subscriptionsList
          value:
            - string
        - name: enabled
          value: boolean
        - name: numberOfOffers
          value: integer
        - name: appliedRules
          value:
            - - name: type
                value: string
              - name: value
                value:
                  - string

DELETE example

Deletes the specified private_store_collections resource.

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