Skip to main content

function_secrets

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

Overview

Namefunction_secrets
TypeResource
Idazure.app_service.function_secrets

Fields

The following fields are returned by SELECT queries:

Function secrets returned.

NameDatatypeDescription
keystringSecret key.
trigger_urlstringTrigger URL.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectresourceGroupName, name, functionName, subscriptionIdDescription for Get function secrets for a function in a web site, or a deployment slot.
create_or_updateinsertresourceGroupName, name, functionName, keyName, subscriptionIdDescription for Add or update a function secret.
deletedeleteresourceGroupName, name, functionName, keyName, subscriptionIdDescription for Delete a function 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
functionNamestringThe name of the function.
keyNamestringThe name of the 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).

SELECT examples

Description for Get function secrets for a function in a web site, or a deployment slot.

SELECT
key,
trigger_url
FROM azure.app_service.function_secrets
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND name = '{{ name }}' -- required
AND functionName = '{{ functionName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Description for Add or update a function secret.

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

DELETE examples

Description for Delete a function secret.

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