express_route_ports

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

Overview

Name	express_route_ports
Type	Resource
Id	azure.network.express_route_ports

Fields

vw_express_route_ports

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
allocation_date	text	field from the properties object
bandwidth_in_gbps	text	field from the properties object
billing_type	text	field from the properties object
circuits	text	field from the properties object
encapsulation	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
ether_type	text	field from the properties object
expressRoutePortName	text	field from the properties object
identity	text	Identity for the resource.
links	text	field from the properties object
location	text	Resource location.
mtu	text	field from the properties object
peering_location	text	field from the properties object
provisioned_bandwidth_in_gbps	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_guid	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.

express_route_ports

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
etag	string	A unique read-only string that changes whenever the resource is updated.
identity	object	Identity for the resource.
location	string	Resource location.
properties	object	Properties specific to ExpressRoutePort resources.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	expressRoutePortName, resourceGroupName, subscriptionId	Retrieves the requested ExpressRoutePort resource.
list	SELECT	subscriptionId	List all the ExpressRoutePort resources in the specified subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List all the ExpressRoutePort resources in the specified resource group.
create_or_update	INSERT	expressRoutePortName, resourceGroupName, subscriptionId	Creates or updates the specified ExpressRoutePort resource.
delete	DELETE	expressRoutePortName, resourceGroupName, subscriptionId	Deletes the specified ExpressRoutePort resource.
generate_loa	EXEC	expressRoutePortName, resourceGroupName, subscriptionId, data__customerName	Generate a letter of authorization for the requested ExpressRoutePort resource.
update_tags	EXEC	expressRoutePortName, resourceGroupName, subscriptionId	Update ExpressRoutePort tags.

SELECT examples

List all the ExpressRoutePort resources in the specified subscription.

vw_express_route_ports

SELECT
id,
name,
allocation_date,
bandwidth_in_gbps,
billing_type,
circuits,
encapsulation,
etag,
ether_type,
expressRoutePortName,
identity,
links,
location,
mtu,
peering_location,
provisioned_bandwidth_in_gbps,
provisioning_state,
resourceGroupName,
resource_guid,
subscriptionId,
tags,
type
FROM azure.network.vw_express_route_ports
WHERE subscriptionId = '{{ subscriptionId }}';

express_route_ports

SELECT
id,
name,
etag,
identity,
location,
properties,
tags,
type
FROM azure.network.express_route_ports
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new express_route_ports resource.

All Properties

/*+ create */
INSERT INTO azure.network.express_route_ports (
expressRoutePortName,
resourceGroupName,
subscriptionId,
properties,
identity,
id,
location,
tags
)
SELECT 
'{{ expressRoutePortName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ id }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: peeringLocation
          value: string
        - name: bandwidthInGbps
          value: integer
        - name: provisionedBandwidthInGbps
          value: number
        - name: mtu
          value: string
        - name: encapsulation
          value: string
        - name: etherType
          value: string
        - name: allocationDate
          value: string
        - name: links
          value:
            - - name: properties
                value:
                  - name: routerName
                    value: string
                  - name: interfaceName
                    value: string
                  - name: patchPanelId
                    value: string
                  - name: rackId
                    value: string
                  - name: coloLocation
                    value: string
                  - name: connectorType
                    value: string
                  - name: adminState
                    value: string
                  - name: provisioningState
                    value: []
                  - name: macSecConfig
                    value:
                      - name: cknSecretIdentifier
                        value: string
                      - name: cakSecretIdentifier
                        value: string
                      - name: cipher
                        value: string
                      - name: sciState
                        value: string
              - name: name
                value: string
              - name: etag
                value: string
              - name: id
                value: string
        - name: circuits
          value:
            - - name: id
                value: string
        - name: resourceGuid
          value: string
        - name: billingType
          value: string
    - name: etag
      value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: string
        - name: userAssignedIdentities
          value: object
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified express_route_ports resource.

/*+ delete */
DELETE FROM azure.network.express_route_ports
WHERE expressRoutePortName = '{{ expressRoutePortName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';