Approve a certificate for the connector
Approves a certificate, so Fivetran trusts this certificate for a source database connection. The destination setup tests will fail if a non-approved certificate is provided.
NOTE: This is only required for destinations based on the following databases:
Request schema
Path parameters
connectorId
stringrequired
The unique identifier for the connector within the Fivetran system.
example:
Header parameters
Authorization
stringrequired
HTTP: basicAuth
HTTP AuthorizationScheme: basic
Accept
string
default:
example:
Request
hash
stringrequired
Hash of the certificate.
example:
encoded_cert
stringrequired
The certificate encoded in base64.
example:
Http + 1.1
POST
https://api.fivetran.com/v1/connectors/connector_id/certificates
POST /v1/connectors/connector_id/certificates HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Content-Type: application/json
Host: api.fivetran.com
Content-Length: 119
{
"hash": "jhg5UI7fgrI6yy...",
"encoded_cert": "MIID9DCCAtygAwIBAgIBQjANBgkqhkiG9w0BAQUFADCBijELMAkGA1UEBhMCV..."
}Responses
200
Successful response
400
Missing `hash` or `encoded_cert` fields in request payload
404
Connector not found
Successful response schema
code
stringrequired
Response status code
example:
message
string
Response status text
example:
data
objectrequired
name
stringrequired
The certificate name.
example:
hash
stringrequired
Hash of the certificate.
example:
type
stringrequired
Type of the certificate.
example:
sha1
stringrequired
SHA1 of certificate.
example:
sha256
stringrequired
SHA256 of certificate.
example:
validated_date
stringrequired
Date when certificate has been validated and approved.
format:
example:
validated_by
stringrequired
The unique identified for the user who has approved the certificate.
example:
public_key
stringrequired
The certificate decoded public key.
example:
{
"code": "Success",
"message": "Operation performed.",
"data": {
"name": "Certificate Name",
"hash": "jhg5UI7fgrI6yy...",
"type": "TLS",
"sha1": "c8de1d13vtu435ilj435lj345796d8jh7hk8hgk",
"sha256": "5vt6rt6jtr654eef94ec3f91122a623b389f4d331ff330026e43af21013vb45f",
"validated_date": "2023-08-20T10:15:20.677566Z",
"validated_by": "user_id",
"public_key": "Sun RSA public key, 2048 bits params: null modulus: 7685655455... public exponent: 65537"
}
}