Skip to main content

express_route_circuits

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

Overview

Nameexpress_route_circuits
TypeResource
Idazure.network.express_route_circuits

Fields

The following fields are returned by SELECT queries:

Request successful. The operation returns the resulting ExpressRouteCircuit resource.

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
etagstringA unique read-only string that changes whenever the resource is updated.
propertiesobjectProperties of the express route circuit.
skuobjectThe SKU.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
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
getselectresourceGroupName, circuitName, subscriptionIdGets information about the specified express route circuit.
listselectresourceGroupName, subscriptionIdGets all the express route circuits in a resource group.
list_allselectsubscriptionIdGets all the express route circuits in a subscription.
create_or_updateinsertresourceGroupName, circuitName, subscriptionIdCreates or updates an express route circuit.
deletedeleteresourceGroupName, circuitName, subscriptionIdDeletes the specified express route circuit.
update_tagsexecresourceGroupName, circuitName, subscriptionIdUpdates an express route circuit tags.

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
circuitNamestringThe name of the circuit.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets information about the specified express route circuit.

SELECT
id,
name,
etag,
properties,
sku,
systemData,
type
FROM azure.network.express_route_circuits
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND circuitName = '{{ circuitName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Creates or updates an express route circuit.

INSERT INTO azure.network.express_route_circuits (
data__sku,
data__properties,
resourceGroupName,
circuitName,
subscriptionId
)
SELECT
'{{ sku }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ circuitName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
etag,
properties,
sku,
systemData,
type
;

DELETE examples

Deletes the specified express route circuit.

DELETE FROM azure.network.express_route_circuits
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND circuitName = '{{ circuitName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;

Lifecycle Methods

Updates an express route circuit tags.

EXEC azure.network.express_route_circuits.update_tags 
@resourceGroupName='{{ resourceGroupName }}' --required,
@circuitName='{{ circuitName }}' --required,
@subscriptionId='{{ subscriptionId }}' --required
@@json=
'{
"tags": "{{ tags }}"
}'
;