Release Noteslink
April 2024link
Our commercetools connector is now generally available. Read our commercetools connector documentation..
You can now configure your commercetools connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
Our Local Processing Agent Management API resource is now Private Preview. You can now leverage the following features:
- Create a Local Processing Agent
- List Local Processing Agents
- Retrieve Local Processing Agent Details
- Delete a Local Processing Agent
- Regenerate authentication keys for a Local Processing Agent
We now support syncing PGP (Pretty Good Privacy) encrypted files. We have added a new advanced configuration, PGP Encryption Options, to the connector setup form. For more information, see our setup instructions and the REST API config.
We now support the OAuth machine-to-machine (M2M) authentication type to connect to Databricks destinations. Previously, we supported only Databricks personal access token authentication type. Effective April 24, 2024, all new destinations exclusively use the OAuth machine-to-machine (M2M) authentication type. However, existing destinations that were set up before April 24, 2024 support both OAuth machine-to-machine (M2M) and Databricks personal access token authentication types.
To support this enhancement, we have made the following changes:
- Added a new drop-down menu, Authentication Type, to the setup form of existing destinations that were set up before April 24, 2024. The drop-down menu lets you choose the authentication method you want Fivetran to use.
- Added two new fields, OAuth 2.0 Client ID and OAuth 2.0 Secret, to the destination setup form.
- Added two new parameters,
oauth2_client_id
andoauth2_secret
, to the Fivetran REST API.
For more information, see our setup instructions and REST API documentation. We are gradually rolling this change to all existing destinations.
We now sync data from the columns whose name start with a numeric character as Databricks has started supporting such column names. Previously, we did not sync any data from columns whose name started with a numeric character. To backfill the historical data for these columns, re-sync the associated tables. We are gradually rolling this change to all existing destinations.
March 2024link
For the following endpoints, we added a new field, daylight_saving_time_enabled
:
If the field value is set to true
, the UTC offset is shifted in accordance with the daylight saving time. This option can only be used for the US region.
We have renamed the API key field to Personal API token in the CircleCI connector setup form and API configuration parameters.
You can now configure your Duoplane connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.
We have added a new toggle, Non-standard character escaping, in the connector setup form to support the non-standard ways of escaping characters. If your CSV generator uses non-standard ways of escaping character, enable the toggle and in the Character Escaping options drop-down menu, select one of the following options.
- Custom Escape Character: To process CSV files that use custom escape character to escape quotation marks.
- Delimited Only: To process CSV files that don't use escape character to escape quotation marks and process with delimiter only.
For more information, see our setup instructions and REST API config. We will gradually roll out this change to all existing connectors.
Our Proxy Agent Management API resource is now beta. You can now leverage the following features:
- Create a Proxy Agent
- List all Proxy Agents
- Retrieve Proxy Agent Details
- Delete a Proxy Agent
- Returns all connections attached to the proxy agent
- Attach connection to the proxy agent
- Detach connection from the proxy agent
February 2024link
We have renamed the API Key field to User token in the connector setup form. We have also modified our REST API configuration parameters and replaced the api_key
with user_token
. For more information, see our setup instructions and REST API config.
You can now specify your custom API base URL while setting up your connector. To support this enhancement, we have made the following changes:
- Added a new option, CUSTOM, to the API server region drop-down menu and a new field, Access URL, to the connector setup form.
- Added a new parameter,
custom_url
, to the Fivetran REST API.
For more information, see our setup instructions and REST API documentation.
We now use API v4 of SAP Concur to sync the LIST
table. Previously, we used API v3 of SAP Concur to sync the table. To ensure data integrity, we recommend that you re-sync the LIST
table. We are gradually rolling out this improvement to all existing connectors.
January 2024link
You can now configure your Ramp connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Buildkite connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Campaign Monitor connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your ChartMogul connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Chorus connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Close connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Freightview connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Lob connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Monday.com connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Rarible connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Statsig connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
We now use both project access tokens and account access tokens to access and sync your Rollbar data. To facilitate this enhancement, we have made the following changes:
- In the connector setup form, we have added a new field, Project access token, and renamed the Access Token field to Account access token
- In the Fivetran REST API, we have added a new parameter,
project_access_token
, and renamed theaccess_token
parameter toaccount_access_token
For more information, see our setup guide and API connector configuration documentation.
We have added a new toggle, Non-standard character escaping?, in the connector setup form to support the non-standard ways of escaping characters. If your CSV generator uses non-standard ways of escaping characters, enable the toggle and in the Character Escaping options drop-down menu, select one of the following options.
- Custom Escape Character: To process CSV files that use custom escape characters to escape quotation marks.
- Delimited Only: To process CSV files that don't use escape characters to escape quotation marks and process with delimiter only.
For more information, see our setup instructions and REST API config. We will gradually roll out this change to all existing connectors.
We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information see our setup instructions.
Our HVR Registration API resource is now beta. You can now leverage the following feature:
December 2023link
We now display the created_at
field for each user in the response for the following endpoints:
We now return group_id
, role
, and created_at
for the Update group membership endpoint.
We now return connector_id
, role
, and created_at
for the Update connector membership endpoint.
We have implemented new Connector Management API endpoints for our REST API. You can now leverage the following new features:
November 2023link
You can now configure your OneLake destination using the Fivetran REST API.
Our Log Service Management API resource is now generally available. You can now leverage the following features:
- Create a Log Service
- Retrieve Log Service Details
- Update a Log Service
- Delete a Log Service
- Run Log Service Setup Tests
You can now specify custom payloads as key-value pairs when you configure the Azure Functions connector using our REST API.
October 2023link
We have transferred pre-built reports from the connector setup form to the Schema tab of your Fivetran dashboard. Pre-built reports are now included by default and are treated as metadata tables, which means the only configurable option for them is select or deselect. This change is applicable to all new connectors created after October 13, 2023. You can now use the Connector Management API to modify pre-built reports in the same way as metadata tables. To do so, submit API requests to the Modify a Connector Schema Config endpoint.
You can now configure the API usage limit of the Kustomer connector using our REST API. Previously, the default API usage limit was 90%. For more information, see our Kustomer API Configuration documentation.
We no longer support the PLAINTEXT security protocol. We support only SASL. In the destination setup form, we have removed the Security Protocol drop-down menu. In the REST API configuration, we no longer support the PLAINTEXT
value for the security_protocol
parameter.
September 2023link
You can now specify secrets as key-pair values when you configure the Azure Functions connector using our REST API.
You can now specify secrets as key-pair values when you configure the Google Cloud Functions connector using our REST API.
You can now configure your Azure Data Lake Storage (ADLS) destination using the Fivetran REST API.
You can now configure your Slack connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
We have implemented new Group Management API endpoints for our REST API. You can now leverage the following new features:
August 2023link
You can now configure your GoCardless connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Ironclad connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Sonarqube connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Drift connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Subscript connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Survicate connector using the Fivetran REST API. This feature is available only for the Free, Standard, Enterprise, and Business Critical accounts.
We have added the Log Service Management API and Transformations for dbt Core Management API to our Postman collection.
Our dbt Transformations Management API is now Beta. You can now leverage the following features:
- Create dbt Project
- Retrieve dbt Projects
- Retrieve dbt Project details
- Test dbt Project
- Retrieve dbt Project Models
- Retrieve dbt Project Model details
- Create dbt Transformation
- Retrieve dbt Transformations
- Retrieve dbt Transformation details
- Modify dbt Transformation
- Delete dbt Transformation
- Cancel dbt Transformation
- Run dbt Transformation
- Pause dbt Transformation
- Resume dbt Transformation
You can now specify the events and custom events that you want to sync when you configure the Iterable connector using our REST API.
Our Webhook Management API is now generally available.
We have changed the Salesfore connector's API response to the Retrieve Connector Details API request to return the connecting_user_email
, organization_id
, and username
fields in the config
section of the response instead of the source_sync_details
section.
For the Transformations for dbt Core Management API, we added a new field,
environment_vars
. You can now manage the list of environment variables defined as key-value pairs.The
enabled
field in the Log Service Management API's Create a Log Service method now has thetrue
value by default.We added a new field,
connector_class
, in the Retrieve connector types and Retrieve connector type details methods. This field contains the connector category (standard
orlite
). Learn more about connector categories in our Differences between Standard and Lite connectors documentation.
Our Log Service Management API resource is now in beta. You can now leverage the following features:
- Create a Log Service
- Retrieve Log Service Details
- Update a Log Service
- Delete a Log Service
- Run Log Service Setup Tests
You can now configure your Aircall connector using the Fivetran REST API. This feature is available only for the Free, Standard, Enterprise, and Business Critical accounts.
Fivetran provider for Terraform is now generally available.
We now validate that the external_id
value that you specify when creating the Amazon S3 connector using the REST API is the same as your Fivetran account's group_id
. Make sure to choose any of the group_id
from your Fivetran account as the external_id
parameter value. To find the group_id
, use the List All Groups endpoint.
You can now configure your Chargebee Product Catalog 2.0 connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Chargebee Product Catalog 1.0 connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
July 2023link
We have changed the response code for the Delete Webhook endpoint from HTTP 204 to HTTP 200.
We now support the following new webhook events:
- connection_successful
- connection_failure
- create_connector
- pause_connector
- resume_connector
- edit_connector
- delete_connector
- force_update_connector
- resync_connector
- resync_table
We have made the active
field optional in the Сreate Account Webhook and Create Group Webhook endpoint requests. By default, the field value is set to true
.
We have implemented two new endpoints in our REST API, Retrieve Function Connector State and Update Function Connector State that allow you to get and update the state of function connectors, respectively.
You can now configure your Open Exchange Rates connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Assembled connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Split connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now opt to sync Salesforce formula fields using our REST API. For more information, see our API Configuration documentation.
We have updated the Adobe Analytics connector's REST API configuration parameters to support aggregating data by week. Learn more in our Adobe Analytics Connector Config documentation.
June 2023link
You can now configure the API usage limit of the Qualtrics connector using our REST API. For more information, see our Qualtrics API Configuration documentation.
Now, when you configure the AWS Lambda connector using our REST API, you can:
- Connect using AWS PrivateLink if your Lambda function and destination are in the same AWS Region. This feature is available only on the Business Critical plan.
- Select your sync method. You can opt to sync directly or through an S3 bucket.
You can now configure your BigCommerce connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
We now support the edit_connector
webhook event for manual or automatic connector status changes. Namely, this webhook event is raised for setup-state
and schema-status
property changes, which are reflected in editType
.
The following edit_connector
webhook events are shown below as being relevant for the How to Set Up a Schema Before the Initial Sync use case.
{
event: 'edit_connector',
// ...
editType: 'UPDATE_SETUP_STATE',
properties: { setupState: 'connected' },
oldProperties: { setupState: 'incomplete' }
}
{
event: 'edit_connector',
// ...
editType: 'UPDATE_SETUP_STATE',
properties: { setupState: 'broken' },
oldProperties: { setupState: 'connected' }
}
{
event: 'edit_connector',
// ...
editType: 'UPDATE_SCHEMA_STATUS',
properties: { schemaStatus: 'blocked_on_capture' },
oldProperties: { schemaStatus: 'ready' }
}
{
event: 'edit_connector',
// ...
editType: 'UPDATE_SCHEMA_STATUS',
properties: { schemaStatus: 'blocked_on_customer' },
oldProperties: { schemaStatus: 'blocked_on_capture' }
}
{
event: 'edit_connector',
// ...
editType: 'UPDATE_SCHEMA_STATUS',
properties: { schemaStatus: 'ready' },
oldProperties: { schemaStatus: 'blocked_on_customer' }
}
You can now configure your Calendly connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
May 2023link
You can now configure your Confluent Cloud destination using the Fivetran REST API.
You can now configure your S3 Data Lake destination using the Fivetran REST API.
Now, we deactivate a webhook if it consistently fails for more than three days and only responds with non-2xx codes. To activate the webhook, ensure that the setup is correct by retrieving the webhook details and updating them with corrected information along with passing "active": true
in the request. Alternatively, you can create a new webhook.
April 2023link
You can now configure your Fountain connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Lattice connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
March 2023link
We have added the following new fields to the response for our REST API Webhook endpoints:
code
message
data
The data
field contains all fields returned in the response in the old format.
An example of the previous response format:
{
"id": "program_quoth",
"type": "account",
"url": "https://your-host.your-domain/webhook",
"events": [
"sync_start",
"sync_end"
],
"active": true,
"secret": "******",
"created_at": "2022-04-29T09:41:08.583Z",
"created_by": "_airworthy"
}
An example of the new response format:
{
"code": "Success",
"message": "Account webhook has been created",
"data": {
"id": "program_quoth",
"type": "account",
"url": "https://your-host.your-domain/webhook",
"events": [
"sync_start",
"sync_end"
],
"active": true,
"secret": "******",
"created_at": "2022-04-29T09:41:08.583Z",
"created_by": "_airworthy"
}
}
Fivetran now takes into account all connectors specifics and returns the correct name_in_destination
field value for schemas in the response for the following REST API endpoints:
- Retrieve a Connector Schema Config
- Reload a Connector Schema Config
- Modify a Connector Schema Config
- Modify a Connector Database Schema Config
- Modify a Connector Table Config
- Modify a Connector Column Config
Previously, we returned the schema name only with the generic naming rules applied.
You can now configure your Salesforce Commerce Cloud connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
For the service
parameter in the API request for our Databricks destination, you now need to specify databricks
as a value. The old values databricks_aws
and databricks_azure
are still valid.
February 2023link
You can now configure your Gong connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your Crossbeam connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
You can now configure your High-Volume Agent Db2 for i connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
January 2023link
You can now generate scoped API keys to use with our REST API.
You can now configure your Okta connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
December 2022link
You can now configure your WooCommerce connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
November 2022link
You can now configure your ActiveCampaign connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
Now, you can configure the API usage limit of the Zendesk Support connector using our REST API. Previously, the default API usage limit was 90%. For more information, see our Zendesk Support API Configuration documentation.
You can now configure your Azure Service Bus connector using the Fivetran REST API. The feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
In the LinkedIn Ad Analytics REST API configuration, we have removed the 90-day option from the postClickAttributionWindowSize
and viewThroughAttributionWindowSize
fields because data older than 30 days cannot be updated.
You can now specify secrets as key-pair values when you configure the Lambda connector using our REST API.
October 2022link
We have added the schema_status
parameter to our Modify a Connector endpoint. You can use it to capture the connector schema before the initial sync. For more information, see our documentation.
September 2022link
We have extended packed mode support to our REST API. You can now select the sync mode for your database tables and also specify the tables you want to sync using packed mode.
We have extended packed mode support to our REST API. You can now select the sync mode for your database tables and also specify the tables you want to sync using packed mode.
August 2022link
We have added a new icons
field to the Retrieve source metadata and Retrieve connector configuration metadata endpoint responses. This field contains a list of additional icon URLs in different formats (for example, .svg or .png) for the connector.
We have changed the retry algorithm for sending webhooks. We now use an exponential backoff strategy - we wait 6 minutes before the first retry, 21 minutes before the second retry, and so on. Learn more in our Retries documentation.
We have added a new check that we perform during the webhook creation or activation. The endpoint specified in the payload should exist and return a successful HTTP code. Otherwise, we will return an HTTP 400 Bad Request
error.
July 2022link
We have added the Webhook management endpoints to our Postman collection.
We have implemented email notification that informs you about webhook event sending failure. To turn it on, go to Account notifications page and change the Receive an email when webhook events failed to be sent
value.
We have added two new optional parameters, is_account_level_connector
and group
, to the Fivetran Platform Connector REST API Request. You can now opt to retrieve account-level logs.
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Intercom connector by adding the auth
section to payloads.
You can now configure your OneDrive connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.
June 2022link
We have updated the Adobe Analytics connector's REST API configuration parameters to support separate configuration for each table. Learn more in our Adobe Analytics Connector Config documentation.
In the sync mode
parameter of the Google Campaign Manager 360 API configuration, we replaced the following:
AllAccounts
value withALL_PROFILES
SpecificAccounts
value withSPECIFIC_PROFILES
May 2022link
We have implemented a new API endpoint for our REST API, Re-sync Connector Data (Historical Sync), that allows you to trigger a full historical sync of a connector or multiple schema tables within a connector.
We have updated the Sync Connector Data endpoint with a new path, sync
. We also added a new payload parameter, force
, that allows you to force a sync, even if a sync is already in progress.
April 2022link
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Google Search Console connector by adding the auth
section to payloads.
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the YouTube Analytics connector by adding the auth
section to payloads.
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Twitter Organic connector by adding the auth
section to payloads.
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Pinterest Ads connector by adding the auth
section to payloads.
We have implemented the following new API endpoints for our REST API:
New resources: Team Management Private Preview
New endpoints in User Management: Connector memberships Private Preview
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Verizon Media connector by adding the auth
section to payloads.
We have implemented a new resource, Webhook Management, for our REST API. This feature is in beta. You can now leverage the following new features:
- Create account webhook
- Create group webhook
- Retrieve webhook details
- Update webhook
- Delete webhook
- Retrieve the list of webhooks
- Test webhook
March 2022link
We've updated the REST API config format for the Google Ads connector. See the Google Ads configuration section in our REST API documentation for details.
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Zoho CRM connector by adding the auth
section to payloads.
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Instagram Business connector by adding the auth
section to payloads.
February 2022link
We have updated the Adobe Analytics connector's REST API configuration parameters to support aggregating data by month, quarter, and year. Learn more in our Adobe Analytics Connector Config documentation.
We have added the following new regions:
GCP_US_EAST4
GCP_US_WEST1
GCP_EUROPE_WEST3
GCP_AUSTRALIA_SOUTHEAST1
GCP_NORTHAMERICA_NORTHEAST1
GCP_EUROPE_WEST2
GCP_ASIA_SOUTHEAST1
AWS_US_EAST_1
AWS_US_EAST_2
AWS_US_WEST_2
AWS_AP_SOUTHEAST_2
AWS_EU_CENTRAL_1
AWS_EU_WEST_1
AWS_EU_WEST_2
AZURE_EASTUS2
AZURE_AUSTRALIAEAST
GCP_ASIA_SOUTH1
We have deprecated the following regions:
US
EU
APAC
UK
CANADA
SINGAPORE
We have changed the Add a User to a Group API response message to more accurately reflect the action performed.
Before:
{
"code": "Success",
"message": "User has been invited to the group"
}
Now:
{
"code": "Success",
"message": "User has been added to the group"
}
January 2022link
We have implemented the following new API endpoints for our REST API:
New resources: Role Management Beta
New endpoints in User Management:
December 2021link
We now use connector-types
instead of connectors
in the paths for the following metadata endpoints:
- Retrieve source metadata - the new path format is as follows: https://api.fivetran.com/v1/metadata/connector-types
- Retrieve connector config metadata - the new path format is as follows: https://api.fivetran.com/v1/metadata/connector-types/{connector_type}
We support the old path format for backward compatibility. The sunset date for the old path format is April 1, 2022.
We have removed the Show button in the API config section on the Security tab of your Account Management page. Click the Generate button to view your API key and secret.
Click Generate new secret to generate a new API secret and replace the existing secret.
November 2021link
You can now use a custom external_id
parameter when you create a new Amazon S3 connector with the Fivetran REST API.
NOTE: Connectors created in the Fivetran dashboard do not support custom
external_id
values, so they use the connector'sgroup_id
by default instead.
October 2021link
You can now configure your Box connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
We now return the connector_id
field in the Connect Card token endpoint response.
For more information, see our Connect Card documentation.
You can now configure your Google Drive connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
For improved security, we will remove the Show button in the API config section on the Security tab of your Account Management page.
The API key and secret are essentially credentials that allow you to access your account using the API. Never share your API key or secret with anyone.
September 2021link
You can now re-sync data for multiple tables using the Re-sync Connector Table Data endpoint.
For accounts created after September 9, 2021, we return the connector configuration response in the V2 format by default.
See our Retrieve Connector Details endpoint documentation for details.
We have implemented a new API endpoint for our REST API, Retrieve connector configuration metadata.
August 2021link
We have added validation for the schema
and table
path parameters for the Re-sync Connector Table Data endpoint. For a request to succeed, you need to specify its parameters correctly.
When you call this endpoint with an incorrect schema
value, you receive the following error:
HTTP 404
"message" : "Cannot find entity 'Schema' with id '<your_connector_schema_id>'."
NOTE: Your previously successful request may fail with the error, indicating that you have been using the wrong
schema
value.
You can find the name of your database schema and table on the Schema tab of the connector details page.
NOTE: Make sure you don't use the connector schema name instead of the database schema name.
See our Re-sync Connector Table Data endpoint documentation for details.
July 2021link
We have expanded the current public API endpoints Create a connector and Modify a Connector. Now, you can create or modify the connector that will be paused after the trial period by specifying the pause_after_trial
request parameter.
You can now configure your SAP Concur connector using the Fivetran REST API. This feature is only available for Standard and Enterprise accounts.
We have implemented a new format (V2) for consistency in the destination configuration information. This format is valid for the following destinations:
For more information, see our V2 config format documentation.
We have changed the data type of the picture
field defining the user avatar to STRING. Now, we support both image URL (for example, http://mycompany.com/avatars/john_white.png
) and Base64 data URI (for example, data:image/png;base64,aHR0cDovL215Y29tcGFueS5jb20vYXZhdGFycy9qb2huX3doaXRlLnBuZw==
) values for this field.
See our User Management endpoint documentation.
We now display the role
field for each user in the response for the following endpoints:
You can now configure your Sage Intacct connector using the Fivetran REST API. This feature is available only for Standard and Enterprise accounts.
June 2021link
We now display the role
field for each user in the response for the List All Users endpoint.
We have implemented a new Group Management API endpoint for our REST API. You can now leverage the new Modify a group feature.
We have expanded the Create a connector endpoint. Now, you can:
- set the frequency of your syncs using the
sync_frequency
request parameter - set the start time of your daily syncs using the
daily_sync_time
request parameter if you set thesync_frequency
parameter to1440
May 2021link
We have implemented a new Group Management API endpoint for our REST API. You can now leverage the new Delete a group feature.
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Asana connector by adding the auth
section to payloads.
April 2021link
We have published Postman collection, which contains templates to help you create API requests for all endpoints supported by Fivetran.
We have added a schema filter to our List All Connectors within a Group endpoint. Specify the schema of a connector as a value of the schema
GET parameter to perform filtering and retrieve only information for that connector.
We have expanded the Create a Connector and Modify a Connector public API endpoints. Now you can authorize the following connectors by adding the auth
section to payloads:
March 2021link
We now support the timeframe_months
field for Facebook Ads connectors created using the Create a Connector endpoint. Learn more about Facebook Ads connector management in our REST API documentation.
We now display the name_in_destination
field for each schema, table, and column in the response for the following endpoints:
- Retrieve a connector schema config
- Retrieve source table columns config
- Reload a connector schema config
- Modify a connector schema config
- Modify a connector database schema config
- Modify a connector table config
- Modify a connector column config
Now, you can set the time your daily syncs start using the daily_sync_time
request parameter for the Modify a Connector endpoint.
We have implemented new API endpoints for our REST API:
Destination Managementlink
Certificate Managementlink
You can also approve certificates and fingerprints automatically by specifying true
as a value of the new trust_certificates
and trust_fingerprints
parameters in the existing Destination Management API endpoints:
February 2021link
Our Jira connector no longer uses the use_webhooks
configuration field.
January 2021link
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth
section to payloads:
We have introduced a new (v2) connector configuration return format for the following endpoints:
We have implemented a new Certificate Management API endpoint for our REST API. You can now leverage the new Approve a connector fingerprint feature.
You can also approve fingerprints automatically by specifying true
as a value of the new trust_fingerprints
parameter in the existing Connector Management API endpoints:
December 2020link
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth
section to payloads:
- AdRoll
- Facebook Pages
- Front
- Google Ad Manager
- Help Scout
- LinkedIn Ad Analytics
- Optimizely
- Pipedrive
- SurveyMonkey
- Zendesk Chat
- Zendesk Support
We have implemented new Connector and Destination Management API endpoints for our REST API. You can now leverage the following new features:
November 2020link
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth
section to payloads:
October 2020link
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth
section to payloads:
We have made changes to all public API endpoints that return the table and column configs as a response. Now you can see patch settings information for tables and columns in the response. It may help you understand whether you are allowed to enable or disable sync for them in the connector standard config. See the documentation for the following endpoints to learn more about the patch settings:
- Retrieve a Connector Schema Config
- Retrieve source table columns config
- Reload a connector schema config
- Modify a connector schema config
- Modify a connector database schema config
- Modify a connector table config
- Modify a connector column config
September 2020link
We have added a new optional parameter, hide_setup_guide
, to our Connect Card. It lets you hide the embedded setup guide.
We have implemented a new Connector Management API endpoint for our REST API. You can now leverage the new Retrieve Source Table Columns Config feature.
August 2020link
We have expanded the current public API endpoint Reload a Connector Schema Config. Now, you can enable or disable all schemas, tables and columns in the standard config by specifying the exclude_mode
parameter in payloads.
Our Databricks REST API endpoint now supports the creation of external tables. You can now opt to create Delta tables as external tables for your Databricks implementations.
We made our REST API available for all Trial accounts. To learn about limitations for Trials as compared to Standard and Enterprise accounts, read our rate-limiting documentation.
We have updated the connector's REST API configuration parameters to support JSON Web Token (JWT) Authentication. See our Adobe Analytics Connector Config documentation for more information.
We have updated the REST API configuration parameters to support new authentication mechanisms for the following connectors:
- Adobe Analytics now supports JSON Web Token (JWT) Authentication. See our Adobe Analytics Connector Config documentation for more information.
- Twilio now supports authentication using API Keys. See our Twilio Connector Config documentation for more information.
July 2020link
You can now configure your Webhooks connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Snowplow connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
We have implemented new Destination Management API endpoints for our REST API. You can now leverage the new Retrieve Destination Details feature.
We have expanded the current public API endpoint Create a Connector. Now, you can create a new connector in a paused state by specifying the paused
parameter in payloads.
June 2020link
We have implemented new Connector, Group, and Destination Management API endpoints for our REST API. You can now leverage the following new features:
We have expanded the current public API endpoint Create a Destination. Now, you can:
- control whether setup test are executed automatically by specifying the
run_setup_tests
parameter. - create a Snowflake destination with password-based or key-based authentication types. Read our updated documentation about Snowflake destination config.
You can now configure your Google Ad Manager connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
May 2020link
You can now configure your Mailchimp connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
We have modified one of our REST API configuration parameters for Anaplan. We have replaced the exports
field with the selected_exports
field to sync specific exports. Each export in selected_exports
field must be in the <workspace_id>_<model_id>_<export_id>
format.
You can now configure your Facebook Ad Account connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Dropbox connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your LinkedIn Ad Analytics connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Snapchat Ads connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Splunk connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Mavenlink connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Jira connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Verizon Media connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your HubSpot connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Oracle, Oracle RDS, and Oracle E-Business Suite connectors using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Eloqua connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Braze connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Asana connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your GitHub connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Pinterest Ads connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Microsoft Advertising connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Facebook Pages connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
April 2020link
You can now configure your Shopify connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your QuickBooks connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Zendesk Chat connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Anaplan connector using the Fivetran REST API. This feature is in BETA and is available only for Enterprise accounts.
We have made changes to the re-sync connector table data endpoint. Now, if another data sync is in progress, we will try to complete it, and if it is unsuccessful the request will be declined and the HTTP 409 Conflict error will be returned.
You can now configure your Amplitude connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now generate a new API secret from the account settings form if you think your current one was compromised. Read our REST API docs to learn how to regenerate your secret.
You can now configure your Microsoft Dynamics 365 CRM connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Google Analytics connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Google Analytics 360 connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Pendo connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your AppsFlyer connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure the Fivetran Platform Connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Heap connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Lightspeed Retail connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Segment connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your AWS Inventory connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Google Play connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Help Scout connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Intercom connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Optimizely connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
We have added Magento MySQL and Magento MySQL RDS to the list of connectors that can be created via our REST API.
You can now configure your Adobe Analytics connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your AdRoll connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your MongoDB Sharded Cluster connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your Xero connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
March 2020link
You can now configure your Google Ads connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
We have implemented new Connector Management API endpoints for our REST API. You can now leverage the following new features:
- Modify a Connector Database Schema Config
- Modify a Connector Table Config
- Modify a Connector Column Config
- Run connector setup tests
You can now configure your Apple App Store connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
We have expanded the current public API endpoints Create a Connector and Modify a Connector. Now, you can control whether setup test are executed automatically by specifying the run_setup_tests
parameter. Read our REST API docs to learn how enable or disable automatic setup tests execution.
You can now configure your Google Search Console connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
You can now configure your ServiceNow connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
You can now configure your Google Campaign Manager 360 connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
February 2020link
You can now configure your Stripe connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
January 2020link
You can now configure your Adobe Analytics Data Feed connector through the Fivetran REST API.
You can now configure your Square connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
We have expanded the current public API Modify a Connector endpoint. Now you can enable or disable automatic connector sync by changing the 'schedule_type' parameter. Read our REST API docs to learn how to do that.
December 2019link
We have implemented new Connector Management API endpoints for our REST API. You can now leverage the following new features:
- Re-sync all historical data for a connector
- Sync connector data on demand (custom scheduling)
- Re-sync a specific table within a connector
- Retrieve a connector schema config
- Modify a connector schema config
September 2019link
We have disabled HTTP
protocol support for our REST API module for both public and partner APIs. To access the Fivetran REST API, you must now use HTTPS
protocol, which is much more secure.
July 2019link
You can now configure your Twitter Ads connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
May 2019link
You can now configure your Facebook Ad Insights connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
April 2019link
You can now configure your Salesforce connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
March 2019link
You can now configure your Zendesk connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.