Skip to main content

web_pub_sub_custom_certificates

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

Overview

Nameweb_pub_sub_custom_certificates
TypeResource
Idazure.web_pubsub.web_pub_sub_custom_certificates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}". # pylint: disable=line-too-long
namestringThe name of the resource.
keyVaultBaseUristringBase uri of the KeyVault that stores certificate. Required.
keyVaultSecretNamestringCertificate secret name. Required.
keyVaultSecretVersionstringCertificate secret version.
provisioningStatestringProvisioning state of the resource. Known values are: "Unknown", "Succeeded", "Failed", "Canceled", "Running", "Creating", "Updating", "Deleting", and "Moving".
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
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, resource_name, certificate_name, subscription_idGet a custom certificate.
listselectresource_group_name, resource_name, subscription_idList all custom certificates.
create_or_updateinsertresource_group_name, resource_name, certificate_name, subscription_id, propertiesCreate or update a custom certificate.
create_or_updatereplaceresource_group_name, resource_name, certificate_name, subscription_id, propertiesCreate or update a custom certificate.
deletedeleteresource_group_name, resource_name, certificate_name, subscription_idDelete a custom certificate.

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

SELECT examples

Get a custom certificate.

SELECT
id,
name,
keyVaultBaseUri,
keyVaultSecretName,
keyVaultSecretVersion,
provisioningState,
systemData,
type
FROM azure.web_pubsub.web_pub_sub_custom_certificates
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND certificate_name = '{{ certificate_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update a custom certificate.

INSERT INTO azure.web_pubsub.web_pub_sub_custom_certificates (
properties,
resource_group_name,
resource_name,
certificate_name,
subscription_id
)
SELECT
'{{ properties }}' /* required */,
'{{ resource_group_name }}',
'{{ resource_name }}',
'{{ certificate_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create or update a custom certificate.

REPLACE azure.web_pubsub.web_pub_sub_custom_certificates
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND certificate_name = '{{ certificate_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND properties = '{{ properties }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a custom certificate.

DELETE FROM azure.web_pubsub.web_pub_sub_custom_certificates
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND certificate_name = '{{ certificate_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;