certificates

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

Overview

Name	certificates
Type	Resource
Id	google.integrations.certificates

Fields

The following fields are returned by SELECT queries:

projects_locations_products_certificates_get

Successful response

Name	Datatype	Description
name	string	Output only. Auto generated primary key
certificateStatus	string	Status of the certificate
credentialId	string	Immutable. Credential id that will be used to register with trawler
description	string	Description of the certificate
displayName	string	Required. Name of the certificate
rawCertificate	object	Input only. Raw client certificate which would be registered with trawler (id: GoogleCloudIntegrationsV1alphaClientCertificate)
requestorId	string	Immutable. Requestor ID to be used to register certificate with trawler
validEndTime	string (google-datetime)	Output only. The timestamp after which certificate will expire
validStartTime	string (google-datetime)	Output only. The timestamp after which certificate will be valid

projects_locations_products_certificates_list

Successful response

Name	Datatype	Description
name	string	Output only. Auto generated primary key
certificateStatus	string	Status of the certificate
credentialId	string	Immutable. Credential id that will be used to register with trawler
description	string	Description of the certificate
displayName	string	Required. Name of the certificate
rawCertificate	object	Input only. Raw client certificate which would be registered with trawler (id: GoogleCloudIntegrationsV1alphaClientCertificate)
requestorId	string	Immutable. Requestor ID to be used to register certificate with trawler
validEndTime	string (google-datetime)	Output only. The timestamp after which certificate will expire
validStartTime	string (google-datetime)	Output only. The timestamp after which certificate will be valid

projects_locations_certificates_get

Successful response

Name	Datatype	Description
name	string	Output only. Auto generated primary key
certificateStatus	string	Status of the certificate
credentialId	string	Immutable. Credential id that will be used to register with trawler
description	string	Description of the certificate
displayName	string	Required. Name of the certificate
rawCertificate	object	Input only. Raw client certificate which would be registered with trawler (id: GoogleCloudIntegrationsV1alphaClientCertificate)
requestorId	string	Immutable. Requestor ID to be used to register certificate with trawler
validEndTime	string (google-datetime)	Output only. The timestamp after which certificate will expire
validStartTime	string (google-datetime)	Output only. The timestamp after which certificate will be valid

projects_locations_certificates_list

Successful response

Name	Datatype	Description
name	string	Output only. Auto generated primary key
certificateStatus	string	Status of the certificate
credentialId	string	Immutable. Credential id that will be used to register with trawler
description	string	Description of the certificate
displayName	string	Required. Name of the certificate
rawCertificate	object	Input only. Raw client certificate which would be registered with trawler (id: GoogleCloudIntegrationsV1alphaClientCertificate)
requestorId	string	Immutable. Requestor ID to be used to register certificate with trawler
validEndTime	string (google-datetime)	Output only. The timestamp after which certificate will expire
validStartTime	string (google-datetime)	Output only. The timestamp after which certificate will be valid

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
projects_locations_products_certificates_get	select	projectsId, locationsId, productsId, certificatesId		Get a certificates in the specified project.
projects_locations_products_certificates_list	select	projectsId, locationsId, productsId	pageSize, pageToken, filter, readMask	List all the certificates that match the filter. Restrict to certificate of current client only.
projects_locations_certificates_get	select	projectsId, locationsId, certificatesId		Get a certificates in the specified project.
projects_locations_certificates_list	select	projectsId, locationsId	pageSize, pageToken, filter, readMask	List all the certificates that match the filter. Restrict to certificate of current client only.
projects_locations_products_certificates_create	insert	projectsId, locationsId, productsId		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_create	insert	projectsId, locationsId		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_patch	update	projectsId, locationsId, productsId, certificatesId	updateMask	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_certificates_patch	update	projectsId, locationsId, certificatesId	updateMask	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_delete	delete	projectsId, locationsId, productsId, certificatesId		Delete a certificate
projects_locations_certificates_delete	delete	projectsId, locationsId, certificatesId		Delete a certificate

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.

Name	Datatype	Description
certificatesId	string
locationsId	string
productsId	string
projectsId	string
filter	string
pageSize	integer (int32)
pageToken	string
readMask	string (google-fieldmask)
updateMask	string (google-fieldmask)

SELECT examples

projects_locations_products_certificates_get

