Skip to main content

private_stores

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

Overview

Nameprivate_stores
TypeResource
Idazure_extras.marketplace.private_stores

Fields

The following fields are returned by SELECT queries:

OK. The request has succeeded.

NameDatatypeDescription
idstringThe resource ID.
namestringThe name of the resource.
propertiesobjectThe PrivateStore data structure.
systemDataobjectMetadata pertaining to creation and last modification of the resource
typestringThe type of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectprivateStoreIdGet information about the private store
listselectGets the list of available private stores.
create_or_updateinsertprivateStoreIdChanges private store properties
deletedeleteprivateStoreIdDeletes the private store. All that is not saved will be lost.
any_existing_offers_in_the_collectionsexecprivateStoreIdQuery whether exists any offer in the collections.
query_offersexecprivateStoreIdList of offers, regardless the collections
query_user_offersexecprivateStoreIdList of user's approved offers for the provided offers and subscriptions
billing_accountsexecprivateStoreIdTenant billing accounts names
collections_to_subscriptions_mappingexecprivateStoreIdFor a given subscriptions list, the API will return a map of collections and the related subscriptions from the supplied list.
query_approved_plansexecprivateStoreIdGet map of plans and related approved subscriptions.
bulk_collections_actionexecprivateStoreIdPerform an action on bulk collections
query_request_approvalexecprivateStoreId, requestApprovalIdGet request statuses foreach plan, this api is used as a complex GET action.
admin_request_approvals_listexecprivateStoreIdGet list of admin request approvals
query_notifications_stateexecprivateStoreIdGet private store notifications state
acknowledge_offer_notificationexecprivateStoreId, offerIdAcknowledge notification for offer
withdraw_planexecprivateStoreId, requestApprovalIdWithdraw a user request approval on specific plan
fetch_all_subscriptions_in_tenantexecprivateStoreIdnext-page-tokenFetch all subscriptions in tenant, only for marketplace admin

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
offerIdstringThe offer ID to update or delete
privateStoreIdstringThe store ID - must use the tenant ID
requestApprovalIdstringThe request approval ID to get create or update
next-page-tokenstringThe skip token to get the next page.

SELECT examples

Get information about the private store

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

INSERT examples

Changes private store properties

INSERT INTO azure_extras.marketplace.private_stores (
data__properties,
privateStoreId
)
SELECT
'{{ properties }}',
'{{ privateStoreId }}'
;

DELETE examples

Deletes the private store. All that is not saved will be lost.

DELETE FROM azure_extras.marketplace.private_stores
WHERE privateStoreId = '{{ privateStoreId }}' --required
;

Lifecycle Methods

Query whether exists any offer in the collections.

EXEC azure_extras.marketplace.private_stores.any_existing_offers_in_the_collections 
@privateStoreId='{{ privateStoreId }}' --required
;