workspace_named_values

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

Overview

Name	workspace_named_values
Type	Resource
Id	azure.api_management.workspace_named_values

Fields

vw_workspace_named_values

Name	Datatype	Description
display_name	text	field from the properties object
key_vault	text	field from the properties object
namedValueId	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
secret	text	field from the properties object
serviceName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	field from the properties object
value	text	field from the properties object
workspaceId	text	field from the properties object

workspace_named_values

Name	Datatype	Description
properties	object	NamedValue Contract properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	namedValueId, resourceGroupName, serviceName, subscriptionId, workspaceId	Gets the details of the named value specified by its identifier.
list_by_service	SELECT	resourceGroupName, serviceName, subscriptionId, workspaceId	Lists a collection of named values defined within a workspace in a service instance.
create_or_update	INSERT	namedValueId, resourceGroupName, serviceName, subscriptionId, workspaceId	Creates or updates named value.
delete	DELETE	If-Match, namedValueId, resourceGroupName, serviceName, subscriptionId, workspaceId	Deletes specific named value from the workspace in an API Management service instance.
update	UPDATE	If-Match, namedValueId, resourceGroupName, serviceName, subscriptionId, workspaceId	Updates the specific named value.
refresh_secret	EXEC	namedValueId, resourceGroupName, serviceName, subscriptionId, workspaceId	Refresh the secret of the named value specified by its identifier.

SELECT examples

Lists a collection of named values defined within a workspace in a service instance.

vw_workspace_named_values

SELECT
display_name,
key_vault,
namedValueId,
provisioning_state,
resourceGroupName,
secret,
serviceName,
subscriptionId,
tags,
value,
workspaceId
FROM azure.api_management.vw_workspace_named_values
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceId = '{{ workspaceId }}';

workspace_named_values

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

INSERT example

Use the following StackQL query and manifest file to create a new workspace_named_values resource.

All Properties

/*+ create */
INSERT INTO azure.api_management.workspace_named_values (
namedValueId,
resourceGroupName,
serviceName,
subscriptionId,
workspaceId,
properties
)
SELECT 
'{{ namedValueId }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ workspaceId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: displayName
          value: string
        - name: value
          value: string
        - name: keyVault
          value:
            - name: secretIdentifier
              value: string
            - name: identityClientId
              value: string
        - name: tags
          value:
            - string
        - name: secret
          value: boolean

UPDATE example

Updates a workspace_named_values resource.

/*+ update */
UPDATE azure.api_management.workspace_named_values
SET 
properties = '{{ properties }}'
WHERE 
If-Match = '{{ If-Match }}'
AND namedValueId = '{{ namedValueId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceId = '{{ workspaceId }}';

DELETE example

Deletes the specified workspace_named_values resource.

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