certificates

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

Overview

Name	certificates
Type	Resource
Id	azure.app_service.certificates

Fields

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource Name.
kind	string	Kind of resource.
location	string	Resource Location.
properties	object	Certificate resource specific properties
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId	Description for Get a certificate.
list	SELECT	subscriptionId	Description for Get all certificates for a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Description for Get all certificates in a resource group.
create_or_update	INSERT	name, resourceGroupName, subscriptionId	Description for Create or update a certificate.
delete	DELETE	name, resourceGroupName, subscriptionId	Description for Delete a certificate.
update	UPDATE	name, resourceGroupName, subscriptionId	Description for Create or update a certificate.

SELECT examples

Description for Get all certificates for a subscription.

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.certificates (
name,
resourceGroupName,
subscriptionId,
kind,
location,
tags,
properties
)
SELECT 
'{{ 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: password
          value: string
        - name: friendlyName
          value: string
        - name: subjectName
          value: string
        - name: hostNames
          value:
            - string
        - name: pfxBlob
          value: string
        - name: siteName
          value: string
        - name: selfLink
          value: string
        - name: issuer
          value: string
        - name: issueDate
          value: string
        - name: expirationDate
          value: string
        - name: thumbprint
          value: string
        - name: valid
          value: boolean
        - name: cerBlob
          value: string
        - name: publicKeyHash
          value: string
        - name: hostingEnvironmentProfile
          value:
            - name: id
              value: string
            - name: name
              value: string
            - name: type
              value: string
        - name: keyVaultId
          value: string
        - name: keyVaultSecretName
          value: string
        - name: keyVaultSecretStatus
          value: string
        - name: serverFarmId
          value: string
        - name: canonicalName
          value: string
        - name: domainValidationMethod
          value: string

UPDATE example

Updates a certificates resource.

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

DELETE example

Deletes the specified certificates resource.

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