workspace_api_policies

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

Overview

Name	workspace_api_policies
Type	Resource
Id	azure.api_management.workspace_api_policies

Fields

vw_workspace_api_policies

Name	Datatype	Description
apiId	text	field from the properties object
format	text	field from the properties object
policyId	text	field from the properties object
resourceGroupName	text	field from the properties object
serviceName	text	field from the properties object
subscriptionId	text	field from the properties object
value	text	field from the properties object
workspaceId	text	field from the properties object

workspace_api_policies

Name	Datatype	Description
properties	object	Policy contract Properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	apiId, policyId, resourceGroupName, serviceName, subscriptionId, workspaceId	Get the policy configuration at the API level.
list_by_api	SELECT	apiId, resourceGroupName, serviceName, subscriptionId, workspaceId	Get the policy configuration at the API level.
create_or_update	INSERT	apiId, policyId, resourceGroupName, serviceName, subscriptionId, workspaceId	Creates or updates policy configuration for the API.
delete	DELETE	If-Match, apiId, policyId, resourceGroupName, serviceName, subscriptionId, workspaceId	Deletes the policy configuration at the Api.

SELECT examples

Get the policy configuration at the API level.

vw_workspace_api_policies

SELECT
apiId,
format,
policyId,
resourceGroupName,
serviceName,
subscriptionId,
value,
workspaceId
FROM azure.api_management.vw_workspace_api_policies
WHERE apiId = '{{ apiId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceId = '{{ workspaceId }}';

workspace_api_policies

SELECT
properties
FROM azure.api_management.workspace_api_policies
WHERE apiId = '{{ apiId }}'
AND 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_api_policies resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: value
          value: string
        - name: format
          value: string

DELETE example

Deletes the specified workspace_api_policies resource.

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