Get a certificates in the specified project.

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

projects_locations_products_certificates_list

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

SELECT
name,
certificateStatus,
credentialId,
description,
displayName,
rawCertificate,
requestorId,
validEndTime,
validStartTime
FROM google.integrations.certificates
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND productsId = '{{ productsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
AND readMask = '{{ readMask }}';

projects_locations_certificates_get

Get a certificates in the specified project.

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

projects_locations_certificates_list

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

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

INSERT examples

projects_locations_products_certificates_create

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.

INSERT INTO google.integrations.certificates (
data__displayName,
data__description,
data__requestorId,
data__credentialId,
data__certificateStatus,
data__rawCertificate,
projectsId,
locationsId,
productsId
)
SELECT 
'{{ displayName }}',
'{{ description }}',
'{{ requestorId }}',
'{{ credentialId }}',
'{{ certificateStatus }}',
'{{ rawCertificate }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ productsId }}'
RETURNING
name,
certificateStatus,
credentialId,
description,
displayName,
rawCertificate,
requestorId,
validEndTime,
validStartTime
;

projects_locations_certificates_create

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.

INSERT INTO google.integrations.certificates (
data__displayName,
data__description,
data__requestorId,
data__credentialId,
data__certificateStatus,
data__rawCertificate,
projectsId,
locationsId
)
SELECT 
'{{ displayName }}',
'{{ description }}',
'{{ requestorId }}',
'{{ credentialId }}',
'{{ certificateStatus }}',
'{{ rawCertificate }}',
'{{ projectsId }}',
'{{ locationsId }}'
RETURNING
name,
certificateStatus,
credentialId,
description,
displayName,
rawCertificate,
requestorId,
validEndTime,
validStartTime
;

Manifest

# Description fields are for documentation purposes
- name: certificates
  props:
    - name: projectsId
      value: string
      description: Required parameter for the certificates resource.
    - name: locationsId
      value: string
      description: Required parameter for the certificates resource.
    - name: productsId
      value: string
      description: Required parameter for the certificates resource.
    - name: displayName
      value: string
      description: >
        Required. Name of the certificate
        
    - name: description
      value: string
      description: >
        Description of the certificate
        
    - name: requestorId
      value: string
      description: >
        Immutable. Requestor ID to be used to register certificate with trawler
        
    - name: credentialId
      value: string
      description: >
        Immutable. Credential id that will be used to register with trawler
        
    - name: certificateStatus
      value: string
      description: >
        Status of the certificate
        
      valid_values: ['STATE_UNSPECIFIED', 'ACTIVE', 'EXPIRED']
    - name: rawCertificate
      value: object
      description: >
        Input only. Raw client certificate which would be registered with trawler
        

UPDATE examples

projects_locations_products_certificates_patch

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.

UPDATE google.integrations.certificates
SET 
data__displayName = '{{ displayName }}',
data__description = '{{ description }}',
data__requestorId = '{{ requestorId }}',
data__credentialId = '{{ credentialId }}',
data__certificateStatus = '{{ certificateStatus }}',
data__rawCertificate = '{{ rawCertificate }}'
WHERE 
projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND productsId = '{{ productsId }}' --required
AND certificatesId = '{{ certificatesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
certificateStatus,
credentialId,
description,
displayName,
rawCertificate,
requestorId,
validEndTime,
validStartTime;

projects_locations_certificates_patch

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.

UPDATE google.integrations.certificates
SET 
data__displayName = '{{ displayName }}',
data__description = '{{ description }}',
data__requestorId = '{{ requestorId }}',
data__credentialId = '{{ credentialId }}',
data__certificateStatus = '{{ certificateStatus }}',
data__rawCertificate = '{{ rawCertificate }}'
WHERE 
projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND certificatesId = '{{ certificatesId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
certificateStatus,
credentialId,
description,
displayName,
rawCertificate,
requestorId,
validEndTime,
validStartTime;

DELETE examples

projects_locations_products_certificates_delete

Delete a certificate

DELETE FROM google.integrations.certificates
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND productsId = '{{ productsId }}' --required
AND certificatesId = '{{ certificatesId }}' --required;

projects_locations_certificates_delete

Delete a certificate

DELETE FROM google.integrations.certificates
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND certificatesId = '{{ certificatesId }}' --required;