Skip to main content

key_values

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

Overview

Namekey_values
TypeResource
Idazure.app_configuration.key_values

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
contentTypestringThe content type of the key-value's value. Providing a proper content-type can enable transformations of values when they are retrieved by applications.
eTagstringAn ETag indicating the state of a key-value within a configuration store.
keystringThe primary identifier of a key-value. The key is used in unison with the label to uniquely identify a key-value.
labelstringA value used to group key-values. The label is used in unison with the key to uniquely identify a key-value.
lastModifiedstring (date-time)The last time a modifying operation was performed on the given key-value.
lockedbooleanA value indicating whether the key-value is locked. A locked key-value may not be modified until it is unlocked.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectA dictionary of tags that can help identify what a key-value may be applicable for.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
valuestringThe value of the key-value.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, config_store_name, key_value_name, subscription_idGets the properties of the specified key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.
create_or_updateinsertresource_group_name, config_store_name, key_value_name, subscription_idCreates a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.
create_or_updatereplaceresource_group_name, config_store_name, key_value_name, subscription_idCreates a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.
deletedeleteresource_group_name, config_store_name, key_value_name, subscription_idDeletes a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

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
config_store_namestringThe name of the configuration store. Required.
key_value_namestringIdentifier of key and label combination. Key and label are joined by $ character. Label is optional. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets the properties of the specified key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

SELECT
id,
name,
contentType,
eTag,
key,
label,
lastModified,
locked,
systemData,
tags,
type,
value
FROM azure.app_configuration.key_values
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND config_store_name = '{{ config_store_name }}' -- required
AND key_value_name = '{{ key_value_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

INSERT INTO azure.app_configuration.key_values (
properties,
resource_group_name,
config_store_name,
key_value_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ config_store_name }}',
'{{ key_value_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Creates a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

REPLACE azure.app_configuration.key_values
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND config_store_name = '{{ config_store_name }}' --required
AND key_value_name = '{{ key_value_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes a key-value. NOTE: This operation is intended for use in ARM Template deployments. For all other scenarios involving App Configuration key-values the data plane API should be used instead.

DELETE FROM azure.app_configuration.key_values
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND config_store_name = '{{ config_store_name }}' --required
AND key_value_name = '{{ key_value_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;