POST /v1/connections/{connectionId}/schemas

Allows to set up a Connection Schema Config for a new connection.

NOTE: The response contains the exact settings that were passed in request.

After the initial sync, when the connection captures the schema from the source, we try to apply the specified settings on the actual schema from the source.

In case some table or column are not allowed to be excluded, we ignore the settings for the relevant entity.

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.enabled`	Boolean	Yes	The boolean value specifying whether the sync for the table into the destination is enabled.
`schemas.schema.tables`	Object	No	The set of tables within your database schema config.
`schemas.schema.tables.table`	Object	No
`schemas.schema.tables.table.enabled`	Boolean	Yes	The boolean value specifying whether the sync for the table into the destination is enabled.
`schemas.schema.tables.table.columns`	Object	No	The set of columns within your table schema config. The `columns` object in the response contains the columns whose `enabled` value has been set by the user after the initial sync.
`schemas.schema.tables.table.columns.column`	Object	No
`schemas.schema.tables.table.columns.column.hashed`	Boolean	No	The boolean value specifying whether a column should be hashed
`schemas.schema.tables.table.columns.column.enabled`	Boolean	Yes	The boolean value specifying whether the sync for the table into the destination is enabled.
`schemas.schema.tables.table.columns.column.is_primary_key`	Boolean	No
`schemas.schema.tables.table.columns.column.masking_algorithm`	String	No	Possible values: `"ENCRYPTED"` `"HASHED"` `"PLAINTEXT"`
`schemas.schema.tables.table.sync_mode`	String	No	This field appears in the response if the connection supports switching sync modes for tables Possible values: `"LIVE"` `"SOFT_DELETE"` `"HISTORY"`
`schema_change_handling`	String	No	The possible values for the schema_change_handling parameter are as follows: ALLOW_ALL - all new schemas, tables, and columns which appear in the source after the initial setup are included in syncs ALLOW_COLUMNS - all new schemas and tables which appear in the source after the initial setup are excluded from syncs, but new columns are included BLOCK_ALL - all new schemas, tables, and columns which appear in the source after the initial setup are excluded from syncs Possible values: `"ALLOW_ALL"` `"BLOCK_ALL"` `"ALLOW_COLUMNS"`

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.