Skip to main content

certificate_profiles

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

Overview

Namecertificate_profiles
TypeResource
Idazure_extras.code_signing.certificate_profiles

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, profileNameGet details of a certificate profile.
list_by_code_signing_accountselectsubscriptionId, resourceGroupName, accountNameList certificate profiles under a trusted signing account.
createinsertsubscriptionId, resourceGroupName, accountName, profileNameCreate a certificate profile.
deletedeletesubscriptionId, resourceGroupName, accountName, profileNameDelete a certificate profile.
revoke_certificateexecsubscriptionId, resourceGroupName, accountName, profileName, serialNumber, thumbprint, effectiveAt, reasonRevoke a certificate under a certificate profile.

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
accountNamestringTrusted Signing account name.
profileNamestringCertificate profile name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get details of a certificate profile.

SELECT
properties
FROM azure_extras.code_signing.certificate_profiles
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND profileName = '{{ profileName }}' -- required
;

INSERT examples

Create a certificate profile.

INSERT INTO azure_extras.code_signing.certificate_profiles (
data__properties,
subscriptionId,
resourceGroupName,
accountName,
profileName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ profileName }}'
RETURNING
properties
;

DELETE examples

Delete a certificate profile.

DELETE FROM azure_extras.code_signing.certificate_profiles
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND profileName = '{{ profileName }}' --required
;

Lifecycle Methods

Revoke a certificate under a certificate profile.

EXEC azure_extras.code_signing.certificate_profiles.revoke_certificate 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@accountName='{{ accountName }}' --required,
@profileName='{{ profileName }}' --required
@@json=
'{
"serialNumber": "{{ serialNumber }}",
"thumbprint": "{{ thumbprint }}",
"effectiveAt": "{{ effectiveAt }}",
"reason": "{{ reason }}",
"remarks": "{{ remarks }}"
}'
;