Availability

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level

Community

Latest Version

0.1.1

Pardot

Overview

The Airbyte Source for Salesforce Pardot

The Pardot supports full refresh syncs

Output schema

Several output streams are available from this source:

• Campaigns
• EmailClicks
• ListMembership
• Lists
• ProspectAccounts
• Prospects
• Users
• VisitorActivities
• Visitors
• Visits

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

Features

Feature	Supported?
Full Refresh Sync	Yes
Incremental Sync	No
SSL connection	No
Namespaces	No

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.

Getting started

Requirements

• Pardot Account
• Pardot Business Unit ID
• Client ID
• Client Secret
• Refresh Token
• Start Date
• Is Sandbox environment?

Setup guide

• pardot_business_unit_id: Pardot Business ID, can be found at Setup > Pardot > Pardot Account Setup
• client_id: The Consumer Key that can be found when viewing your app in Salesforce
• client_secret: The Consumer Secret that can be found when viewing your app in Salesforce
• 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.
• start_date: UTC date and time in the format 2017-01-25T00:00:00Z. Any data before this date will not be replicated. Leave blank to skip this filter
• is_sandbox: Whether or not the app is in a Salesforce sandbox. If you do not know what this is, assume it is false.

Reference

Config fields reference

Field

Type

Property name

string

pardot_business_unit_id

string

client_id

string

client_secret

string

refresh_token

string

start_date

boolean

is_sandbox

Changelog

Version	Date	Pull Request	Subject
0.1.1	2022-12-16	19618	Fix visitors stream
0.1.0	2021-11-19	7091	🎉 New Source: Pardot