Skip to main content

professional_service_subscription_levels

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

Overview

Nameprofessional_service_subscription_levels
TypeResource
Idazure_extras.professional_services.professional_service_subscription_levels

Fields

The following fields are returned by SELECT queries:

Request successful. The request returns the resulting ProfessionalService resource.

NameDatatypeDescription
idstringThe resource uri
namestringThe name of the resource
propertiesobjectprofessionalService resource properties
tagsobjectthe resource tags.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, resourceNameGets information about the specified Subscription Level ProfessionalService.
list_by_resource_groupselectsubscriptionId, resourceGroupNameGets information about all the Subscription Level ProfessionalService in a certain resource group.
list_by_azure_subscriptionselectsubscriptionIdGets information about all the Subscription Level ProfessionalService in a certain Azure subscription.
create_or_updateinsertsubscriptionId, resourceGroupName, resourceNameCreates or updates a ProfessionalService resource.
deletedeletesubscriptionId, resourceGroupName, resourceNameDeletes the specified ProfessionalService.

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
resourceGroupNamestringThe name of the resource group.
resourceNamestringThe name of the resource.
subscriptionIdstringThe Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000)

SELECT examples

Gets information about the specified Subscription Level ProfessionalService.

SELECT
id,
name,
properties,
tags,
type
FROM azure_extras.professional_services.professional_service_subscription_levels
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND resourceName = '{{ resourceName }}' -- required
;

INSERT examples

Creates or updates a ProfessionalService resource.

INSERT INTO azure_extras.professional_services.professional_service_subscription_levels (
data__name,
data__tags,
data__location,
data__properties,
subscriptionId,
resourceGroupName,
resourceName
)
SELECT
'{{ name }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ resourceName }}'
RETURNING
id,
name,
properties,
tags,
type
;

DELETE examples

Deletes the specified ProfessionalService.

DELETE FROM azure_extras.professional_services.professional_service_subscription_levels
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND resourceName = '{{ resourceName }}' --required
;