Advanced Analytica Advanced Analytica: IBOM
← All connectors
Pardot logo

Source connector

Pardot

Set up Pardot as a source and move its data into your chosen destination.

Version 1.0.63 community alpha

Pardot (Salesforce Marketing Cloud Account Engagement)

Overview

Use this page to set up the Pardot (Salesforce Marketing Cloud Account Engagement) source connector and find reference information.

Prerequisites

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

Setup

Required options

  • Pardot Business Unit ID (pardot_business_unit_id): This value uniquely identifies your account. Find it at Setup > Pardot > Pardot Account Setup

  • Client ID (client_id): Find the Consumer Key by viewing your app in Salesforce

  • Client Secret (client_secret): Find the Consumer Secret by viewing your app in Salesforce

  • Refresh Token (refresh_token): Salesforce refresh token that Airbyte uses to access your Account Engagement data. To get one:

    1. In Salesforce Setup, create an External Client App with OAuth enabled. Since Spring ‘26, Salesforce no longer allows new connected apps by default. Existing connected apps continue to work.
    2. Select the Manage Pardot services (pardot_api) and Perform requests at any time (refresh_token, offline_access) OAuth scopes. Account Engagement rejects tokens without the pardot_api scope. See Account Engagement API authentication.
    3. Use the OAuth web server (authorization code) flow. Get a refresh token for a user with access to Account Engagement.
    4. Don’t turn on Refresh Token Rotation or Immediately expire refresh token for this app. The connector stores one refresh token. It can’t save the new token Salesforce issues after every refresh.

:::caution Refresh tokens expire after 30 days without use Starting November 4, 2026, Salesforce expires production refresh tokens that haven’t been used for 30 days. Each sync uses the refresh token and restarts the 30-day window. Your connection keeps working if it syncs at least once every 30 days. The refresh token expires if you pause the connection or schedule syncs less often. Syncs then fail to authenticate. To recover, generate a new refresh token and update the source. :::

Optional options

  • Start Date (start_date): Enter a UTC date and time in the format 2020-01-25T00:00:00Z. Data before this date won’t be replicated. Defaults to 2007-01-01T00:00:00Z, the year Pardot launched

  • Is Sandbox App? (is_sandbox): Indicates whether the app is in a Salesforce sandbox. If you’re unsure, assume it is false.

Supported sync modes

The Pardot source connector supports these sync modes:

  • Full Refresh
  • Incremental

Incremental streams use the Pardot API’s UpdatedAt field when the object is updateable and the API supports it. Otherwise, they use CreatedAt, then Id, in that order.

Performance

The Pardot connector shouldn’t reach Pardot API limits during normal use. If rate limit issues aren’t retried successfully, create an issue.

:::tip

Pardot sets daily API limits based on your plan level. If you reach a limit, the connector retries every two hours until the quota is replenished.

:::

Supported streams

This source provides several output streams. Unless noted otherwise, streams use Pardot’s v5 API:

If you’d like Airbyte to support more endpoints, create an issue.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

VersionDatePull RequestSubject
1.0.632026-11-1091648Update dependencies
1.0.622026-11-0390699Update dependencies
1.0.612026-10-2789997Update dependencies
1.0.602026-10-2089350Update dependencies
1.0.592026-10-1388747Update dependencies
1.0.582026-10-0687980Update dependencies
1.0.572026-09-2987294Update dependencies
1.0.562026-09-2286757Update dependencies
1.0.552026-09-1586177Update dependencies
1.0.542026-09-0885565Update dependencies
1.0.532026-08-1884703Update dependencies
1.0.522026-08-1184070Update dependencies
1.0.512026-08-0483553Update dependencies
1.0.502026-07-2883046Update dependencies
1.0.492026-07-2182532Update dependencies
1.0.482026-07-1481946Update dependencies
1.0.472026-06-3081183Update dependencies
1.0.462026-06-2380586Update dependencies
1.0.452026-06-1679997Update dependencies
1.0.442026-06-0979466Update dependencies
1.0.432026-06-0278883Update dependencies
1.0.422026-04-2877362Update dependencies
1.0.412026-04-2176711Update dependencies
1.0.402026-03-3175820Update dependencies
1.0.392026-03-2475021Update dependencies
1.0.382026-03-1074501Update dependencies
1.0.372026-03-0374170Update dependencies
1.0.362026-02-1073068Update dependencies
1.0.352026-01-2072176Update dependencies
1.0.342026-01-1471683Update dependencies
1.0.332025-12-1870501Update dependencies
1.0.322025-11-2570091Update dependencies
1.0.312025-11-1869674Update dependencies
1.0.302025-10-2969020Update dependencies
1.0.292025-10-2168326Update dependencies
1.0.282025-10-1467800Update dependencies
1.0.272025-10-0767342Update dependencies
1.0.262025-09-3066393Update dependencies
1.0.252025-09-2466592Fix pagination when >100K records returned
1.0.242025-09-0965782Update dependencies
1.0.232025-08-2365172Update dependencies
1.0.222025-08-1664794Update dependencies
1.0.212025-08-0264264Update dependencies
1.0.202025-07-2663887Update dependencies
1.0.192025-07-1963399Update dependencies
1.0.182025-07-1263221Update dependencies
1.0.172025-07-0562559Update dependencies
1.0.162025-06-2861048Update dependencies
1.0.152025-06-2061736Fix lifecycle_stages - was erroneously top-level instead of a property of column
1.0.142025-05-2460515Update dependencies
1.0.132025-05-1060108Update dependencies
1.0.122025-05-0459521Update dependencies
1.0.112025-04-2759088Update dependencies
1.0.102025-04-1958468Update dependencies
1.0.92025-04-1257875Update dependencies
1.0.82025-04-0557321Update dependencies
1.0.72025-03-2956777Update dependencies
1.0.62025-03-2256190Update dependencies
1.0.52025-03-0855566Update dependencies
1.0.42025-03-0155009Update dependencies
1.0.32025-02-2354624Update dependencies
1.0.22025-02-1547530Update dependencies
1.0.12025-01-1051040Fix schemas, adjust error handling, remove split-up interval
1.0.02024-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
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.