POST /v1/connections/{connectionId}/schemas/drop-columns
Marks for deletion multiple blocked column from your tables in schemas in the destination of an existing connection within your Fivetran account. The columns are dropped from the destination on the next sync.
Servers
- https://api.fivetran.com
Path parameters
| Name | Type | Required | Description |
|---|---|---|---|
connectionId |
String | Yes |
The unique identifier for the connection within the Fivetran system |
Request headers
| Name | Type | Required | Description |
|---|---|---|---|
Accept |
String | No |
Default value: "application/json" |
Content-Type |
String | Yes |
The media type of the request body.
Default value: "application/json" |
Request body fields
| Name | Type | Required | Description |
|---|---|---|---|
schemas |
Object | Yes |
The set of schemas within your connection schema config. |
schemas.schema |
Object | No | |
schemas.schema.tables |
Object | Yes |
The set of tables within your database schema config. |
schemas.schema.tables.table |
Object | No | |
schemas.schema.tables.table.columns[] |
Array | Yes |
The set of columns within your table schema config. The |
How to start integrating
- Add HTTP Task to your workflow definition.
- Search for the API you want to integrate with and click on the name.
- This loads the API reference documentation and prepares the Http request settings.
- Click Test request to test run your request to the API and see the API's response.