workspace_api_operation_policies

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

Overview

Name	workspace_api_operation_policies
Type	Resource
Id	azure.api_management.workspace_api_operation_policies

Fields

vw_workspace_api_operation_policies

Name	Datatype	Description
apiId	text	field from the properties object
format	text	field from the properties object
operationId	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_operation_policies

Name	Datatype	Description
properties	object	Policy contract Properties.

Methods

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

SELECT examples

Get the list of policy configuration at the API Operation level.

vw_workspace_api_operation_policies

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

workspace_api_operation_policies

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

All Properties

/*+ create */
INSERT INTO azure.api_management.workspace_api_operation_policies (
apiId,
operationId,
policyId,
resourceGroupName,
serviceName,
subscriptionId,
workspaceId,
properties
)
SELECT 
'{{ apiId }}',
'{{ operationId }}',
'{{ 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_operation_policies resource.

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