Skip to main content

workspace_policies

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

Overview

Nameworkspace_policies
TypeResource
Idazure.api_management.workspace_policies

Fields

The following fields are returned by SELECT queries:

Workspace Policy information.

NameDatatypeDescription
propertiesobjectProperties of the Policy.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, serviceName, workspaceId, policyId, subscriptionIdformatGet the policy configuration at the API level.
list_by_apiselectresourceGroupName, serviceName, workspaceId, subscriptionIdGet the policy configuration at the workspace level.
create_or_updateinsertresourceGroupName, serviceName, workspaceId, policyId, subscriptionIdIf-MatchCreates or updates policy configuration for the workspace.
deletedeleteresourceGroupName, serviceName, workspaceId, policyId, If-Match, subscriptionIdDeletes the policy configuration at the workspace.

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.
policyIdstringThe identifier of the Policy.
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.
If-MatchstringETag of the Entity. Not required when creating an entity, but required when updating an entity.
formatstringPolicy Export Format.

SELECT examples

Get the policy configuration at the API level.

SELECT
properties
FROM azure.api_management.workspace_policies
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serviceName = '{{ serviceName }}' -- required
AND workspaceId = '{{ workspaceId }}' -- required
AND policyId = '{{ policyId }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND format = '{{ format }}'
;

INSERT examples

Creates or updates policy configuration for the workspace.

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

DELETE examples

Deletes the policy configuration at the workspace.

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