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