Skip to main content

workspace_named_values

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

Overview

Nameworkspace_named_values
TypeResource
Idazure.api_management.workspace_named_values

Fields

The following fields are returned by SELECT queries:

The response body contains the specified named value entity. No secrets included

NameDatatypeDescription
propertiesobjectNamedValue entity contract properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, serviceName, workspaceId, namedValueId, subscriptionIdGets the details of the named value specified by its identifier.
list_by_serviceselectresourceGroupName, serviceName, workspaceId, subscriptionId$filter, $top, $skip, isKeyVaultRefreshFailedLists a collection of named values defined within a workspace in a service instance.
create_or_updateinsertresourceGroupName, serviceName, workspaceId, namedValueId, subscriptionIdIf-MatchCreates or updates named value.
updateupdateresourceGroupName, serviceName, workspaceId, namedValueId, If-Match, subscriptionIdUpdates the specific named value.
deletedeleteresourceGroupName, serviceName, workspaceId, namedValueId, If-Match, subscriptionIdDeletes specific named value from the workspace in an API Management service instance.
refresh_secretexecresourceGroupName, serviceName, workspaceId, namedValueId, subscriptionIdRefresh 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
If-MatchstringETag of the Entity. ETag should match the current entity state from the header response of the GET request or it should be * for unconditional update.
namedValueIdstringIdentifier of the NamedValue.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
serviceNamestringThe name of the API Management service.
subscriptionIdstringThe ID of the target subscription.
workspaceIdstringWorkspace identifier. Must be unique in the current API Management service instance.
$filterstring| Field | Usage | Supported operators | Supported functions |</br>|-------------|-------------|-------------|-------------|</br>| tags | filter | ge, le, eq, ne, gt, lt | substringof, contains, startswith, endswith, any, all |</br>| displayName | filter | ge, le, eq, ne, gt, lt | substringof, contains, startswith, endswith |</br>
$skipinteger (int32)Number of records to skip.
$topinteger (int32)Number of records to return.
If-MatchstringETag of the Entity. Not required when creating an entity, but required when updating an entity.
isKeyVaultRefreshFailedstringQuery parameter to fetch named value entities based on refresh status.

SELECT examples

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

SELECT
properties
FROM azure.api_management.workspace_named_values
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serviceName = '{{ serviceName }}' -- required
AND workspaceId = '{{ workspaceId }}' -- required
AND namedValueId = '{{ namedValueId }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Creates or updates named value.

INSERT INTO azure.api_management.workspace_named_values (
data__properties,
resourceGroupName,
serviceName,
workspaceId,
namedValueId,
subscriptionId,
If-Match
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ workspaceId }}',
'{{ namedValueId }}',
'{{ subscriptionId }}',
'{{ If-Match }}'
RETURNING
properties
;

UPDATE examples

Updates the specific named value.

UPDATE azure.api_management.workspace_named_values
SET
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND serviceName = '{{ serviceName }}' --required
AND workspaceId = '{{ workspaceId }}' --required
AND namedValueId = '{{ namedValueId }}' --required
AND If-Match = '{{ If-Match }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
properties;

DELETE examples

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

DELETE FROM azure.api_management.workspace_named_values
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND serviceName = '{{ serviceName }}' --required
AND workspaceId = '{{ workspaceId }}' --required
AND namedValueId = '{{ namedValueId }}' --required
AND If-Match = '{{ If-Match }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;

Lifecycle Methods

Refresh the secret of the named value specified by its identifier.

EXEC azure.api_management.workspace_named_values.refresh_secret 
@resourceGroupName='{{ resourceGroupName }}' --required,
@serviceName='{{ serviceName }}' --required,
@workspaceId='{{ workspaceId }}' --required,
@namedValueId='{{ namedValueId }}' --required,
@subscriptionId='{{ subscriptionId }}' --required
;