Skip to main content

workspace_product_policies

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

Overview

Nameworkspace_product_policies
TypeResource
Idazure.api_management.workspace_product_policies

Fields

The following fields are returned by SELECT queries:

Product Policy information.

NameDatatypeDescription
propertiesobjectProperties of the Policy.

Methods

The following methods are available for this resource:

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

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.
productIdstringProduct identifier. Must be unique in the current API Management service instance.
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 Product level.

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

INSERT examples

Creates or updates policy configuration for the Product.

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

DELETE examples

Deletes the policy configuration at the Product.

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