certificates

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

Overview

Name	certificates
Type	Resource
Id	azure.spring_apps.certificates

Fields

The following fields are returned by SELECT queries:

get

Success. The response describe the certificate.

Name	Datatype	Description
properties	object	Properties of the certificate resource payload.

list

Success. The response describe the list of certificates in the Service.

Name	Datatype	Description
properties	object	Properties of the certificate resource payload.

Methods

The following methods are available for this resource:

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

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.

Name	Datatype	Description
certificateName	string	The name of the certificate resource.
resourceGroupName	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serviceName	string	The name of the Service resource.
subscriptionId	string	Gets subscription ID which uniquely identify the Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

get

Get the certificate resource.

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

list

List all the certificates of one user.

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

INSERT examples

create_or_update

Create or update certificate resource.

INSERT INTO azure.spring_apps.certificates (
data__properties,
subscriptionId,
resourceGroupName,
serviceName,
certificateName
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ certificateName }}'
RETURNING
properties
;

Manifest

# Description fields are for documentation purposes
- name: certificates
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the certificates resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the certificates resource.
    - name: serviceName
      value: string
      description: Required parameter for the certificates resource.
    - name: certificateName
      value: string
      description: Required parameter for the certificates resource.
    - name: properties
      value: object
      description: |
        Properties of the certificate resource payload.

DELETE examples

delete

Delete the certificate resource.

DELETE FROM azure.spring_apps.certificates
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND serviceName = '{{ serviceName }}' --required
AND certificateName = '{{ certificateName }}' --required
;