web_apps

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

Overview

Name	web_apps
Type	Resource
Id	azure.app_service.web_apps

Fields

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource Name.
kind	string	Kind of resource.
properties	object	ProcessModuleInfo resource specific properties
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId	Description for Gets the details of a web, mobile, or API app.
get_diagnostic_logs_config	SELECT	name, resourceGroupName, subscriptionId	Description for Gets the logging configuration of an app.
get_diagnostic_logs_config_slot	SELECT	name, resourceGroupName, slot, subscriptionId	Description for Gets the logging configuration of an app.
get_instance_function_slot	SELECT	functionName, name, resourceGroupName, slot, subscriptionId	Description for Get function information by its ID for web site, or a deployment slot.
get_instance_ms_deploy_log	SELECT	instanceId, name, resourceGroupName, subscriptionId	Description for Get the MSDeploy Log for the last MSDeploy operation.
get_instance_ms_deploy_log_slot	SELECT	instanceId, name, resourceGroupName, slot, subscriptionId	Description for Get the MSDeploy Log for the last MSDeploy operation.
get_instance_ms_deploy_status	SELECT	instanceId, name, resourceGroupName, subscriptionId	Description for Get the status of the last MSDeploy operation.
get_instance_ms_deploy_status_slot	SELECT	instanceId, name, resourceGroupName, slot, subscriptionId	Description for Get the status of the last MSDeploy operation.
get_instance_process	SELECT	instanceId, name, processId, resourceGroupName, subscriptionId	Description for Get process information by its ID for a specific scaled-out instance in a web site.
get_instance_process_module	SELECT	baseAddress, instanceId, name, processId, resourceGroupName, subscriptionId	Description for Get process information by its ID for a specific scaled-out instance in a web site.
get_instance_process_module_slot	SELECT	baseAddress, instanceId, name, processId, resourceGroupName, slot, subscriptionId	Description for Get process information by its ID for a specific scaled-out instance in a web site.
get_instance_process_slot	SELECT	instanceId, name, processId, resourceGroupName, slot, subscriptionId	Description for Get process information by its ID for a specific scaled-out instance in a web site.
get_instance_workflow_slot	SELECT	name, resourceGroupName, slot, subscriptionId, workflowName
list	SELECT	subscriptionId	Description for Get all apps for a subscription.
list_backup_slots	SELECT	name, resourceGroupName, slot, subscriptionId	Description for Gets existing backups of an app.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Description for Gets all web, mobile, and API apps in the specified resource group.
list_instance_functions_slot	SELECT	name, resourceGroupName, slot, subscriptionId	Description for List the functions for a web site, or a deployment slot.
list_instance_identifiers	SELECT	name, resourceGroupName, subscriptionId	Description for Gets all scale-out instances of an app.
list_instance_identifiers_slot	SELECT	name, resourceGroupName, slot, subscriptionId	Description for Gets all scale-out instances of an app.
list_instance_process_modules	SELECT	instanceId, name, processId, resourceGroupName, subscriptionId	Description for List module information for a process by its ID for a specific scaled-out instance in a web site.
list_instance_process_modules_slot	SELECT	instanceId, name, processId, resourceGroupName, slot, subscriptionId	Description for List module information for a process by its ID for a specific scaled-out instance in a web site.
list_instance_process_threads	SELECT	instanceId, name, processId, resourceGroupName, subscriptionId	Description for List the threads in a process by its ID for a specific scaled-out instance in a web site.
list_instance_process_threads_slot	SELECT	instanceId, name, processId, resourceGroupName, slot, subscriptionId	Description for List the threads in a process by its ID for a specific scaled-out instance in a web site.
list_instance_processes	SELECT	instanceId, name, resourceGroupName, subscriptionId	Description for Get list of processes for a web site, or a deployment slot, or for a specific scaled-out instance in a web site.
list_instance_processes_slot	SELECT	instanceId, name, resourceGroupName, slot, subscriptionId	Description for Get list of processes for a web site, or a deployment slot, or for a specific scaled-out instance in a web site.
list_instance_workflows_slot	SELECT	name, resourceGroupName, slot, subscriptionId
create_or_update	INSERT	name, resourceGroupName, subscriptionId	Description for Creates a new web, mobile, or API app in an existing resource group, or updates an existing app.
delete	DELETE	name, resourceGroupName, subscriptionId	Description for Deletes a web, mobile, or API app, or one of the deployment slots.
delete_instance_function_slot	DELETE	functionName, name, resourceGroupName, slot, subscriptionId	Description for Delete a function for web site, or a deployment slot.
delete_instance_process	DELETE	instanceId, name, processId, resourceGroupName, subscriptionId	Description for Terminate a process by its ID for a web site, or a deployment slot, or specific scaled-out instance in a web site.
delete_instance_process_slot	DELETE	instanceId, name, processId, resourceGroupName, slot, subscriptionId	Description for Terminate a process by its ID for a web site, or a deployment slot, or specific scaled-out instance in a web site.
update	UPDATE	name, resourceGroupName, subscriptionId	Description for Creates a new web, mobile, or API app in an existing resource group, or updates an existing app.
add_premier_add_on	EXEC	name, premierAddOnName, resourceGroupName, subscriptionId	Description for Updates a named add-on of an app.
add_premier_add_on_slot	EXEC	name, premierAddOnName, resourceGroupName, slot, subscriptionId	Description for Updates a named add-on of an app.
analyze_custom_hostname	EXEC	name, resourceGroupName, subscriptionId	Description for Analyze a custom hostname.
analyze_custom_hostname_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Analyze a custom hostname.
apply_slot_config_to_production	EXEC	name, resourceGroupName, subscriptionId, data__preserveVnet, data__targetSlot	Description for Applies the configuration settings from the target slot onto the current slot.
apply_slot_configuration_slot	EXEC	name, resourceGroupName, slot, subscriptionId, data__preserveVnet, data__targetSlot	Description for Applies the configuration settings from the target slot onto the current slot.
approve_or_reject_private_endpoint_connection	EXEC	name, privateEndpointConnectionName, resourceGroupName, subscriptionId	Description for Approves or rejects a private endpoint connection
approve_or_reject_private_endpoint_connection_slot	EXEC	name, privateEndpointConnectionName, resourceGroupName, slot, subscriptionId	Description for Approves or rejects a private endpoint connection
backup	EXEC	name, resourceGroupName, subscriptionId	Description for Creates a backup of an app.
backup_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Creates a backup of an app.
deploy_workflow_artifacts	EXEC	name, resourceGroupName, subscriptionId	Description for Creates the artifacts for web site, or a deployment slot.
deploy_workflow_artifacts_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Creates the artifacts for web site, or a deployment slot.
discover_backup	EXEC	name, resourceGroupName, subscriptionId	Description for Discovers an existing app backup that can be restored from a blob in Azure storage. Use this to get information about the databases stored in a backup.
discover_backup_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Discovers an existing app backup that can be restored from a blob in Azure storage. Use this to get information about the databases stored in a backup.
generate_new_site_publishing_password	EXEC	name, resourceGroupName, subscriptionId	Description for Generates a new publishing password for an app (or deployment slot, if specified).
generate_new_site_publishing_password_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Generates a new publishing password for an app (or deployment slot, if specified).
get_instance_process_dump	EXEC	instanceId, name, processId, resourceGroupName, subscriptionId	Description for Get a memory dump of a process by its ID for a specific scaled-out instance in a web site.
get_instance_process_dump_slot	EXEC	instanceId, name, processId, resourceGroupName, slot, subscriptionId	Description for Get a memory dump of a process by its ID for a specific scaled-out instance in a web site.
install_site_extension	EXEC	name, resourceGroupName, siteExtensionId, subscriptionId	Description for Install site extension on a web site, or a deployment slot.
install_site_extension_slot	EXEC	name, resourceGroupName, siteExtensionId, slot, subscriptionId	Description for Install site extension on a web site, or a deployment slot.
is_cloneable	EXEC	name, resourceGroupName, subscriptionId	Description for Shows whether an app can be cloned to another resource group or subscription.
is_cloneable_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Shows whether an app can be cloned to another resource group or subscription.
migrate_my_sql	EXEC	name, resourceGroupName, subscriptionId	Description for Migrates a local (in-app) MySql database to a remote MySql database.
migrate_storage	EXEC	name, resourceGroupName, subscriptionId, subscriptionName	Description for Restores a web app.
put_private_access_vnet	EXEC	name, resourceGroupName, subscriptionId	Description for Sets data around private site access enablement and authorized Virtual Networks that can access the site.
put_private_access_vnet_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Sets data around private site access enablement and authorized Virtual Networks that can access the site.
recover_site_configuration_snapshot	EXEC	name, resourceGroupName, snapshotId, subscriptionId	Description for Reverts the configuration of an app to a previous snapshot.
recover_site_configuration_snapshot_slot	EXEC	name, resourceGroupName, slot, snapshotId, subscriptionId	Description for Reverts the configuration of an app to a previous snapshot.
reset_production_slot_config	EXEC	name, resourceGroupName, subscriptionId	Description for Resets the configuration settings of the current slot if they were previously modified by calling the API with POST.
reset_slot_configuration_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Resets the configuration settings of the current slot if they were previously modified by calling the API with POST.
restart	EXEC	name, resourceGroupName, subscriptionId	Description for Restarts an app (or deployment slot, if specified).
restart_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Restarts an app (or deployment slot, if specified).
restore	EXEC	backupId, name, resourceGroupName, subscriptionId	Description for Restores a specific backup to another app (or deployment slot, if specified).
restore_from_backup_blob	EXEC	name, resourceGroupName, subscriptionId	Description for Restores an app from a backup blob in Azure Storage.
restore_from_backup_blob_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Restores an app from a backup blob in Azure Storage.
restore_from_deleted_app	EXEC	name, resourceGroupName, subscriptionId	Description for Restores a deleted web app to this web app.
restore_from_deleted_app_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Restores a deleted web app to this web app.
restore_slot	EXEC	backupId, name, resourceGroupName, slot, subscriptionId	Description for Restores a specific backup to another app (or deployment slot, if specified).
restore_snapshot	EXEC	name, resourceGroupName, subscriptionId	Description for Restores a web app from a snapshot.
restore_snapshot_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Restores a web app from a snapshot.
run_triggered_web_job	EXEC	name, resourceGroupName, subscriptionId, webJobName	Description for Run a triggered web job for an app, or a deployment slot.
run_triggered_web_job_slot	EXEC	name, resourceGroupName, slot, subscriptionId, webJobName	Description for Run a triggered web job for an app, or a deployment slot.
start	EXEC	name, resourceGroupName, subscriptionId	Description for Starts an app (or deployment slot, if specified).
start_continuous_web_job	EXEC	name, resourceGroupName, subscriptionId, webJobName	Description for Start a continuous web job for an app, or a deployment slot.
start_continuous_web_job_slot	EXEC	name, resourceGroupName, slot, subscriptionId, webJobName	Description for Start a continuous web job for an app, or a deployment slot.
start_network_trace	EXEC	name, resourceGroupName, subscriptionId	Description for Start capturing network packets for the site.
start_network_trace_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Start capturing network packets for the site.
start_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Starts an app (or deployment slot, if specified).
start_web_site_network_trace	EXEC	name, resourceGroupName, subscriptionId	Description for Start capturing network packets for the site (To be deprecated).
start_web_site_network_trace_operation	EXEC	name, resourceGroupName, subscriptionId	Description for Start capturing network packets for the site.
start_web_site_network_trace_operation_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Start capturing network packets for the site.
start_web_site_network_trace_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Start capturing network packets for the site (To be deprecated).
stop	EXEC	name, resourceGroupName, subscriptionId	Description for Stops an app (or deployment slot, if specified).
stop_continuous_web_job	EXEC	name, resourceGroupName, subscriptionId, webJobName	Description for Stop a continuous web job for an app, or a deployment slot.
stop_continuous_web_job_slot	EXEC	name, resourceGroupName, slot, subscriptionId, webJobName	Description for Stop a continuous web job for an app, or a deployment slot.
stop_network_trace	EXEC	name, resourceGroupName, subscriptionId	Description for Stop ongoing capturing network packets for the site.
stop_network_trace_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Stop ongoing capturing network packets for the site.
stop_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Stops an app (or deployment slot, if specified).
stop_web_site_network_trace	EXEC	name, resourceGroupName, subscriptionId	Description for Stop ongoing capturing network packets for the site.
stop_web_site_network_trace_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Stop ongoing capturing network packets for the site.
swap_slot_slot	EXEC	name, resourceGroupName, slot, subscriptionId, data__preserveVnet, data__targetSlot	Description for Swaps two deployment slots of an app.
swap_slot_with_production	EXEC	name, resourceGroupName, subscriptionId, data__preserveVnet, data__targetSlot	Description for Swaps two deployment slots of an app.
sync_function_triggers	EXEC	name, resourceGroupName, subscriptionId	Description for Syncs function trigger metadata to the management database
sync_function_triggers_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Syncs function trigger metadata to the management database
sync_functions	EXEC	name, resourceGroupName, subscriptionId	Description for Syncs function trigger metadata to the management database
sync_functions_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Syncs function trigger metadata to the management database
sync_repository	EXEC	name, resourceGroupName, subscriptionId	Description for Sync web app repository.
sync_repository_slot	EXEC	name, resourceGroupName, slot, subscriptionId	Description for Sync web app repository.

