ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

Lists

Retrieve and modify lists.

Table Specific Information

Select

The provider 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 provider.

  • 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

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] Integer True

Pardot ID of this list.

Name String False

List's name (internal to Pardot).

FolderId Integer False

ID of the folder containing this object.

CampaignId Integer 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.

IsDynamic Boolean True

True if the list is dynamic.

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 Integer True

ID of the individual who created this object.

UpdatedById Integer True

ID of the individual who last updated this object.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137