Skip to main content

bot_connection

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

Overview

Namebot_connection
TypeResource
Idazure.bot_service.bot_connection

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringSpecifies the resource ID.
namestringSpecifies the name of the resource.
clientIdstringClient Id associated with the Connection Setting.
clientSecretstringClient Secret associated with the Connection Setting.
etagstringEntity Tag.
kindstringRequired. Gets or sets the Kind of the resource. Known values are: "sdk", "designer", "bot", "function", and "azurebot".
locationstringSpecifies the location of the resource.
parametersarrayService Provider Parameters associated with the Connection Setting.
provisioningStatestringProvisioning state of the resource.
scopesstringScopes associated with the Connection Setting.
serviceProviderDisplayNamestringService Provider Display Name associated with the Connection Setting.
serviceProviderIdstringService Provider Id associated with the Connection Setting.
settingIdstringSetting Id set by the service for the Connection Setting.
skuobjectGets or sets the SKU of the resource.
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
getselectresource_group_name, resource_name, connection_name, subscription_idGet a Connection Setting registration for a Bot Service.
list_by_bot_serviceselectresource_group_name, resource_name, subscription_idReturns all the Connection Settings registered to a particular BotService resource.
list_service_providersselectsubscription_idLists the available Service Providers for creating Connection Settings.
createinsertresource_group_name, resource_name, connection_name, subscription_idRegister a new Auth Connection for a Bot Service.
updateupdateresource_group_name, resource_name, connection_name, subscription_idUpdates a Connection Setting registration for a Bot Service.
deletedeleteresource_group_name, resource_name, connection_name, subscription_idDeletes a Connection Setting registration for a Bot Service.
list_with_secretsexecresource_group_name, resource_name, connection_name, subscription_idGet 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
connection_namestringThe name of the Bot Service Connection Setting resource. Required.
resource_group_namestringThe name of the Bot resource group in the user subscription. Required.
resource_namestringThe name of the Bot resource. Required.
subscription_idstring

SELECT examples

Get a Connection Setting registration for a Bot Service.

SELECT
id,
name,
clientId,
clientSecret,
etag,
kind,
location,
parameters,
provisioningState,
scopes,
serviceProviderDisplayName,
serviceProviderId,
settingId,
sku,
tags,
type,
zones
FROM azure.bot_service.bot_connection
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND connection_name = '{{ connection_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Register a new Auth Connection for a Bot Service.

INSERT INTO azure.bot_service.bot_connection (
location,
tags,
sku,
kind,
etag,
properties,
resource_group_name,
resource_name,
connection_name,
subscription_id
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ sku }}',
'{{ kind }}',
'{{ etag }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ resource_name }}',
'{{ connection_name }}',
'{{ subscription_id }}'
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_connection
SET
location = '{{ location }}',
tags = '{{ tags }}',
sku = '{{ sku }}',
kind = '{{ kind }}',
etag = '{{ etag }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND connection_name = '{{ connection_name }}' --required
AND subscription_id = '{{ subscription_id }}' --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_connection
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND connection_name = '{{ connection_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Get a Connection Setting registration for a Bot Service.

EXEC azure.bot_service.bot_connection.list_with_secrets 
@resource_group_name='{{ resource_group_name }}' --required,
@resource_name='{{ resource_name }}' --required,
@connection_name='{{ connection_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;