Skip to main content

subscriptions

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

Overview

Namesubscriptions
TypeResource
Idazure_stack.user_subscriptions.subscriptions

Fields

NameDatatypeDescription
idstringFully qualified identifier.
displayNamestringSubscription name.
offerIdstringIdentifier of the offer under the scope of a delegated provider.
statestringSubscription notification state.
subscriptionIdstringSubscription identifier.
tenantIdstringDirectory tenant identifier.

Methods

NameAccessible byRequired ParamsDescription
getSELECTsubscriptionIdGets details about particular subscription.
listSELECTGet the list of subscriptions.
create_or_updateINSERTsubscriptionIdCreate or updates a subscription.
deleteDELETEsubscriptionIdDelete the specified subscription.

SELECT examples

Get the list of subscriptions.

SELECT
id,
displayName,
offerId,
state,
subscriptionId,
tenantId
FROM azure_stack.user_subscriptions.subscriptions
;

INSERT example

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

/*+ create */
INSERT INTO azure_stack.user_subscriptions.subscriptions (
subscriptionId,
displayName,
id,
offerId,
state,
subscriptionId,
tenantId
)
SELECT
'{{ subscriptionId }}',
'{{ displayName }}',
'{{ id }}',
'{{ offerId }}',
'{{ state }}',
'{{ subscriptionId }}',
'{{ tenantId }}'
;

DELETE example

Deletes the specified subscriptions resource.

/*+ delete */
DELETE FROM azure_stack.user_subscriptions.subscriptions
WHERE subscriptionId = '{{ subscriptionId }}';