JDBC Driver for Salesforce Pardot

Build 22.0.8462

Folders

Retrieve folders or organize and nest your content and marketing assets in a way that makes sense for your team.

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 '=', '<', '<=', '>', '>='.
  • ParentFolderId supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Folders WHERE Id = 50
SELECT * FROM Folders WHERE ParentFolderId = 2

Columns

Name Type References Description
Id [KEY] Int64 Pardot ID of this file.
Name String Name of the folder.
ParentFolderId Int64 ID of the folder containing this folder. This value is null when the folder is a root folder and doesn't have a parent.
Path String The names of each folder from the root folder separated with forward slashes.
UsePermissions Boolean True if the folder is configured to use permissions.
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.

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