Pardot Connector

Pardot Connector

Additional Documentation

This Connector is based on the Salesforce Pardot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/GPG/ado/

Overview

The Starfish Pardot Connector uses the pardot v3 API. See http://developer.pardot.com/ for more information.

Origin

Where do I find my "API User Key"?

In Pardot, hover over the gear icon in the upper right corner of the screen, click settings and click the My Profile tab.

Additional Parameters

MaxThreads=1

If you run into the error: "You have exceeded your concurrent request limit", you will need to limit the number of threads in use.  Do this with the MaxThreads Additional Parameter.

Sample Filters

Please review the "Supported Search Criteria" page for the endpoint you are using. For example, for the Lists end point, view: http://developer.pardot.com/kb/api-version-3/lists/#supported-search-criteria.

Samples name filter. Note the absence of single or double quotes around the string.

name=Act-On Migration: Active All List - MAILABLE CONTACTS

Sample ID filter. There does not appear to be a way to say ID equals x. I'm also unsure if you can say greater than x and less than y to get a single ID. I just filter by name.

id_greater_than=80183

Parameter
Description
API User Key
API Version

Pardot Connection Edit Screen


    • Related Articles

    • Hubspot Connector

      Additional Documentation This Connector is based on the Hubspot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DHG/ado/ Hubspot Connector Note: As of September 8, 2020 ...

    • Act! Connector

      ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: StarfishETL does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium (v18+) using ...

    • Sharepoint Connector

      Additional Documentation This Connector is based on the Sharepoint ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RSG/ado/ If connecting to Sharepoint using Single ...

    • CSV Connector

      Additional Documentation This Connector is based on the CSV ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RVG/ado/ CSV Via Upload (in Cloud Cartographer) When you upload ...

    • MySQL Connector

      MySQL Origin Note that the connection string must match the sample connection string shown in StarfishETL: server=<server_name>;uid={0};pwd={1};database=<db_name>; The string components must be placed in that order. {0} is a variable that refers to ...