Skip to main content

Pardot (Salesforce Marketing Cloud Account Engagement)

Availability:
Available Airbyte CloudAvailable Airbyte OSSAvailable PyAirbyte
Support Level:
Marketplace
Connector Version:
1.0.0(Last updated 4 hours ago)
Sync Success Rate:
Usage Rate:

Overview​

This page contains the setup guide and reference information for the Pardot (Salesforce Marketing Cloud Account Engagement) source connector.

Prerequisites​

  • Pardot/Marketing Cloud Account Engagement account
  • Pardot Business Unit ID
  • Client ID
  • Client Secret
  • Refresh Token

Setup Guide​

Required configuration options​

  • Pardot Business Unit ID (pardot_business_unit_id): This value uniquely identifies your account, and can be found at Setup > Pardot > Pardot Account Setup

  • Client ID (client_id): The Consumer Key that can be found when viewing your app in Salesforce

  • Client Secret (client_secret): The Consumer Secret that can be found when viewing your app in Salesforce

  • Refresh Token (refresh_token): Salesforce Refresh Token used for Airbyte to access your Salesforce account. If you don't know what this is, follow this guide to retrieve it.

Optional configuration options​

  • Start Date (start_date): UTC date and time in the format 2020-01-25T00:00:00Z. Any data before this date will not be replicated. Defaults to 2007-01-01T00:00:00Z (the year Pardot was launched)

  • Page Size Limit (page_size): The default page size to return; defaults to 1000 (which is Pardot's maximum). Does not apply to the Email Clicks stream which uses the v4 API and is limited to 200 per page.

  • Default Split Up Interval (split_up_interval): The default split up interval is used on incremental streams to prevent hitting Pardots limit of 100 pages per result (effectively 100K records on most endpoints). The default is P3M, which will break incremental requests into three-month groupings. If you expect more than 100K records to be modified between syncs in a single endpoint, you can increase the granularity to P1M, P14D, P7D, P3D, or P1D to reduce the maximum records to be paged through per split. For small accounts unlikely to hit the limit, decreasing the granularity to P6M or P1Y may increase the speed of those syncs, especially the initial backfill.

  • Is Sandbox App? (is_sandbox): Whether or not the app is in a Salesforce sandbox. If you do not know what this is, assume it is false.

Supported Sync Modes​

The Pardot source connector supports the following sync modes:

  • Full Refresh
  • Incremental

Incremental streams are based on the Pardot API's UpdatedAt field when the object is updateable and the API supports it; otherwise CreatedAt or Id are used in that order of preference.

Performance Considerations​

The Pardot connector should not run into Pardot API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.

tip

Due to timeouts on large accounts, the Split Up Interval (the time period used to page through incrementally) is surfaced as a configuration option. While the default should work for most accounts, large accounts may need to increase the granularity from the default. Similarly, small accounts may see faster initial syncs with a longer interval. See the Optional Configuration Options section for more details.

Supported Streams​

Several output streams are available from this source. Unless noted otherwise, streams are from Pardot's v5 API:

If there are more endpoints you'd like Airbyte to support, please create an issue.

Changelog​

VersionDatePull RequestSubject
1.0.02023-12-1249424Update streams to API V5. Fix auth flow
0.2.02024-10-1344528Migrate to LowCode then Manifest-only
0.1.222024-10-1246778Update dependencies
0.1.212024-10-0546441Update dependencies
0.1.202024-09-2846109Update dependencies
0.1.192024-09-2145799Update dependencies
0.1.182024-09-1445509Update dependencies
0.1.172024-09-0745307Update dependencies
0.1.162024-08-3145005Update dependencies
0.1.152024-08-2444728Update dependencies
0.1.142024-08-1744232Update dependencies
0.1.132024-08-1043471Update dependencies
0.1.122024-08-0343291Update dependencies
0.1.112024-07-2742649Update dependencies
0.1.102024-07-2042304Update dependencies
0.1.92024-07-1341886Update dependencies
0.1.82024-07-1041565Update dependencies
0.1.72024-07-0940884Update dependencies
0.1.62024-06-2640549Migrate off deprecated auth package
0.1.52024-06-2540339Update dependencies
0.1.42024-06-2240118Update dependencies
0.1.32024-06-0439087[autopull] Upgrade base image to v1.2.1
0.1.22024-05-2138521[autopull] base image + poetry + up_to_date
0.1.12022-12-1619618Fix visitors stream
0.1.02021-11-197091🎉 New Source: Pardot
Was this page helpful?