Skip to main content

plans_vnet_routes

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

Overview

Nameplans_vnet_routes
TypeResource
Idazure.app_service.plans_vnet_routes

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_or_updateinsertresourceGroupName, name, vnetName, routeName, subscriptionIdDescription for Create or update a Virtual Network route in an App Service plan.
updateupdateresourceGroupName, name, vnetName, routeName, subscriptionIdDescription for Create or update a Virtual Network route in an App Service plan.
deletedeleteresourceGroupName, name, vnetName, routeName, subscriptionIdDescription for Delete a Virtual Network route in an App Service plan.

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
namestringName of the App Service plan.
resourceGroupNamestringName of the resource group to which the resource belongs.
routeNamestringName of the Virtual Network route.
subscriptionIdstringYour Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000).
vnetNamestringName of the Virtual Network.

INSERT examples

Description for Create or update a Virtual Network route in an App Service plan.

INSERT INTO azure.app_service.plans_vnet_routes (
data__kind,
data__properties,
resourceGroupName,
name,
vnetName,
routeName,
subscriptionId
)
SELECT
'{{ kind }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ vnetName }}',
'{{ routeName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
kind,
properties,
type
;

UPDATE examples

Description for Create or update a Virtual Network route in an App Service plan.

UPDATE azure.app_service.plans_vnet_routes
SET
data__kind = '{{ kind }}',
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND vnetName = '{{ vnetName }}' --required
AND routeName = '{{ routeName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
kind,
properties,
type;

DELETE examples

Description for Delete a Virtual Network route in an App Service plan.

DELETE FROM azure.app_service.plans_vnet_routes
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND vnetName = '{{ vnetName }}' --required
AND routeName = '{{ routeName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;