Skip to main content

express_route_port_authorizations

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

Overview

Nameexpress_route_port_authorizations
TypeResource
Idazure.network.express_route_port_authorizations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringName of the resource.
authorizationKeystringThe authorization key.
authorizationUseStatusstringThe authorization use status. Known values are: "Available" and "InUse". (Available, InUse)
circuitResourceUristringThe reference to the ExpressRoute circuit resource using the authorization.
etagstringA unique read-only string that changes whenever the resource is updated.
provisioningStatestringThe provisioning state of the authorization resource. Known values are: "Failed", "Succeeded", "Canceled", "Creating", "Updating", and "Deleting". (Failed, Succeeded, Canceled, Creating, Updating, Deleting)
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, express_route_port_name, authorization_name, subscription_idGets the specified authorization from the specified express route port.
listselectresource_group_name, express_route_port_name, subscription_idGets all authorizations in an express route port.
create_or_updateinsertresource_group_name, express_route_port_name, authorization_name, subscription_idCreates or updates an authorization in the specified express route port.
create_or_updatereplaceresource_group_name, express_route_port_name, authorization_name, subscription_idCreates or updates an authorization in the specified express route port.
deletedeleteresource_group_name, express_route_port_name, authorization_name, subscription_idDeletes the specified authorization from the specified express route port.

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
authorization_namestringThe name of the authorization. Required.
express_route_port_namestringThe name of the express route port. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets the specified authorization from the specified express route port.

SELECT
id,
name,
authorizationKey,
authorizationUseStatus,
circuitResourceUri,
etag,
provisioningState,
type
FROM azure.network.express_route_port_authorizations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND express_route_port_name = '{{ express_route_port_name }}' -- required
AND authorization_name = '{{ authorization_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates an authorization in the specified express route port.

INSERT INTO azure.network.express_route_port_authorizations (
id,
name,
properties,
resource_group_name,
express_route_port_name,
authorization_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ name }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ express_route_port_name }}',
'{{ authorization_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties,
type
;

REPLACE examples

Creates or updates an authorization in the specified express route port.

REPLACE azure.network.express_route_port_authorizations
SET
id = '{{ id }}',
name = '{{ name }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND express_route_port_name = '{{ express_route_port_name }}' --required
AND authorization_name = '{{ authorization_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
properties,
type;

DELETE examples

Deletes the specified authorization from the specified express route port.

DELETE FROM azure.network.express_route_port_authorizations
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND express_route_port_name = '{{ express_route_port_name }}' --required
AND authorization_name = '{{ authorization_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;