Skip to main content

virtual_routers

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

Overview

Namevirtual_routers
TypeResource
Idazure.network.virtual_routers

Fields

The following fields are returned by SELECT queries:

Request successful. The operation returns a Virtual Router 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 Virtual Router.
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, virtualRouterName, subscriptionId$expandGets the specified Virtual Router.
list_by_resource_groupselectresourceGroupName, subscriptionIdLists all Virtual Routers in a resource group.
listselectsubscriptionIdGets all the Virtual Routers in a subscription.
create_or_updateinsertresourceGroupName, virtualRouterName, subscriptionIdCreates or updates the specified Virtual Router.
deletedeleteresourceGroupName, virtualRouterName, subscriptionIdDeletes the specified Virtual Router.

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.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
virtualRouterNamestringThe name of the Virtual Router.
$expandstringExpands referenced resources.

SELECT examples

Gets the specified Virtual Router.

SELECT
id,
name,
etag,
properties,
systemData,
type
FROM azure.network.virtual_routers
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND virtualRouterName = '{{ virtualRouterName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND $expand = '{{ $expand }}'
;

INSERT examples

Creates or updates the specified Virtual Router.

INSERT INTO azure.network.virtual_routers (
data__properties,
resourceGroupName,
virtualRouterName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ virtualRouterName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
etag,
properties,
systemData,
type
;

DELETE examples

Deletes the specified Virtual Router.

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