Skip to main content

workspace_named_value

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

Overview

Nameworkspace_named_value
TypeResource
Idazure.api_management.workspace_named_value

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.
displayNamestringUnique name of NamedValue. It may contain only letters, digits, period, dash, and underscore characters. Required.
keyVaultobjectKeyVault location details of the namedValue.
provisioningStatestringThe provisioning state.
secretbooleanDetermines whether the value is a secret and should be encrypted or not. Default value is false.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsarrayOptional tags that when provided can be used to filter the NamedValue list.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
valuestringValue of the NamedValue. Can contain policy expressions. It may not be empty or consist only of whitespace. This property will not be filled on 'GET' operations! Use '/listSecrets' POST request to get the value.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, service_name, workspace_id, named_value_id, subscription_idGets the details of the named value specified by its identifier.
list_by_serviceselectresource_group_name, service_name, workspace_id, subscription_id$filter, $top, $skip, isKeyVaultRefreshFailedLists a collection of named values defined within a workspace in a service instance.
create_or_updateinsertresource_group_name, service_name, workspace_id, named_value_id, subscription_idCreates or updates named value.
updateupdateresource_group_name, service_name, workspace_id, named_value_id, subscription_idUpdates the specific named value.
create_or_updatereplaceresource_group_name, service_name, workspace_id, named_value_id, subscription_idCreates or updates named value.
deletedeleteresource_group_name, service_name, workspace_id, named_value_id, subscription_idDeletes specific named value from the workspace in an API Management service instance.
get_entity_tagexecresource_group_name, service_name, workspace_id, named_value_id, subscription_idGets the entity state (Etag) version of the named value specified by its identifier.
list_valueexecresource_group_name, service_name, workspace_id, named_value_id, subscription_idGets the secret of the named value specified by its identifier.
refresh_secretexecresource_group_name, service_name, workspace_id, named_value_id, subscription_idRefresh the secret of the named value specified by its identifier.

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
named_value_idstringIdentifier of the NamedValue. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
service_namestringThe name of the API Management service. Required.
subscription_idstring
workspace_idstringWorkspace identifier. Must be unique in the current API Management service instance. Required.
$filterstring| Field | Usage | Supported operators | Supported functions ||-------------|-------------|-------------|-------------|| tags | filter | ge, le, eq, ne, gt, lt | substringof, contains, startswith, endswith, any, all || displayName | filter | ge, le, eq, ne, gt, lt | substringof, contains, startswith, endswith |. Default value is None.
$skipintegerNumber of records to skip. Default value is None.
$topintegerNumber of records to return. Default value is None.
isKeyVaultRefreshFailedstringQuery parameter to fetch named value entities based on refresh status. Known values are: "true" and "false". Default value is None.

SELECT examples

Gets the details of the named value specified by its identifier.

SELECT
id,
name,
displayName,
keyVault,
provisioningState,
secret,
systemData,
tags,
type,
value
FROM azure.api_management.workspace_named_value
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND service_name = '{{ service_name }}' -- required
AND workspace_id = '{{ workspace_id }}' -- required
AND named_value_id = '{{ named_value_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates named value.

INSERT INTO azure.api_management.workspace_named_value (
properties,
resource_group_name,
service_name,
workspace_id,
named_value_id,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ service_name }}',
'{{ workspace_id }}',
'{{ named_value_id }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

UPDATE examples

Updates the specific named value.

UPDATE azure.api_management.workspace_named_value
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND workspace_id = '{{ workspace_id }}' --required
AND named_value_id = '{{ named_value_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

REPLACE examples

Creates or updates named value.

REPLACE azure.api_management.workspace_named_value
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND workspace_id = '{{ workspace_id }}' --required
AND named_value_id = '{{ named_value_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes specific named value from the workspace in an API Management service instance.

DELETE FROM azure.api_management.workspace_named_value
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND workspace_id = '{{ workspace_id }}' --required
AND named_value_id = '{{ named_value_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Gets the entity state (Etag) version of the named value specified by its identifier.

EXEC azure.api_management.workspace_named_value.get_entity_tag 
@resource_group_name='{{ resource_group_name }}' --required,
@service_name='{{ service_name }}' --required,
@workspace_id='{{ workspace_id }}' --required,
@named_value_id='{{ named_value_id }}' --required,
@subscription_id='{{ subscription_id }}' --required
;