Skip to main content

bot_connections

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

Overview

Namebot_connections
TypeResource
Idazure.bot_service.bot_connections

Fields

The following fields are returned by SELECT queries:

The resource provider should return 200 (OK) to indicate that the operation completed successfully.

NameDatatypeDescription
idstringSpecifies the resource ID.
namestringSpecifies the name of the resource.
etagstringEntity Tag.
kindstringRequired. Gets or sets the Kind of the resource.
locationstringSpecifies the location of the resource.
propertiesobjectThe set of properties specific to bot channel resource
skuobjectThe SKU of the cognitive services account.
tagsobjectContains resource tags defined as key/value pairs.
typestringSpecifies the type of the resource.
zonesarrayEntity zones

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_with_secretsselectresourceGroupName, resourceName, connectionName, subscriptionIdGet a Connection Setting registration for a Bot Service
getselectresourceGroupName, resourceName, connectionName, subscriptionIdGet a Connection Setting registration for a Bot Service
list_by_bot_serviceselectresourceGroupName, resourceName, subscriptionIdReturns all the Connection Settings registered to a particular BotService resource
createinsertresourceGroupName, resourceName, connectionName, subscriptionIdRegister a new Auth Connection for a Bot Service
updateupdateresourceGroupName, resourceName, connectionName, subscriptionIdUpdates a Connection Setting registration for a Bot Service
deletedeleteresourceGroupName, resourceName, connectionName, subscriptionIdDeletes a Connection Setting registration for a Bot Service

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
connectionNamestringThe name of the Bot Service Connection Setting resource.
resourceGroupNamestringThe name of the Bot resource group in the user subscription.
resourceNamestringThe name of the Bot resource.
subscriptionIdstringAzure Subscription ID.

SELECT examples

Get a Connection Setting registration for a Bot Service

SELECT
id,
name,
etag,
kind,
location,
properties,
sku,
tags,
type,
zones
FROM azure.bot_service.bot_connections
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND resourceName = '{{ resourceName }}' -- required
AND connectionName = '{{ connectionName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Register a new Auth Connection for a Bot Service

INSERT INTO azure.bot_service.bot_connections (
data__location,
data__tags,
data__sku,
data__kind,
data__etag,
data__properties,
resourceGroupName,
resourceName,
connectionName,
subscriptionId
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ sku }}',
'{{ kind }}',
'{{ etag }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ connectionName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
etag,
kind,
location,
properties,
sku,
tags,
type,
zones
;

UPDATE examples

Updates a Connection Setting registration for a Bot Service

UPDATE azure.bot_service.bot_connections
SET
data__location = '{{ location }}',
data__tags = '{{ tags }}',
data__sku = '{{ sku }}',
data__kind = '{{ kind }}',
data__etag = '{{ etag }}',
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND resourceName = '{{ resourceName }}' --required
AND connectionName = '{{ connectionName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
etag,
kind,
location,
properties,
sku,
tags,
type,
zones;

DELETE examples

Deletes a Connection Setting registration for a Bot Service

DELETE FROM azure.bot_service.bot_connections
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND resourceName = '{{ resourceName }}' --required
AND connectionName = '{{ connectionName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;