certificates

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

Overview

Name	certificates
Type	Resource
Id	google.integrations.certificates

Fields

Name	Datatype	Description
name	string	Output only. Auto generated primary key
description	string	Description of the certificate
certificateStatus	string	Status of the certificate
credentialId	string	Immutable. Credential id that will be used to register with trawler
displayName	string	Required. Name of the certificate
rawCertificate	object	Contains client certificate information
requestorId	string	Immutable. Requestor ID to be used to register certificate with trawler
validEndTime	string	Output only. The timestamp after which certificate will expire
validStartTime	string	Output only. The timestamp after which certificate will be valid

Methods

Name	Accessible by	Required Params	Description
projects_locations_certificates_get	SELECT	certificatesId, locationsId, projectsId	Get a certificates in the specified project.
projects_locations_certificates_list	SELECT	locationsId, projectsId	List all the certificates that match the filter. Restrict to certificate of current client only.
projects_locations_products_certificates_get	SELECT	certificatesId, locationsId, productsId, projectsId	Get a certificates in the specified project.
projects_locations_products_certificates_list	SELECT	locationsId, productsId, projectsId	List all the certificates that match the filter. Restrict to certificate of current client only.
projects_locations_certificates_create	INSERT	locationsId, projectsId	Creates a new certificate. The certificate will be registered to the trawler service and will be encrypted using cloud KMS and stored in Spanner Returns the certificate.
projects_locations_products_certificates_create	INSERT	locationsId, productsId, projectsId	Creates a new certificate. The certificate will be registered to the trawler service and will be encrypted using cloud KMS and stored in Spanner Returns the certificate.
projects_locations_certificates_delete	DELETE	certificatesId, locationsId, projectsId	Delete a certificate
projects_locations_products_certificates_delete	DELETE	certificatesId, locationsId, productsId, projectsId	Delete a certificate
projects_locations_certificates_patch	UPDATE	certificatesId, locationsId, projectsId	Updates the certificate by id. If new certificate file is updated, it will register with the trawler service, re-encrypt with cloud KMS and update the Spanner record. Other fields will directly update the Spanner record. Returns the Certificate.
projects_locations_products_certificates_patch	UPDATE	certificatesId, locationsId, productsId, projectsId	Updates the certificate by id. If new certificate file is updated, it will register with the trawler service, re-encrypt with cloud KMS and update the Spanner record. Other fields will directly update the Spanner record. Returns the Certificate.

SELECT examples

List all the certificates that match the filter. Restrict to certificate of current client only.

SELECT
name,
description,
certificateStatus,
credentialId,
displayName,
rawCertificate,
requestorId,
validEndTime,
validStartTime
FROM google.integrations.certificates
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.integrations.certificates (
locationsId,
projectsId,
credentialId,
rawCertificate,
description,
requestorId,
displayName,
certificateStatus
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ credentialId }}',
'{{ rawCertificate }}',
'{{ description }}',
'{{ requestorId }}',
'{{ displayName }}',
'{{ certificateStatus }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: credentialId
      value: string
    - name: rawCertificate
      value:
        - name: passphrase
          value: string
        - name: encryptedPrivateKey
          value: string
        - name: sslCertificate
          value: string
    - name: validEndTime
      value: string
    - name: validStartTime
      value: string
    - name: description
      value: string
    - name: requestorId
      value: string
    - name: displayName
      value: string
    - name: name
      value: string
    - name: certificateStatus
      value: string

UPDATE example

Updates a certificates resource.

/*+ update */
UPDATE google.integrations.certificates
SET 
credentialId = '{{ credentialId }}',
rawCertificate = '{{ rawCertificate }}',
description = '{{ description }}',
requestorId = '{{ requestorId }}',
displayName = '{{ displayName }}',
certificateStatus = '{{ certificateStatus }}'
WHERE 
certificatesId = '{{ certificatesId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified certificates resource.

/*+ delete */
DELETE FROM google.integrations.certificates
WHERE certificatesId = '{{ certificatesId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';