Pardot API Configuration
Request
POST https://api.fivetran.com/v1/connections
{
"group_id": "group_id",
"service": "pardot",
"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",
"config": {
"limit_for_api_calls_to_external_activities_endpoint": 150000,
"auth_type": "OAUTH | BASIC",
"user_key": "string",
"api_version": "V3 | V4",
"time_zone": "GMT+05:30",
"rest_api_limit": 150000,
"salesforce_security_token": "pardot_salesforce_security_token",
"historical_sync_limit_date": "2006-01-01",
"password": "pardot_password",
"historical_sync_limit": "THREE_MONTHS | SIX_MONTHS | ONE_YEAR | TWO_YEARS | FIVE_YEARS | ALL_TIME",
"business_unit_id": "pardot_business_unit_id",
"is_external_activities_endpoint_selected": true,
"historical_sync_limit_time_frame": "ALL_TIME | DATE_LIMIT",
"email": "pardot_user_email",
"schema": "schema_name"
},
"auth": {
"client_access": {
"client_secret": "my_client_secret",
"client_id": "my_client_id"
}
}
}Config parameters
| Name | Description |
|---|---|
limit_for_api_calls_to_external_activities_endpoint | API limit for the external activities endpoint. |
auth_type | Authenticate using OAuth or HTTP Basic |
user_key | |
api_version | API Version |
time_zone | The time zone configured in your Pardot instance. An empty value defaults to UTC+00:00. |
rest_api_limit | The number of API calls that the connector should not exceed in a day. Default REST API call limit per day: 150,000. |
salesforce_security_token | The Pardot user's Salesforce SSO Account Security Token. |
historical_sync_limit_date | The start date (YYYY-MM-DD) from which to sync historical data. |
password | The Pardot user's password. |
historical_sync_limit | The time range for which historical data should be synced. Default value: All Time. |
business_unit_id | Business Unit Id |
is_external_activities_endpoint_selected | Whether the EXTERNAL_ACTIVITY table must be synced or not. |
historical_sync_limit_time_frame | The options for time range for which historical data should be synced. Default value: All Time. |
email | The email of the Pardot user. |
schema | 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 value for the
client_accessparameter in theauthsection.POST https://api.fivetran.com/v1/connections{ "service": "pardot", "group_id": "group_id", "auth": { "client_access": { "client_secret": "my_client_secret", "client_id": "my_client_id" } } }Auth Parameters
Name Description client_accessclient_access.client_secretClient Secretof your Pardot client application.client_access.client_idClient IDof your Pardot client application.By using the Connect Card or the Fivetran dashboard.