JDBC Driver for Salesforce Pardot

Build 22.0.8462

Prospects

Retrieve and modify prospects.

Columns

Name Type ReadOnly References Description
Id [KEY] Int63 True

Pardot ID for this prospect.

CampaignId Int63 False

Campaigns.Id

Pardot ID of the campaign associated with this prospect Note: Information about a prospect's campaign association is returned in a campaign node in the XML response. However, updates to campaign associations are done by providing campaign_id during an UPDATE> request. See XML Response Formats in Using Prospects for more details.

Salutation String False

Prospect's formal prefix.

FirstName String False

Prospect's first name.

LastName String False

Prospect's last name.

Email String False

Prospect's email address.

Password String False

Prospect's password.

Company String False

Prospect's company.

ProspectAccountId Int63 False

ProspectAccounts.Id

Prospect's account ID.

Website String False

Prospect's website URL.

JobTitle String False

Prospect's job title.

Department String False

Prospect's department.

Country String False

Prospect's country.

AddressOne String False

Prospect's address, line 1.

AddressTwo String False

Prospect's address, line 2.

City String False

Prospect's city.

State String False

Prospect's US state.

Territory String False

Prospect's territory.

Zip String False

Prospect's postal code.

Phone String False

Prospect's phone number.

Fax String False

Prospect's fax number.

Source String False

Prospect's source.

AnnualRevenue String False

Prospect's annual revenue.

Employees String False

Prospect's number of employees.

Industry String False

Prospect's industry.

YearsInBusiness String False

Prospect's number of years in business.

Comments String False

Comments about this prospect.

Notes String False

Notes about this prospect.

Score Integer False

Prospect's score.

Grade String True

Prospect's letter grade.

LastActivityAt Datetime True

Time stamp of this prospect's latest visitor activity.

RecentInteraction String True

Describes the prospect's most recent interaction with Pardot.

CrmLeadFid String True

Prospect's lead ID in a supported CRM system.

CrmContactFid String True

Prospect's contact ID in a supported CRM system.

CrmOwnerFid String True

Prospect's owner ID in a supported CRM system.

CrmAccountFid String True

Account ID in a supported CRM system.

CrmLastSync Datetime True

Last time this prospect was synced with a supported CRM system.

CrmUrl String True

URL to view the prospect within the CRM system.

IsDoNotEmail Boolean False

If value is 1, prospect prefers not to be emailed.

IsDoNotCall Boolean False

If value is 1, prospect prefers not to be called.

OptedOut Boolean True

If value is 1, prospect has opted out of marketing communications.

IsReviewed Boolean False

If value is 1, prospect has been reviewed.

IsStarred Boolean False

If value is 1, prospect has been starred.

CreatedAt Datetime True

Time prospect was created in Pardot.

UpdatedAt Datetime True

Last time prospect was updated in Pardot.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462