certificates

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

Overview

Name	certificates
Type	Resource
Id	azure.spring_apps.certificates

Fields

vw_certificates

Name	Datatype	Description
activate_date	text	field from the properties object
certificateName	text	field from the properties object
dns_names	text	field from the properties object
expiration_date	text	field from the properties object
issued_date	text	field from the properties object
issuer	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serviceName	text	field from the properties object
subject_name	text	field from the properties object
subscriptionId	text	field from the properties object
thumbprint	text	field from the properties object
type	text	field from the properties object

certificates

Name	Datatype	Description
properties	object	Certificate resource payload.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	certificateName, resourceGroupName, serviceName, subscriptionId	Get the certificate resource.
list	SELECT	resourceGroupName, serviceName, subscriptionId	List all the certificates of one user.
create_or_update	INSERT	certificateName, resourceGroupName, serviceName, subscriptionId	Create or update certificate resource.
delete	DELETE	certificateName, resourceGroupName, serviceName, subscriptionId	Delete the certificate resource.

SELECT examples

List all the certificates of one user.

vw_certificates

SELECT
activate_date,
certificateName,
dns_names,
expiration_date,
issued_date,
issuer,
provisioning_state,
resourceGroupName,
serviceName,
subject_name,
subscriptionId,
thumbprint,
type
FROM azure.spring_apps.vw_certificates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

certificates

SELECT
properties
FROM azure.spring_apps.certificates
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.spring_apps.certificates (
certificateName,
resourceGroupName,
serviceName,
subscriptionId,
properties
)
SELECT 
'{{ certificateName }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: type
          value: string
        - name: thumbprint
          value: string
        - name: issuer
          value: string
        - name: issuedDate
          value: string
        - name: expirationDate
          value: string
        - name: activateDate
          value: string
        - name: subjectName
          value: string
        - name: dnsNames
          value:
            - string
        - name: provisioningState
          value: string

DELETE example

Deletes the specified certificates resource.

/*+ delete */
DELETE FROM azure.spring_apps.certificates
WHERE certificateName = '{{ certificateName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';