custom_certificates

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

Overview

Name	custom_certificates
Type	Resource
Id	azure.web_pubsub.custom_certificates

Fields

vw_custom_certificates

Name	Datatype	Description
certificateName	text	field from the properties object
key_vault_base_uri	text	field from the properties object
key_vault_secret_name	text	field from the properties object
key_vault_secret_version	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
subscriptionId	text	field from the properties object

custom_certificates

Name	Datatype	Description
properties	object	Custom certificate properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	certificateName, resourceGroupName, resourceName, subscriptionId	Get a custom certificate.
list	SELECT	resourceGroupName, resourceName, subscriptionId	List all custom certificates.
create_or_update	INSERT	certificateName, resourceGroupName, resourceName, subscriptionId, data__properties	Create or update a custom certificate.
delete	DELETE	certificateName, resourceGroupName, resourceName, subscriptionId	Delete a custom certificate.

SELECT examples

List all custom certificates.

vw_custom_certificates

SELECT
certificateName,
key_vault_base_uri,
key_vault_secret_name,
key_vault_secret_version,
provisioning_state,
resourceGroupName,
resourceName,
subscriptionId
FROM azure.web_pubsub.vw_custom_certificates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

custom_certificates

SELECT
properties
FROM azure.web_pubsub.custom_certificates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new custom_certificates resource.

All Properties

/*+ create */
INSERT INTO azure.web_pubsub.custom_certificates (
certificateName,
resourceGroupName,
resourceName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ certificateName }}',
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: keyVaultBaseUri
          value: string
        - name: keyVaultSecretName
          value: string
        - name: keyVaultSecretVersion
          value: string

DELETE example

Deletes the specified custom_certificates resource.

/*+ delete */
DELETE FROM azure.web_pubsub.custom_certificates
WHERE certificateName = '{{ certificateName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';