Skip to main content

apps

Creates, updates, deletes, gets or lists an apps resource.

Overview

Nameapps
TypeResource
Idazure_extras.app_platform.apps

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource Id for the resource.
namestringThe name of the resource.
addonConfigsobjectCollection of addons.
customPersistentDisksarrayList of custom persistent disks.
enableEndToEndTLSbooleanIndicate if end to end TLS is enabled.
fqdnstringFully qualified dns Name.
httpsOnlybooleanIndicate if only https is allowed.
identityobjectThe Managed Identity type of the app resource.
ingressSettingsobjectApp ingress settings payload.
loadedCertificatesarrayCollection of loaded certificates.
locationstringThe GEO location of the application, always the same with its parent resource.
persistentDiskobjectPersistent disk settings.
provisioningStatestringProvisioning state of the App. Known values are: "Succeeded", "Failed", "Creating", "Updating", and "Deleting".
publicbooleanIndicates whether the App exposes public endpoint.
systemDataobjectMetadata pertaining to creation and last modification of the resource.
temporaryDiskobjectTemporary disk settings.
typestringThe type of the resource.
urlstringURL of the App.
vnetAddonsobjectAdditional App settings in vnet injection instance.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, service_name, app_name, subscription_idsyncStatusGet an App and its properties.
listselectresource_group_name, service_name, subscription_idHandles requests to list all resources in a Service.
create_or_updateinsertresource_group_name, service_name, app_name, subscription_idCreate a new App or update an exiting App.
updateupdateresource_group_name, service_name, app_name, subscription_idOperation to update an exiting App.
create_or_updatereplaceresource_group_name, service_name, app_name, subscription_idCreate a new App or update an exiting App.
deletedeleteresource_group_name, service_name, app_name, subscription_idOperation to delete an App.
get_resource_upload_urlexecresource_group_name, service_name, app_name, subscription_idGet an resource upload URL for an App, which may be artifacts or source archive.
set_active_deploymentsexecresource_group_name, service_name, app_name, subscription_idSet existing Deployment under the app as active.
validate_domainexecresource_group_name, service_name, app_name, subscription_id, nameCheck the resource name is valid as well as not in use.

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
app_namestringThe name of the App resource. Required.
resource_group_namestringThe name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. Required.
service_namestringThe name of the Service resource. Required.
subscription_idstring
syncStatusstringIndicates whether sync status. Default value is None.

SELECT examples

Get an App and its properties.

SELECT
id,
name,
addonConfigs,
customPersistentDisks,
enableEndToEndTLS,
fqdn,
httpsOnly,
identity,
ingressSettings,
loadedCertificates,
location,
persistentDisk,
provisioningState,
public,
systemData,
temporaryDisk,
type,
url,
vnetAddons
FROM azure_extras.app_platform.apps
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND service_name = '{{ service_name }}' -- required
AND app_name = '{{ app_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND syncStatus = '{{ syncStatus }}'
;

INSERT examples

Create a new App or update an exiting App.

INSERT INTO azure_extras.app_platform.apps (
properties,
identity,
location,
resource_group_name,
service_name,
app_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ identity }}',
'{{ location }}',
'{{ resource_group_name }}',
'{{ service_name }}',
'{{ app_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
location,
properties,
systemData,
type
;

UPDATE examples

Operation to update an exiting App.

UPDATE azure_extras.app_platform.apps
SET
properties = '{{ properties }}',
identity = '{{ identity }}',
location = '{{ location }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND app_name = '{{ app_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
location,
properties,
systemData,
type;

REPLACE examples

Create a new App or update an exiting App.

REPLACE azure_extras.app_platform.apps
SET
properties = '{{ properties }}',
identity = '{{ identity }}',
location = '{{ location }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND app_name = '{{ app_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
location,
properties,
systemData,
type;

DELETE examples

Operation to delete an App.

DELETE FROM azure_extras.app_platform.apps
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND app_name = '{{ app_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Get an resource upload URL for an App, which may be artifacts or source archive.

EXEC azure_extras.app_platform.apps.get_resource_upload_url 
@resource_group_name='{{ resource_group_name }}' --required,
@service_name='{{ service_name }}' --required,
@app_name='{{ app_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;