gateway_certificate_authorities

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

Overview

Name	gateway_certificate_authorities
Type	Resource
Id	azure.api_management.gateway_certificate_authorities

Fields

vw_gateway_certificate_authorities

Name	Datatype	Description
certificateId	text	field from the properties object
gatewayId	text	field from the properties object
is_trusted	text	field from the properties object
resourceGroupName	text	field from the properties object
serviceName	text	field from the properties object
subscriptionId	text	field from the properties object

gateway_certificate_authorities

Name	Datatype	Description
properties	object	Gateway certificate authority details.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	certificateId, gatewayId, resourceGroupName, serviceName, subscriptionId	Get assigned Gateway Certificate Authority details.
list_by_service	SELECT	gatewayId, resourceGroupName, serviceName, subscriptionId	Lists the collection of Certificate Authorities for the specified Gateway entity.
create_or_update	INSERT	certificateId, gatewayId, resourceGroupName, serviceName, subscriptionId	Assign Certificate entity to Gateway entity as Certificate Authority.
delete	DELETE	If-Match, certificateId, gatewayId, resourceGroupName, serviceName, subscriptionId	Remove relationship between Certificate Authority and Gateway entity.

SELECT examples

Lists the collection of Certificate Authorities for the specified Gateway entity.

vw_gateway_certificate_authorities

SELECT
certificateId,
gatewayId,
is_trusted,
resourceGroupName,
serviceName,
subscriptionId
FROM azure.api_management.vw_gateway_certificate_authorities
WHERE gatewayId = '{{ gatewayId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

gateway_certificate_authorities

SELECT
properties
FROM azure.api_management.gateway_certificate_authorities
WHERE gatewayId = '{{ gatewayId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new gateway_certificate_authorities resource.

All Properties

/*+ create */
INSERT INTO azure.api_management.gateway_certificate_authorities (
certificateId,
gatewayId,
resourceGroupName,
serviceName,
subscriptionId,
properties
)
SELECT 
'{{ certificateId }}',
'{{ gatewayId }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: isTrusted
          value: boolean

DELETE example

Deletes the specified gateway_certificate_authorities resource.

/*+ delete */
DELETE FROM azure.api_management.gateway_certificate_authorities
WHERE If-Match = '{{ If-Match }}'
AND certificateId = '{{ certificateId }}'
AND gatewayId = '{{ gatewayId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';