Use Pardot as a data source

Resources

Data Source Type: REST/URL
Authentication: User Key
Sample Query:

For prospects created before today:

https://pi.pardot.com/api/prospect/version/3/do/query?created_before=today&user_key=your-user-key&api_key=your-api-key

 

If your endpoint query includes prospects, use Version 4 of Pardot's API. Refer to Pardot's documentation, Version 3 and Version 4 differences, for more information.

API Documentation: Pardot API Documentation

Step-by-Step

Create a new data source using Pardot

To create a data source using Pardot, you need to accomplish the following tasks:

  • Start the data source creation process.
  • Find your Pardot User Key.
  • Write your query and enter it into Klipfolio.
  • Authenticate and complete the data source creation process.

Note: This guide assumes that you already have an active Pardot account.

Step 1: Start the data source creation process

To create a data source using Pardot, go to the Connector Gallery page in Klipfolio and select Pardot.

Step 2: Find your Pardot User Key and API Key

To find your Pardot User Key, see Pardot documentation - Authentication.

Step 3: Write your query and enter it into Klipfolio

Pardot offers a variety of query options from which you can retrieve data. Refer to Pardot's API documentation for more query options. Here is a sample query to get you started:

For prospects created before today:

https://pi.pardot.com/api/prospect/version/3/do/query?created_before=today&user_key=your-user-key&api_key=your-api-key

Output formats

Output formats are defined by specifying the output request parameter. Supported output formats include:

    • full -- Returns all supported data for the Pardot object and all objects associated with it.

 

    • simple-- Returns all supported data for the data for the Pardot object.

 

    • mobile -- Returns an abbreviated version of the object data. This output format is ideal for mobile applications.

 

If the output request parameter is not defined, the output format defaults to full. See the XML Response Format sections for each object for details about the formats.

Note: Choosing XML or JSON in our configuration page may require the user to add another parameter to the query: i.e. format=JSON or format=XML.

Step 4: Authenticate and complete the data source creation process

Now that you have written your query:

  • At Data Format, depending on the query, select XML or JSON from the drop-down menu. Note: Choosing XML or JSON in our configuration page may require the user to add another parameter to the query: i.e. format=JSON or format=XML.
  • At Method, select GET.
  • At Query Parameters, select 2-Step Authentication from the drop-down menu.
  • At Username and Password, type your username and password.
  • At Response, select Text from the drop-down menu.
  • At Method, select POST from the drop-down menu.
  • At Body, type email=[username]&password=[password]&user_key=your-user-key.
  • At Parameters, type Content-Type under Name. application/x-www-form-urlencoded under Value, and Header under Type.
  • At Auth URL, type https://pi.pardot.com/api/login/version/3.
  • At Token Path, type <api_key>(.*?)</api_key>.
  • At Logout Method, select GET from the drop down menu.
  • Select Get Resource.
  • If you are satisfied with the data returned, select Continue.

Note: Pardot doesn't have a logout URL, so the logout method doesn't matter. This section can be safely ignored.

  Click the image to enlarge

Related links