The Trade Desk API Configuration

For more information about authentication, accessing the Fivetran REST API, and request and response formats, see Getting Started with the Fivetran REST API.

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "the_trade_desk",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "LOW",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true,
    "all_fields": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "destination_schema_names": "FIVETRAN_NAMING",
  "external_secrets_manager_id": "esm_id",
  "config": {
    "login": "test_login",
    "partners": [
      "string"
    ],
    "password": "xxxxxxxxxx",
    "report_templates": [
      "string"
    ],
    "sync_mode": "AllAccounts | SpecificAccounts",
    "timeframe_months": "TWENTY_FOUR | SIX | ALL_TIME | TWELVE | THREE",
    "schema": "schema_name"
  }
}

Config parameters

Name	Description
`login`	The Trade Desk email. It is a part of the login credentials.
`partners`	Specific Partner IDs to sync. Must be populated if `syncMode` is set to `SpecificAccounts`.
`password`	The Trade Desk password. It is a part of the login credentials.
`report_templates`	Report templates to sync.
`sync_mode`	Whether to sync all accounts or specific accounts.
`timeframe_months`	Number of months' worth of data you'd like to include in your initial sync. Increasing this value does not automatically backfill older data for tables that have already synced; trigger a resync for those tables to apply the new time frame. Default value: `THREE`.
`schema` (required)	Destination schema name. Schema name is permanent and cannot be changed after connection creation

Authorization

There are two ways to authorize this connector type:

By specifying the values for the login and password parameters in the request.

POST https://api.fivetran.com/v1/connections

{
  "service": "the_trade_desk",
  "group_id": "group_id",
  "config": {
    "login": "test_login",
    "password": "xxxxxxxxxx"
  }
}

By using the Connect Card or the Fivetran dashboard.