Skip to main content

public_certificates

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

Overview

Namepublic_certificates
TypeResource
Idazure.app_service.public_certificates

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource Id.
namestringResource Name.
kindstringKind of resource.
propertiesobjectPublicCertificate resource specific properties
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, name, publicCertificateName, subscriptionIdDescription for Get the named public certificate for an app (or deployment slot, if specified).
listselectresourceGroupName, name, subscriptionIdDescription for Get public certificates for an app or a deployment slot.
create_or_updateinsertresourceGroupName, name, publicCertificateName, subscriptionIdDescription for Creates a hostname binding for an app.
deletedeleteresourceGroupName, name, publicCertificateName, subscriptionIdDescription for Deletes a hostname binding for an app.

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
namestringName of the app.
publicCertificateNamestringPublic certificate name.
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 named public certificate for an app (or deployment slot, if specified).

SELECT
id,
name,
kind,
properties,
type
FROM azure.app_service.public_certificates
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND name = '{{ name }}' -- required
AND publicCertificateName = '{{ publicCertificateName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Description for Creates a hostname binding for an app.

INSERT INTO azure.app_service.public_certificates (
data__kind,
data__properties,
resourceGroupName,
name,
publicCertificateName,
subscriptionId
)
SELECT
'{{ kind }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ name }}',
'{{ publicCertificateName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
kind,
properties,
type
;

DELETE examples

Description for Deletes a hostname binding for an app.

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