Skip to main content

product_groups

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

Overview

Nameproduct_groups
TypeResource
Idazure.api_management.product_groups

Fields

The following fields are returned by SELECT queries:

Lists a collection of Group entities.

NameDatatypeDescription
propertiesobjectGroup entity contract properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_by_productselectresourceGroupName, serviceName, productId, subscriptionId$filter, $top, $skipLists the collection of developer groups associated with the specified product.
create_or_updateinsertresourceGroupName, serviceName, productId, groupId, subscriptionIdAdds the association between the specified developer group with the specified product.
deletedeleteresourceGroupName, serviceName, productId, groupId, subscriptionIdDeletes the association between the specified group and 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
groupIdstringGroup identifier. Must be unique in the current API Management service instance.
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.
$filterstring| Field | Usage | Supported operators | Supported functions |</br>|-------------|-------------|-------------|-------------|</br>| name | filter | ge, le, eq, ne, gt, lt | |</br>| displayName | filter | eq, ne | |</br>| description | filter | eq, ne | |</br>
$skipinteger (int32)Number of records to skip.
$topinteger (int32)Number of records to return.

SELECT examples

Lists the collection of developer groups associated with the specified product.

SELECT
properties
FROM azure.api_management.product_groups
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serviceName = '{{ serviceName }}' -- required
AND productId = '{{ productId }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND $filter = '{{ $filter }}'
AND $top = '{{ $top }}'
AND $skip = '{{ $skip }}'
;

INSERT examples

Adds the association between the specified developer group with the specified product.

INSERT INTO azure.api_management.product_groups (
resourceGroupName,
serviceName,
productId,
groupId,
subscriptionId
)
SELECT
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ productId }}',
'{{ groupId }}',
'{{ subscriptionId }}'
RETURNING
properties
;

DELETE examples

Deletes the association between the specified group and product.

DELETE FROM azure.api_management.product_groups
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND serviceName = '{{ serviceName }}' --required
AND productId = '{{ productId }}' --required
AND groupId = '{{ groupId }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;