Skip to main content

workspace_group_users

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

Overview

Nameworkspace_group_users
TypeResource
Idazure.api_management.workspace_group_users

Fields

NameDatatypeDescription
propertiesobjectUser profile.

Methods

NameAccessible byRequired ParamsDescription
listSELECTgroupId, resourceGroupName, serviceName, subscriptionId, workspaceIdLists a collection of user entities associated with the group.
createINSERTgroupId, resourceGroupName, serviceName, subscriptionId, userId, workspaceIdAdd existing user to existing group
deleteDELETEgroupId, resourceGroupName, serviceName, subscriptionId, userId, workspaceIdRemove existing user from existing group.

SELECT examples

Lists a collection of user entities associated with the group.

SELECT
properties
FROM azure.api_management.workspace_group_users
WHERE groupId = '{{ groupId }}'
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_group_users resource.

/*+ create */
INSERT INTO azure.api_management.workspace_group_users (
groupId,
resourceGroupName,
serviceName,
subscriptionId,
userId,
workspaceId
)
SELECT
'{{ groupId }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ userId }}',
'{{ workspaceId }}'
;

DELETE example

Deletes the specified workspace_group_users resource.

/*+ delete */
DELETE FROM azure.api_management.workspace_group_users
WHERE groupId = '{{ groupId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND userId = '{{ userId }}'
AND workspaceId = '{{ workspaceId }}';