SSIS Components for DigitalOcean

Build 20.0.7587

Certificates

Retrieve SSL Certificates in DigitalOcean.

View Specific Information

Select

Digital Ocean supports only Id column with "=" operator as filter criteria for this view.

SELECT * FROM Certificates WHERE Id='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type References Description
Id [KEY] String A unique ID that can be used to identify and reference a certificate.
Name String A unique human-readable name referring to a certificate.
NotAfter Datetime The date and time value that represents the certificate's expiration date.
Sha1Fingerprint String A unique identifier generated from the SHA-1 fingerprint of the certificate.
CreatedAt Datetime The date and time value that represents when the certificate was created.
DnsNames String An array of fully qualified domain names (FQDNs) for which the certificate was issued.
PrivateKey String The contents of a PEM-formatted private-key corresponding to the SSL certificate. This column is required for the creation of a new certificate.
LeafCertificate String The contents of a PEM-formatted public SSL certificate. This column is also required for the creation of a new certificate.
CertificateChain String The full PEM-formatted trust chain between the certificate authority's certificate and your domain's SSL certificate. Optional for the creation of a new certificate.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587