Skip to main content

solution_templates

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

Overview

Namesolution_templates
TypeResource
Idazure.workload_orchestration.solution_templates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
capabilitiesarrayList of capabilities. Required.
descriptionstringDescription of Solution template. Required.
eTagstringIf eTag is provided in the response body, it may also be provided as a header per the normal etag convention. Entity tags are used for comparing two or more entities from the same requested resource. HTTP/1.1 uses entity tags in the etag (section 14.19), If-Match (section 14.24), If-None-Match (section 14.26), and If-Range (section 14.27) header fields.
enableExternalValidationbooleanFlag to enable external validation.
latestVersionstringLatest solution template version.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringProvisioning state of resource. Known values are: "Succeeded", "Failed", "Canceled", "Initialized", "InProgress", and "Deleting". (Succeeded, Failed, Canceled, Initialized, InProgress, Deleting)
statestringState of resource. Known values are: "active" and "inactive". (active, inactive)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, solution_template_name, subscription_idGet a Solution Template Resource.
list_by_resource_groupselectresource_group_name, subscription_idList by specified resource group.
list_by_subscriptionselectsubscription_idList by subscription.
create_or_updateinsertresource_group_name, solution_template_name, subscription_id, locationCreate or update a Solution Template Resource.
updateupdateresource_group_name, solution_template_name, subscription_id, locationupdate a Solution Template Resource.
create_or_updatereplaceresource_group_name, solution_template_name, subscription_id, locationCreate or update a Solution Template Resource.
deletedeleteresource_group_name, solution_template_name, subscription_idDelete a Solution Template Resource.
create_versionexecresource_group_name, solution_template_name, subscription_id, solutionTemplateVersionCreate a Solution Template Version Resource.
remove_versionexecresource_group_name, solution_template_name, subscription_id, versionRemove Solution Template Version Resource.

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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
solution_template_namestringThe name of the SolutionTemplate. Required.
subscription_idstring

SELECT examples

Get a Solution Template Resource.

SELECT
id,
name,
capabilities,
description,
eTag,
enableExternalValidation,
latestVersion,
location,
provisioningState,
state,
systemData,
tags,
type
FROM azure.workload_orchestration.solution_templates
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND solution_template_name = '{{ solution_template_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update a Solution Template Resource.

INSERT INTO azure.workload_orchestration.solution_templates (
tags,
location,
properties,
resource_group_name,
solution_template_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ solution_template_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
eTag,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

update a Solution Template Resource.

UPDATE azure.workload_orchestration.solution_templates
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND solution_template_name = '{{ solution_template_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
eTag,
location,
properties,
systemData,
tags,
type;

REPLACE examples

Create or update a Solution Template Resource.

REPLACE azure.workload_orchestration.solution_templates
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND solution_template_name = '{{ solution_template_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
eTag,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a Solution Template Resource.

DELETE FROM azure.workload_orchestration.solution_templates
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND solution_template_name = '{{ solution_template_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Create a Solution Template Version Resource.

EXEC azure.workload_orchestration.solution_templates.create_version 
@resource_group_name='{{ resource_group_name }}' --required,
@solution_template_name='{{ solution_template_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
@@json=
'{
"updateType": "{{ updateType }}",
"version": "{{ version }}",
"solutionTemplateVersion": "{{ solutionTemplateVersion }}"
}'
;