JDBC Driver for Salesforce Pardot

Build 22.0.8462

ProspectAccounts

Retrieve and modify prospect accounts.

Table Specific Information

Select

The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM ProspectAccounts WHERE Id > 31

Get Deleted

To retrieve deleted prospect accounts, a GETDELETED statement can be executed.

GETDELETED FROM ProspectAccounts

Columns

Name Type References Description
Id [KEY] Int64 ID of the object.
Name String Name of the object.
SalesforceId String ID of the Salesforce object representing this object.
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
AnnualRevenue String Annual Revenue of the object.
BillingAddressOne String Billing Address of the object.
BillingAddressTwo String Second Billing Address of the object.
BillingCity String City of the object.
BillingCountry String County of the object.
BillingState String State of the object.
BillingZip String Zip of the object.
Description String Description of the object.
Employees String Employees of the object.
Fax String Fax of the object.
Industry String Industry of the object.
Number String Number of the object.
Ownership String Ownership of the object.
Phone String Phone Number of the object.
Rating String Rating of the object.
ShippingAddressOne String Shipping Address of the object.
ShippingAddressTwo String Second Shipping Address of the object.
ShippingCity String Shipping Address city of the object.
ShippingCountry String Shipping Address country of the object.
ShippingState String Shipping Address state of the object.
ShippingZip String Shipping Address zip of the object.
Sic String SIC of the object.
Site String Site of the object.
TickerSymbol String Ticker Symbol of the object.
Type String Type of the object.
Website String Website of the object.
CreatedAt Datetime Creation time of the object.
UpdatedAt Datetime Last update time of the object.
AssignedToId Int64 ID of the user who the object record is assigned to.
CreatedById Int64 ID of the individual who created this object.
UpdatedById Int64 ID of the individual who last updated this object.

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