Skip to main content

certificate_orders_certificates

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

Overview

Namecertificate_orders_certificates
TypeResource
Idazure.app_service.certificate_orders_certificates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectCore resource properties
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, certificateOrderName, name, subscriptionIdDescription for Get the certificate associated with a certificate order.
listselectresourceGroupName, certificateOrderName, subscriptionIdDescription for List all certificates associated with a certificate order.
create_or_updateinsertresourceGroupName, certificateOrderName, name, subscriptionIdDescription for Creates or updates a certificate and associates with key vault secret.
updateupdateresourceGroupName, certificateOrderName, name, subscriptionIdDescription for Creates or updates a certificate and associates with key vault secret.
deletedeleteresourceGroupName, certificateOrderName, name, subscriptionIdDescription for Delete the certificate associated with a certificate order.

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.

NameDatatypeDescription
certificateOrderNamestringName of the certificate order.
namestringName of the certificate.
resourceGroupNamestringName of the resource group to which the resource belongs.
subscriptionIdstringYour Azure subscription ID. This is a GUID-formatted string (e.g. 00000000-0000-0000-0000-000000000000).

SELECT examples

Description for Get the certificate associated with a certificate order.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.app_service.certificate_orders_certificates
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND certificateOrderName = '{{ certificateOrderName }}' -- required
AND name = '{{ name }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Description for Creates or updates a certificate and associates with key vault secret.

INSERT INTO azure.app_service.certificate_orders_certificates (
data__properties,
resourceGroupName,
certificateOrderName,
name,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ certificateOrderName }}',
'{{ name }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
properties,
systemData,
type
;

UPDATE examples

Description for Creates or updates a certificate and associates with key vault secret.

UPDATE azure.app_service.certificate_orders_certificates
SET
data__kind = '{{ kind }}',
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND certificateOrderName = '{{ certificateOrderName }}' --required
AND name = '{{ name }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Description for Delete the certificate associated with a certificate order.

DELETE FROM azure.app_service.certificate_orders_certificates
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND certificateOrderName = '{{ certificateOrderName }}' --required
AND name = '{{ name }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;