vnet_connections

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

Overview

Name	vnet_connections
Type	Resource
Id	azure.app_service.vnet_connections

Fields

vw_vnet_connections

Name	Datatype	Description
id	text	Resource Id.
name	text	Resource Name.
cert_blob	text	field from the properties object
cert_thumbprint	text	field from the properties object
dns_servers	text	field from the properties object
is_swift	text	field from the properties object
kind	text	Kind of resource.
resourceGroupName	text	field from the properties object
resync_required	text	field from the properties object
routes	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Resource type.
vnetName	text	field from the properties object
vnet_resource_id	text	field from the properties object

vnet_connections

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource Name.
kind	string	Kind of resource.
properties	object	Virtual Network information contract.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId, vnetName	Description for Gets a virtual network the app (or deployment slot) is connected to by name.
list	SELECT	name, resourceGroupName, subscriptionId	Description for Gets the virtual networks the app (or deployment slot) is connected to.
create_or_update	INSERT	name, resourceGroupName, subscriptionId, vnetName	Description for Adds a Virtual Network connection to an app or slot (PUT) or updates the connection properties (PATCH).
delete	DELETE	name, resourceGroupName, subscriptionId, vnetName	Description for Deletes a connection from an app (or deployment slot to a named virtual network.
update	UPDATE	name, resourceGroupName, subscriptionId, vnetName	Description for Adds a Virtual Network connection to an app or slot (PUT) or updates the connection properties (PATCH).

SELECT examples

Description for Gets the virtual networks the app (or deployment slot) is connected to.

vw_vnet_connections

SELECT
id,
name,
cert_blob,
cert_thumbprint,
dns_servers,
is_swift,
kind,
resourceGroupName,
resync_required,
routes,
subscriptionId,
type,
vnetName,
vnet_resource_id
FROM azure.app_service.vw_vnet_connections
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

vnet_connections

SELECT
id,
name,
kind,
properties,
type
FROM azure.app_service.vnet_connections
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.vnet_connections (
name,
resourceGroupName,
subscriptionId,
vnetName,
kind,
properties
)
SELECT 
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ vnetName }}',
'{{ kind }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: kind
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: vnetResourceId
          value: string
        - name: certThumbprint
          value: string
        - name: certBlob
          value: string
        - name: routes
          value:
            - - name: id
                value: string
              - name: name
                value: string
              - name: kind
                value: string
              - name: type
                value: string
              - name: properties
                value:
                  - name: startAddress
                    value: string
                  - name: endAddress
                    value: string
                  - name: routeType
                    value: string
        - name: resyncRequired
          value: boolean
        - name: dnsServers
          value: string
        - name: isSwift
          value: boolean

UPDATE example

Updates a vnet_connections resource.

/*+ update */
UPDATE azure.app_service.vnet_connections
SET 
kind = '{{ kind }}',
properties = '{{ properties }}'
WHERE 
name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vnetName = '{{ vnetName }}';

DELETE example

Deletes the specified vnet_connections resource.

/*+ delete */
DELETE FROM azure.app_service.vnet_connections
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vnetName = '{{ vnetName }}';