Skip to main content

topics

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

Overview

Nametopics
TypeResource
Idazure.event_grid.topics

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
extendedLocationobjectExtended location of the resource.
identityobjectIdentity information for the resource.
kindstringKind of the resource. (default: Azure)
locationstringLocation of the resource.
propertiesobjectProperties of the topic.
skuobjectThe Sku pricing tier for the topic.
systemDataobjectThe system metadata relating to Topic resource.
tagsobjectTags of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, topicNameGet properties of a topic.
list_by_resource_groupselectsubscriptionId, resourceGroupName$filter, $topList all the topics under a resource group.
list_by_subscriptionselectsubscriptionId$filter, $topList all the topics under an Azure subscription.
create_or_updateinsertsubscriptionId, resourceGroupName, topicNameAsynchronously creates a new topic with the specified parameters.
updateupdatesubscriptionId, resourceGroupName, topicNameAsynchronously updates a topic with the specified parameters.
deletedeletesubscriptionId, resourceGroupName, topicNameDelete existing topic.
regenerate_keyexecsubscriptionId, resourceGroupName, topicName, keyNameRegenerate a shared access key for a 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
resourceGroupNamestringThe name of the resource group within the user's subscription.
subscriptionIdstringSubscription credentials that uniquely identify a Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.
topicNamestringName of the topic.
$filterstringThe query used to filter the search results using OData syntax. Filtering is permitted on the 'name' property only and with limited number of OData operations. These operations are: the 'contains' function as well as the following logical operations: not, and, or, eq (for equal), and ne (for not equal). No arithmetic operations are supported. The following is a valid filter example: $filter=contains(namE, 'PATTERN') and name ne 'PATTERN-1'. The following is not a valid filter example: $filter=location eq 'westus'.
$topinteger (int32)The number of results to return per page for the list operation. Valid range for top parameter is 1 to 100. If not specified, the default number of results to be returned is 20 items per page.

SELECT examples

Get properties of a topic.

SELECT
extendedLocation,
identity,
kind,
location,
properties,
sku,
systemData,
tags
FROM azure.event_grid.topics
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND topicName = '{{ topicName }}' -- required
;

INSERT examples

Asynchronously creates a new topic with the specified parameters.

INSERT INTO azure.event_grid.topics (
data__location,
data__tags,
data__properties,
data__sku,
data__identity,
data__kind,
data__extendedLocation,
subscriptionId,
resourceGroupName,
topicName
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ sku }}',
'{{ identity }}',
'{{ kind }}',
'{{ extendedLocation }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ topicName }}'
RETURNING
extendedLocation,
identity,
kind,
location,
properties,
sku,
systemData,
tags
;

UPDATE examples

Asynchronously updates a topic with the specified parameters.

UPDATE azure.event_grid.topics
SET
data__tags = '{{ tags }}',
data__identity = '{{ identity }}',
data__properties = '{{ properties }}',
data__sku = '{{ sku }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND topicName = '{{ topicName }}' --required;

DELETE examples

Delete existing topic.

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

Lifecycle Methods

Regenerate a shared access key for a topic.

EXEC azure.event_grid.topics.regenerate_key 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@topicName='{{ topicName }}' --required
@@json=
'{
"keyName": "{{ keyName }}"
}'
;