Retrieve Source Table Columns Config
Returns the source table columns config for an existing connector within your Fivetran account
Request schema
Path parameters
The unique identifier for the connector within the Fivetran system
The database schema name within your destination
The table name within your database schema
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
GET /v1/connectors/connector_id/schemas/schema_name/tables/table_name/columns HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Host: api.fivetran.com
Responses
Successful response schema
Response status code
Response status text
The set of columns within your table schema config that are synced into the destination
additional property
The schema name within your destination in accordance with Fivetran conventional rules
The boolean value specifying whether the sync for the table into the destination is enabled.
The boolean value specifying whether a column should be hashed
The boolean value specifying whether the enabled property can be modified
The additional message indicating the reason why the enabled property cannot be modified. This field appears in the response only when the reason_code value is OTHER
The reason code indicating the reason why the enabled property cannot be modified:
SYSTEM_TABLE - the table is a system table
DELETED - the table was deleted in the source
OTHER - the table was excluded by the system for some reason
This field appears in the response when the allowed property value is FALSE
{
"code": "Success",
"message": "Operation performed.",
"data": {
"columns": {
"property1": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
},
"property2": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
}
}
}
}