Skip to main content

energy_services

Creates, updates, deletes, gets or lists an energy_services resource.

Overview

Nameenergy_services
TypeResource
Idazure_extras.oep.energy_services

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.
authAppIdstring:vartype auth_app_id: str
dataPartitionNamesarray:vartype data_partition_names: list[~azure.mgmt.oep.models.DataPartitionNames]
dnsNamestring:vartype dns_name: str
locationstringGeo-location where the resource lives. Required.
provisioningStatestringKnown values are: "Unknown", "Succeeded", "Failed", "Canceled", "Creating", "Deleting", and "Updating".
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, resource_name, subscription_idReturns oep resource for a given name.
list_by_resource_groupselectresource_group_name, subscription_idReturns list of oep resources..
list_by_subscriptionselectsubscription_idLists a collection of oep resources under the given Azure Subscription ID.
createinsertresource_group_name, resource_name, subscription_id, locationMethod that gets called if subscribed for ResourceCreationBegin trigger.
updateupdateresource_group_name, resource_name, subscription_idupdate.
deletedeleteresource_group_name, resource_name, subscription_idDeletes oep resource.
list_partitionsexecresource_group_name, resource_name, subscription_idMethod that gets called when list of partitions is requested.
add_partitionexecresource_group_name, resource_name, subscription_idMethod that gets called if new partition is to be added in a resource.
remove_partitionexecresource_group_name, resource_name, subscription_idMethod that gets called if new partition is to be removed from a 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.
resource_namestringThe resource name. Required.
subscription_idstring

SELECT examples

Returns oep resource for a given name.

SELECT
id,
name,
authAppId,
dataPartitionNames,
dnsName,
location,
provisioningState,
systemData,
tags,
type
FROM azure_extras.oep.energy_services
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Method that gets called if subscribed for ResourceCreationBegin trigger.

INSERT INTO azure_extras.oep.energy_services (
properties,
tags,
location,
resource_group_name,
resource_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}' /* required */,
'{{ resource_group_name }}',
'{{ resource_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

update.

UPDATE azure_extras.oep.energy_services
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Deletes oep resource.

DELETE FROM azure_extras.oep.energy_services
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Method that gets called when list of partitions is requested.

EXEC azure_extras.oep.energy_services.list_partitions 
@resource_group_name='{{ resource_group_name }}' --required,
@resource_name='{{ resource_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;