Retrieve SSL Certificates in DigitalOcean.
View Specific Information
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.
|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.|