Marketo API Configuration

Request

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

{
  "group_id": "group_id",
  "service": "marketo",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "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
  },
  "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": "SOURCE_NAMING",
  "config": {
    "soap_uri": "https://58-LBZ-000.mktoapi.com/soap/mktows/3_1",
    "prioritise_bulk_export_over_rest": true,
    "client_id": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
    "historic_sync_time_frame": "ONE_YEAR | ALL_TIME | FIVE_YEARS | TWO_YEARS | THREE_MONTHS | SIX_MONTHS",
    "historical_sync_limit_date": "2023-04-20",
    "historical_sync_limit": "ALL_TIME | DATE_LIMIT",
    "endpoint": "https://my.mktorest.com/rest",
    "user_id": "MKTOWS_58-LBZ-000_Y",
    "identity": "https://my.mktorest.com/identity",
    "api_quota": 10000,
    "encryption_key": "your_encryption_key",
    "client_secret": "your_api_secret",
    "schema": "schema_name"
  }
}

Config parameters

Name	Description
`soap_uri`	Marketo SOAP API Endpoint (Discontinued).
`prioritise_bulk_export_over_rest`	Use BULK for both LEAD and ACTIITIES
`client_id`	Marketo REST API Client Id.
`historic_sync_time_frame`	Range of data in history you would like to include in the initial sync. Default value: `ALL_TIME`.
`historical_sync_limit_date`	The start date (YYYY-MM-DD) from which to sync historical data.
`historical_sync_limit`	The time range for which historical data should be synced. Default value: `All Time`.
`endpoint`	Marketo REST API endpoint.
`user_id`	Marketo SOAP API User Id (Discontinued).
`identity`	Marketo REST API identity url.
`api_quota`	Allowed number of API requests to Marketo instance per day, the default value is 10000.
`encryption_key`	Marketo SOAP API Encryption Key (Discontinued).
`client_secret`	Marketo REST API Client Secret.
`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 endpoint, identity, client_id, client_secret and api_quota parameters in the request.

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

{
  "service": "marketo",
  "group_id": "group_id",
  "config": {
    "endpoint": "https://my.mktorest.com/rest",
    "identity": "https://my.mktorest.com/identity",
    "client_id": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
    "client_secret": "your_api_secret",
    "api_quota": 10000
  }
}

By using the Connect Card or the Fivetran dashboard.