SELECT examples

Description for Get all apps for a subscription.

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.web_apps (
name,
resourceGroupName,
subscriptionId,
kind,
location,
tags,
properties,
identity,
extendedLocation
)
SELECT 
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ kind }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ identity }}',
'{{ extendedLocation }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: kind
      value: string
    - name: location
      value: string
    - name: type
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: state
          value: string
        - name: hostNames
          value:
            - string
        - name: repositorySiteName
          value: string
        - name: usageState
          value: string
        - name: enabled
          value: boolean
        - name: enabledHostNames
          value:
            - string
        - name: availabilityState
          value: string
        - name: hostNameSslStates
          value:
            - - name: name
                value: string
              - name: sslState
                value: string
              - name: virtualIP
                value: string
              - name: thumbprint
                value: string
              - name: toUpdate
                value: boolean
              - name: hostType
                value: string
        - name: serverFarmId
          value: string
        - name: reserved
          value: boolean
        - name: isXenon
          value: boolean
        - name: hyperV
          value: boolean
        - name: lastModifiedTimeUtc
          value: string
        - name: dnsConfiguration
          value:
            - name: dnsServers
              value:
                - string
            - name: dnsAltServer
              value: string
            - name: dnsRetryAttemptTimeout
              value: integer
            - name: dnsRetryAttemptCount
              value: integer
            - name: dnsMaxCacheTimeout
              value: integer
            - name: dnsLegacySortOrder
              value: boolean
        - name: vnetRouteAllEnabled
          value: boolean
        - name: vnetImagePullEnabled
          value: boolean
        - name: vnetContentShareEnabled
          value: boolean
        - name: vnetBackupRestoreEnabled
          value: boolean
        - name: siteConfig
          value:
            - name: numberOfWorkers
              value: integer
            - name: defaultDocuments
              value:
                - string
            - name: netFrameworkVersion
              value: string
            - name: phpVersion
              value: string
            - name: pythonVersion
              value: string
            - name: nodeVersion
              value: string
            - name: powerShellVersion
              value: string
            - name: linuxFxVersion
              value: string
            - name: windowsFxVersion
              value: string
            - name: requestTracingEnabled
              value: boolean
            - name: requestTracingExpirationTime
              value: string
            - name: remoteDebuggingEnabled
              value: boolean
            - name: remoteDebuggingVersion
              value: string
            - name: httpLoggingEnabled
              value: boolean
            - name: acrUseManagedIdentityCreds
              value: boolean
            - name: acrUserManagedIdentityID
              value: string
            - name: logsDirectorySizeLimit
              value: integer
            - name: detailedErrorLoggingEnabled
              value: boolean
            - name: publishingUsername
              value: string
            - name: appSettings
              value:
                - - name: name
                    value: string
                  - name: value
                    value: string
            - name: metadata
              value:
                - - name: name
                    value: string
                  - name: value
                    value: string
            - name: connectionStrings
              value:
                - - name: name
                    value: string
                  - name: connectionString
                    value: string
                  - name: type
                    value: string
            - name: machineKey
              value:
                - name: validation
                  value: string
                - name: validationKey
                  value: string
                - name: decryption
                  value: string
                - name: decryptionKey
                  value: string
            - name: handlerMappings
              value:
                - - name: extension
                    value: string
                  - name: scriptProcessor
                    value: string
                  - name: arguments
                    value: string
            - name: documentRoot
              value: string
            - name: scmType
              value: string
            - name: use32BitWorkerProcess
              value: boolean
            - name: webSocketsEnabled
              value: boolean
            - name: alwaysOn
              value: boolean
            - name: javaVersion
              value: string
            - name: javaContainer
              value: string
            - name: javaContainerVersion
              value: string
            - name: appCommandLine
              value: string
            - name: managedPipelineMode
              value: string
            - name: virtualApplications
              value:
                - - name: virtualPath
                    value: string
                  - name: physicalPath
                    value: string
                  - name: preloadEnabled
                    value: boolean
                  - name: virtualDirectories
                    value:
                      - - name: virtualPath
                          value: string
                        - name: physicalPath
                          value: string
            - name: loadBalancing
              value: string
            - name: experiments
              value:
                - name: rampUpRules
                  value:
                    - - name: actionHostName
                        value: string
                      - name: reroutePercentage
                        value: number
                      - name: changeStep
                        value: number
                      - name: changeIntervalInMinutes
                        value: integer
                      - name: minReroutePercentage
                        value: number
                      - name: maxReroutePercentage
                        value: number
                      - name: changeDecisionCallbackUrl
                        value: string
                      - name: name
                        value: string
            - name: limits
              value:
                - name: maxPercentageCpu
                  value: number
                - name: maxMemoryInMb
                  value: integer
                - name: maxDiskSizeInMb
                  value: integer
            - name: autoHealEnabled
              value: boolean
            - name: autoHealRules
              value:
                - name: triggers
                  value:
                    - name: requests
                      value:
                        - name: count
                          value: integer
                        - name: timeInterval
                          value: string
                    - name: privateBytesInKB
                      value: integer
                    - name: statusCodes
                      value:
                        - - name: status
                            value: integer
                          - name: subStatus
                            value: integer
                          - name: win32Status
                            value: integer
                          - name: count
                            value: integer
                          - name: timeInterval
                            value: string
                          - name: path
                            value: string
                    - name: slowRequests
                      value:
                        - name: timeTaken
                          value: string
                        - name: path
                          value: string
                        - name: count
                          value: integer
                        - name: timeInterval
                          value: string
                    - name: slowRequestsWithPath
                      value:
                        - - name: timeTaken
                            value: string
                          - name: path
                            value: string
                          - name: count
                            value: integer
                          - name: timeInterval
                            value: string
                    - name: statusCodesRange
                      value:
                        - - name: statusCodes
                            value: string
                          - name: path
                            value: string
                          - name: count
                            value: integer
                          - name: timeInterval
                            value: string
                - name: actions
                  value:
                    - name: actionType
                      value: string
                    - name: customAction
                      value:
                        - name: exe
                          value: string
                        - name: parameters
                          value: string
                    - name: minProcessExecutionTime
                      value: string
            - name: tracingOptions
              value: string
            - name: vnetName
              value: string
            - name: vnetRouteAllEnabled
              value: boolean
            - name: vnetPrivatePortsCount
              value: integer
            - name: cors
              value:
                - name: allowedOrigins
                  value:
                    - string
                - name: supportCredentials
                  value: boolean
            - name: push
              value:
                - name: id
                  value: string
                - name: name
                  value: string
                - name: kind
                  value: string
                - name: type
                  value: string
                - name: properties
                  value:
                    - name: isPushEnabled
                      value: boolean
                    - name: tagWhitelistJson
                      value: string
                    - name: tagsRequiringAuth
                      value: string
                    - name: dynamicTagsJson
                      value: string
            - name: apiDefinition
              value:
                - name: url
                  value: string
            - name: apiManagementConfig
              value:
                - name: id
                  value: string
            - name: autoSwapSlotName
              value: string
            - name: localMySqlEnabled
              value: boolean
            - name: managedServiceIdentityId
              value: integer
            - name: xManagedServiceIdentityId
              value: integer
            - name: keyVaultReferenceIdentity
              value: string
            - name: ipSecurityRestrictions
              value:
                - - name: ipAddress
                    value: string
                  - name: subnetMask
                    value: string
                  - name: vnetSubnetResourceId
                    value: string
                  - name: vnetTrafficTag
                    value: integer
                  - name: subnetTrafficTag
                    value: integer
                  - name: action
                    value: string
                  - name: tag
                    value: string
                  - name: priority
                    value: integer
                  - name: name
                    value: string
                  - name: description
                    value: string
                  - name: headers
                    value: object
            - name: ipSecurityRestrictionsDefaultAction
              value: string
            - name: scmIpSecurityRestrictions
              value:
                - - name: ipAddress
                    value: string
                  - name: subnetMask
                    value: string
                  - name: vnetSubnetResourceId
                    value: string
                  - name: vnetTrafficTag
                    value: integer
                  - name: subnetTrafficTag
                    value: integer
                  - name: action
                    value: string
                  - name: tag
                    value: string
                  - name: priority
                    value: integer
                  - name: name
                    value: string
                  - name: description
                    value: string
                  - name: headers
                    value: object
            - name: scmIpSecurityRestrictionsDefaultAction
              value: string
            - name: scmIpSecurityRestrictionsUseMain
              value: boolean
            - name: http20Enabled
              value: boolean
            - name: minTlsVersion
              value: string
            - name: minTlsCipherSuite
              value: string
            - name: scmMinTlsVersion
              value: string
            - name: ftpsState
              value: string
            - name: preWarmedInstanceCount
              value: integer
            - name: functionAppScaleLimit
              value: integer
            - name: elasticWebAppScaleLimit
              value: integer
            - name: healthCheckPath
              value: string
            - name: functionsRuntimeScaleMonitoringEnabled
              value: boolean
            - name: websiteTimeZone
              value: string
            - name: minimumElasticInstanceCount
              value: integer
            - name: azureStorageAccounts
              value: object
            - name: publicNetworkAccess
              value: string
        - name: functionAppConfig
          value:
            - name: deployment
              value:
                - name: storage
                  value:
                    - name: type
                      value: string
                    - name: value
                      value: string
                    - name: authentication
                      value:
                        - name: type
                          value: string
                        - name: userAssignedIdentityResourceId
                          value: string
                        - name: storageAccountConnectionStringName
                          value: string
            - name: runtime
              value:
                - name: name
                  value: string
                - name: version
                  value: string
            - name: scaleAndConcurrency
              value:
                - name: alwaysReady
                  value:
                    - - name: name
                        value: string
                      - name: instanceCount
                        value: integer
                - name: maximumInstanceCount
                  value: integer
                - name: instanceMemoryMB
                  value: integer
                - name: triggers
                  value:
                    - name: http
                      value:
                        - name: perInstanceConcurrency
                          value: integer
        - name: daprConfig
          value:
            - name: enabled
              value: boolean
            - name: appId
              value: string
            - name: appPort
              value: integer
            - name: httpReadBufferSize
              value: integer
            - name: httpMaxRequestSize
              value: integer
            - name: logLevel
              value: string
            - name: enableApiLogging
              value: boolean
        - name: workloadProfileName
          value: string
        - name: resourceConfig
          value:
            - name: cpu
              value: number
            - name: memory
              value: string
        - name: trafficManagerHostNames
          value:
            - string
        - name: scmSiteAlsoStopped
          value: boolean
        - name: targetSwapSlot
          value: string
        - name: hostingEnvironmentProfile
          value:
            - name: id
              value: string
            - name: name
              value: string
            - name: type
              value: string
        - name: clientAffinityEnabled
          value: boolean
        - name: clientCertEnabled
          value: boolean
        - name: clientCertMode
          value: string
        - name: clientCertExclusionPaths
          value: string
        - name: hostNamesDisabled
          value: boolean
        - name: customDomainVerificationId
          value: string
        - name: outboundIpAddresses
          value: string
        - name: possibleOutboundIpAddresses
          value: string
        - name: containerSize
          value: integer
        - name: dailyMemoryTimeQuota
          value: integer
        - name: suspendedTill
          value: string
        - name: maxNumberOfWorkers
          value: integer
        - name: cloningInfo
          value:
            - name: correlationId
              value: string
            - name: overwrite
              value: boolean
            - name: cloneCustomHostNames
              value: boolean
            - name: cloneSourceControl
              value: boolean
            - name: sourceWebAppId
              value: string
            - name: sourceWebAppLocation
              value: string
            - name: hostingEnvironment
              value: string
            - name: appSettingsOverrides
              value: object
            - name: configureLoadBalancing
              value: boolean
            - name: trafficManagerProfileId
              value: string
            - name: trafficManagerProfileName
              value: string
        - name: resourceGroup
          value: string
        - name: isDefaultContainer
          value: boolean
        - name: defaultHostName
          value: string
        - name: slotSwapStatus
          value:
            - name: timestampUtc
              value: string
            - name: sourceSlotName
              value: string
            - name: destinationSlotName
              value: string
        - name: httpsOnly
          value: boolean
        - name: redundancyMode
          value: string
        - name: inProgressOperationId
          value: string
        - name: publicNetworkAccess
          value: string
        - name: storageAccountRequired
          value: boolean
        - name: keyVaultReferenceIdentity
          value: string
        - name: virtualNetworkSubnetId
          value: string
        - name: managedEnvironmentId
          value: string
    - name: identity
      value:
        - name: type
          value: string
        - name: tenantId
          value: string
        - name: principalId
          value: string
        - name: userAssignedIdentities
          value: object
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: string

UPDATE example

Updates a web_apps resource.

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

DELETE example

Deletes the specified web_apps resource.

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