JDBC Driver for Salesforce Pardot

Build 22.0.8462

Campaigns

Retrieve and modify campaigns.

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 '=', '<', '<=', '>', '>='.
  • Name supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Campaigns WHERE Id = 50
SELECT * FROM Campaigns WHERE Name = 'campaignName'
SELECT * FROM Campaigns WHERE CreatedAt > '01/01/2022'

GetDeleted

To retrieve campaigns that are in the recycle bin in Pardot the following operation is supported:

GETDELETED FROM Campaings

Columns

Name Type References Description
Id [KEY] Int64 Pardot ID for this campaign.
Name String Campaign's name.
Cost Integer Cost associated to the campaign.
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
FolderId Int64 ID of the folder containing this object.
ParentCampaignId Int64 The ID of the parent campaign.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.
CreatedById Int64 ID of the individual who created this object.
UpdatedById Int64 ID of the individual who last updated this object.
SalesforceId String The alphanumeric Id of the Salesforce Org.

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