Skip to main content

topics

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

Overview

Nametopics
TypeResource
Idazure.service_bus.topics

Fields

The following fields are returned by SELECT queries:

Topic description successfully retrieved.

NameDatatypeDescription
propertiesobjectProperties of topic 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, subscriptionIdReturns a description for the specified topic.
list_by_namespaceselectresourceGroupName, namespaceName, subscriptionId$skip, $topGets all the topics in a namespace.
create_or_updateinsertresourceGroupName, namespaceName, topicName, subscriptionIdCreates a topic in the specified namespace.
deletedeleteresourceGroupName, namespaceName, topicName, subscriptionIdDeletes a topic from the specified namespace and resource group.
regenerate_keysexecresourceGroupName, namespaceName, topicName, authorizationRuleName, subscriptionId, keyTypeRegenerates primary or secondary connection strings for the topic.

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
authorizationRuleNamestringThe authorization rule name.
namespaceNamestringThe namespace name
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
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

Returns a description for the specified topic.

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

INSERT examples

Creates a topic in the specified namespace.

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

DELETE examples

Deletes a topic from the specified namespace and resource group.

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

Lifecycle Methods

Regenerates primary or secondary connection strings for the topic.

EXEC azure.service_bus.topics.regenerate_keys 
@resourceGroupName='{{ resourceGroupName }}' --required,
@namespaceName='{{ namespaceName }}' --required,
@topicName='{{ topicName }}' --required,
@authorizationRuleName='{{ authorizationRuleName }}' --required,
@subscriptionId='{{ subscriptionId }}' --required
@@json=
'{
"keyType": "{{ keyType }}",
"key": "{{ key }}"
}'
;