Skip to main content

rules

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

Overview

Namerules
TypeResource
Idazure.service_bus.rules

Fields

The following fields are returned by SELECT queries:

Successfully retrieved rule description.

NameDatatypeDescription
propertiesobjectProperties of Rule resource
systemDataobjectThe system meta data relating to this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, namespaceName, topicName, subscriptionName, ruleName, subscriptionIdRetrieves the description for the specified rule.
list_by_subscriptionsselectresourceGroupName, namespaceName, topicName, subscriptionName, subscriptionId$skip, $topList all the rules within given topic-subscription
create_or_updateinsertresourceGroupName, namespaceName, topicName, subscriptionName, ruleName, subscriptionIdCreates a new rule and updates an existing rule
deletedeleteresourceGroupName, namespaceName, topicName, subscriptionName, ruleName, subscriptionIdDeletes an existing rule.

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
namespaceNamestringThe namespace name
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
ruleNamestringThe rule name.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
subscriptionNamestringThe subscription name.
topicNamestringThe topic name.
$skipintegerSkip is only used if a previous operation returned a partial result. If a previous response contains a nextLink element, the value of the nextLink element will include a skip parameter that specifies a starting point to use for subsequent calls.
$topintegerMay be used to limit the number of results to the most recent N usageDetails.

SELECT examples

Retrieves the description for the specified rule.

SELECT
properties,
systemData
FROM azure.service_bus.rules
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND namespaceName = '{{ namespaceName }}' -- required
AND topicName = '{{ topicName }}' -- required
AND subscriptionName = '{{ subscriptionName }}' -- required
AND ruleName = '{{ ruleName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Creates a new rule and updates an existing rule

INSERT INTO azure.service_bus.rules (
data__properties,
resourceGroupName,
namespaceName,
topicName,
subscriptionName,
ruleName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ namespaceName }}',
'{{ topicName }}',
'{{ subscriptionName }}',
'{{ ruleName }}',
'{{ subscriptionId }}'
RETURNING
properties,
systemData
;

DELETE examples

Deletes an existing rule.

DELETE FROM azure.service_bus.rules
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND namespaceName = '{{ namespaceName }}' --required
AND topicName = '{{ topicName }}' --required
AND subscriptionName = '{{ subscriptionName }}' --required
AND ruleName = '{{ ruleName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;