certificate_orders_certificates

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

Overview

Name	certificate_orders_certificates
Type	Resource
Id	azure.app_service.certificate_orders_certificates

Fields

vw_certificate_orders_certificates

Name	Datatype	Description
id	text	Resource Id.
name	text	Resource Name.
certificateOrderName	text	field from the properties object
key_vault_id	text	field from the properties object
key_vault_secret_name	text	field from the properties object
kind	text	Kind of resource.
location	text	Resource Location.
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.

certificate_orders_certificates

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource Name.
kind	string	Kind of resource.
location	string	Resource Location.
properties	object	Key Vault container for a certificate that is purchased through Azure.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	certificateOrderName, name, resourceGroupName, subscriptionId	Description for Get the certificate associated with a certificate order.
list	SELECT	certificateOrderName, resourceGroupName, subscriptionId	Description for List all certificates associated with a certificate order.
create_or_update	INSERT	certificateOrderName, name, resourceGroupName, subscriptionId	Description for Creates or updates a certificate and associates with key vault secret.
delete	DELETE	certificateOrderName, name, resourceGroupName, subscriptionId	Description for Delete the certificate associated with a certificate order.
update	UPDATE	certificateOrderName, name, resourceGroupName, subscriptionId	Description for Creates or updates a certificate and associates with key vault secret.

SELECT examples

Description for List all certificates associated with a certificate order.

vw_certificate_orders_certificates

SELECT
id,
name,
certificateOrderName,
key_vault_id,
key_vault_secret_name,
kind,
location,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
type
FROM azure.app_service.vw_certificate_orders_certificates
WHERE certificateOrderName = '{{ certificateOrderName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificate_orders_certificates

SELECT
id,
name,
kind,
location,
properties,
tags,
type
FROM azure.app_service.certificate_orders_certificates
WHERE certificateOrderName = '{{ certificateOrderName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.certificate_orders_certificates (
certificateOrderName,
name,
resourceGroupName,
subscriptionId,
kind,
location,
tags,
properties
)
SELECT 
'{{ certificateOrderName }}',
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ kind }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: kind
      value: string
    - name: location
      value: string
    - name: type
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: keyVaultId
          value: string
        - name: keyVaultSecretName
          value: string
        - name: provisioningState
          value: string

UPDATE example

Updates a certificate_orders_certificates resource.

/*+ update */
UPDATE azure.app_service.certificate_orders_certificates
SET 
kind = '{{ kind }}',
properties = '{{ properties }}'
WHERE 
certificateOrderName = '{{ certificateOrderName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified certificate_orders_certificates resource.

/*+ delete */
DELETE FROM azure.app_service.certificate_orders_certificates
WHERE certificateOrderName = '{{ certificateOrderName }}'
AND name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';