Skip to main content

certificate_operations

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

Overview

Namecertificate_operations
TypeResource
Idazure.key_vault_certificates.certificate_operations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe certificate id.
request_idstringIdentifier for the certificate operation.
cancellation_requestedbooleanIndicates if cancellation was requested on the certificate operation.
csrstring (byte)The certificate signing request (CSR) that is being used in the certificate operation.
errorobjectError encountered, if any, during the certificate operation.
issuerobjectParameters for the issuer of the X509 component of a certificate.
preserveCertOrderbooleanSpecifies whether the certificate chain preserves its original order. The default value is false, which sets the leaf certificate at index 0.
statusstringStatus of the certificate operation.
status_detailsstringThe status details of the certificate operation.
targetstringLocation which contains the result of the certificate operation.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_certificate_operationselectcertificate_name, vault_nameGets the creation operation of a certificate. Gets the creation operation associated with a specified certificate. This operation requires the certificates/get permission.
update_certificate_operationupdatecertificate_name, vault_name, cancellation_requestedUpdates a certificate operation. Updates a certificate creation operation that is already in progress. This operation requires the certificates/update permission.
delete_certificate_operationdeletecertificate_name, vault_nameDeletes the creation operation for a specific certificate. Deletes the creation operation for a specified certificate that is in the process of being created. The certificate is no longer created. This operation requires the certificates/update permission.

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
certificate_namestringThe name of the certificate. Required.
vault_namestringKey vault name. (default: )

SELECT examples

Gets the creation operation of a certificate. Gets the creation operation associated with a specified certificate. This operation requires the certificates/get permission.

SELECT
id,
request_id,
cancellation_requested,
csr,
error,
issuer,
preserveCertOrder,
status,
status_details,
target
FROM azure.key_vault_certificates.certificate_operations
WHERE certificate_name = '{{ certificate_name }}' -- required
AND vault_name = '{{ vault_name }}' -- required
;

UPDATE examples

Updates a certificate operation. Updates a certificate creation operation that is already in progress. This operation requires the certificates/update permission.

UPDATE azure.key_vault_certificates.certificate_operations
SET
cancellation_requested = {{ cancellation_requested }}
WHERE
certificate_name = '{{ certificate_name }}' --required
AND vault_name = '{{ vault_name }}' --required
AND cancellation_requested = {{ cancellation_requested }} --required
RETURNING
id,
request_id,
cancellation_requested,
csr,
error,
issuer,
preserveCertOrder,
status,
status_details,
target;

DELETE examples

Deletes the creation operation for a specific certificate. Deletes the creation operation for a specified certificate that is in the process of being created. The certificate is no longer created. This operation requires the certificates/update permission.

DELETE FROM azure.key_vault_certificates.certificate_operations
WHERE certificate_name = '{{ certificate_name }}' --required
AND vault_name = '{{ vault_name }}' --required
;