Skip to main content

host_secrets

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

Overview

Namehost_secrets
TypeResource
Idazure.app_service.host_secrets

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, keyType, keyName, subscriptionIdDescription for Add or update a host level secret.
deletedeleteresourceGroupName, name, keyType, keyName, subscriptionIdDescription for Delete a host level secret.

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
keyNamestringThe name of the key.
keyTypestringThe type of host key.
namestringSite name.
resourceGroupNamestringName of the resource group to which the resource belongs.
subscriptionIdstringYour Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000).

INSERT examples

Description for Add or update a host level secret.

INSERT INTO azure.app_service.host_secrets (
data__name,
data__value,
resourceGroupName,
name,
keyType,
keyName,
subscriptionId
)
SELECT
'{{ name }}',
'{{ value }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ keyType }}',
'{{ keyName }}',
'{{ subscriptionId }}'
RETURNING
name,
value
;

DELETE examples

Description for Delete a host level secret.

DELETE FROM azure.app_service.host_secrets
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND name = '{{ name }}' --required
AND keyType = '{{ keyType }}' --required
AND keyName = '{{ keyName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;