Skip to main content

slots

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

Overview

Nameslots
TypeResource
Idazure.app_service.slots

Fields

The following fields are returned by SELECT queries:

OK.

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
extendedLocationobjectExtended Location.
identityobjectManaged service identity.
propertiesobjectSite resource specific properties
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, name, slot, subscriptionIdDescription for Gets the details of a web, mobile, or API app.
listselectresourceGroupName, name, subscriptionIdDescription for Gets an app's deployment slots.
create_or_updateinsertresourceGroupName, name, slot, subscriptionIdDescription for Creates a new web, mobile, or API app in an existing resource group, or updates an existing app.
updateupdateresourceGroupName, name, slot, subscriptionIdDescription for Creates a new web, mobile, or API app in an existing resource group, or updates an existing app.
deletedeleteresourceGroupName, name, slot, subscriptionIddeleteMetrics, deleteEmptyServerFarmDescription for Deletes a web, mobile, or API app, or one of the deployment slots.

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 to delete.
resourceGroupNamestringName of the resource group to which the resource belongs.
slotstringName of the deployment slot to delete. By default, the API deletes the production slot.
subscriptionIdstringYour Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000).
deleteEmptyServerFarmbooleanSpecify false if you want to keep empty App Service plan. By default, empty App Service plan is deleted.
deleteMetricsbooleanIf true, web app metrics are also deleted.

SELECT examples

Description for Gets the details of a web, mobile, or API app.

SELECT
id,
name,
extendedLocation,
identity,
properties,
systemData,
type
FROM azure.app_service.slots
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND name = '{{ name }}' -- required
AND slot = '{{ slot }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Description for Creates a new web, mobile, or API app in an existing resource group, or updates an existing app.

INSERT INTO azure.app_service.slots (
data__properties,
data__identity,
data__extendedLocation,
resourceGroupName,
name,
slot,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ identity }}',
'{{ extendedLocation }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ slot }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
extendedLocation,
identity,
properties,
systemData,
type
;

UPDATE examples

Description for Creates a new web, mobile, or API app in an existing resource group, or updates an existing app.

UPDATE azure.app_service.slots
SET
data__kind = '{{ kind }}',
data__properties = '{{ properties }}',
data__identity = '{{ identity }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND slot = '{{ slot }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
extendedLocation,
identity,
properties,
systemData,
type;

DELETE examples

Description for Deletes a web, mobile, or API app, or one of the deployment slots.

DELETE FROM azure.app_service.slots
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND slot = '{{ slot }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND deleteMetrics = '{{ deleteMetrics }}'
AND deleteEmptyServerFarm = '{{ deleteEmptyServerFarm }}'
;