Drop a Blocked Column From the Destination

Marks a blocked column for deletion from your destination table. The column will be dropped during the next sync.

For the NetSuite SuiteAnalytics and Salesforce and Salesforce Sandbox connectors, the 'schemas' map field will always have a single entry with the 'netsuite' or 'salesforce' key, respectively.

Request schema

Path parameters

connectionId

stringrequired

The unique identifier for the connection within the Fivetran system.

example:

connectionId

schemaName

stringrequired

The schema name as stored in the connection schema config. This value is case-sensitive; an incorrect case will result in a 404.

example:

schemaName

tableName

stringrequired

The table name as stored in the connection schema config. This value is case-sensitive; an incorrect case will result in a 404.

example:

tableName

columnName

stringrequired

The column name as stored in the connection schema config. This value is case-sensitive; an incorrect case will result in a 404.

example:

columnName

Header parameters

Authorization

stringrequired

HTTP: basicAuth

HTTP AuthorizationScheme: basic

string

default:

application/json

example:

application/json

Http + 1.1

DELETE

https://api.fivetran.com/v1/connections/connectionId/schemas/schemaName/tables/tableName/columns/columnName

DELETE /v1/connections/connectionId/schemas/schemaName/tables/tableName/columns/columnName HTTP/1.1
Accept: application/json
Authorization: Basic 
Host: api.fivetran.com

Responses

200

Successful response

400

Bad request

404

Not found error

409

Column not in blocked state error

`200`

code

stringrequired

Response status code

example:

Success

message

stringrequired

Response status text

example:

Column successfully marked for deletion

{
  "code": "Success",
  "message": "Column successfully marked for deletion"
}