Drop a blocked columns from the destination
Marks for deletion multiple blocked column from your tables in schemas in the destination of an existing connector within your Fivetran account. The columns are dropped from the destination on the next sync.
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
schemas
objectrequired
The set of schemas within your connector schema config that are synced into the destination
property name *
object
additional property
tables
objectrequired
The set of tables within your database schema config that are synced into the destination
property name *
object
additional property
columns
arrayrequired
The set of columns within your table schema config that are synced into the destination
type:
Http + 1.1
POST
https://api.fivetran.com/v1/connectors/connector_id/schemas/drop-columns
POST /v1/connectors/connector_id/schemas/drop-columns HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Content-Type: application/json
Host: api.fivetran.com
Content-Length: 483
{
"schemas": {
"property1": {
"tables": {
"property1": {
"columns": [
"string"
]
},
"property2": {
"columns": [
"string"
]
}
}
},
"property2": {
"tables": {
"property1": {
"columns": [
"string"
]
},
"property2": {
"columns": [
"string"
]
}
}
}
}
}Responses
200
Successful response
400
Bad request
404
Not found error
409
Column not in blocked state error
Successful response schema
code
stringrequired
Response status code
example:
message
stringrequired
Response status text
example:
{
"code": "Success",
"message": "Operation performed."
}