JDBC Driver for Salesforce Pardot

Build 22.0.8462

Lists

Retrieve and modify lists.

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

For example, the following queries are processed server side:

SELECT * FROM Lists WHERE Id = 40
SELECT * FROM Lists WHERE IsDeleted = 'true'
SELECT * FROM Lists WHERE CreatedAt > '01/01/2022'

Insert

The following attribute is required when performing an insert: Name.

INSERT INTO Lists (Name) VALUES ('name')

Update

Update Lists attributes.

UPDATE Lists SET Name = 'newName' WHERE Id = 24143

Delete

Remove all lists or a list by specifying the Id of the list.

DELETE FROM Lists WHERE Id = 10003

GetDeleted

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

GETDELETED FROM Lists

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID of this list.

Name String False

List's name (internal to Pardot).

FolderId Int64 False

ID of the folder containing this object.

CampaignId Int64 False

Campaigns.Id

Pardot campaign related to this object. Uses null if not specified on create.

IsDeleted Boolean True

True if the object is in the recycle bin in Pardot.

IsDynamic Boolean True

True if the list is dynamic.

IsPublic Boolean False

True if the list is public.

Title String False

Title of the list object.

Description String False

List's description.

CreatedAt Datetime True

The timestamp of when this object was created.

UpdatedAt Datetime True

The timestamp of when this object was last updated.

CreatedById Int64 True

ID of the individual who created this object.

UpdatedById Int64 True

ID of the individual who last updated this object.

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