Skip to main content

bots

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

Overview

Namebots
TypeResource
Idazure_extras.health_bot.bots

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
accessControlMethodstringThe access control method for the Azure Health Bot resource.
botManagementPortalLinkstringThe link.
identityobjectThe identity of the Azure Health Bot.
keyVaultPropertiesobjectKeyVault properties for the resource encryption.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringThe provisioning state of the Azure Health Bot resource.
skuobjectSKU of the Azure Health Bot. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, bot_name, subscription_idGet a HealthBot.
list_by_resource_groupselectresource_group_name, subscription_idReturns all the resources of a particular type belonging to a resource group.
listselectsubscription_idReturns all the resources of a particular type belonging to a subscription.
createinsertresource_group_name, bot_name, subscription_id, location, skuCreate a new Azure Health Bot.
updateupdateresource_group_name, bot_name, subscription_idPatch a HealthBot.
deletedeleteresource_group_name, bot_name, subscription_idDelete a HealthBot.
list_secretsexecresource_group_name, bot_name, subscription_idList all secrets of a HealthBot.
regenerate_api_jwt_secretexecresource_group_name, bot_name, subscription_idRegenerate the API JWT Secret of a HealthBot.

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
bot_namestringThe name of the Bot resource. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get a HealthBot.

SELECT
id,
name,
accessControlMethod,
botManagementPortalLink,
identity,
keyVaultProperties,
location,
provisioningState,
sku,
systemData,
tags,
type
FROM azure_extras.health_bot.bots
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND bot_name = '{{ bot_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a new Azure Health Bot.

INSERT INTO azure_extras.health_bot.bots (
tags,
location,
properties,
sku,
identity,
resource_group_name,
bot_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ sku }}' /* required */,
'{{ identity }}',
'{{ resource_group_name }}',
'{{ bot_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
location,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

Patch a HealthBot.

UPDATE azure_extras.health_bot.bots
SET
properties = '{{ properties }}',
tags = '{{ tags }}',
sku = '{{ sku }}',
identity = '{{ identity }}',
location = '{{ location }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND bot_name = '{{ bot_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
location,
properties,
sku,
systemData,
tags,
type;

DELETE examples

Delete a HealthBot.

DELETE FROM azure_extras.health_bot.bots
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND bot_name = '{{ bot_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

List all secrets of a HealthBot.

EXEC azure_extras.health_bot.bots.list_secrets 
@resource_group_name='{{ resource_group_name }}' --required,
@bot_name='{{ bot_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;