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 Submit.
- 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.