DataFolder
Represents folders within a Salesforce Marketing Cloud account. Each folder organizes related content, data extensions, or automations into a hierarchical structure for easier management and access control. This view supports navigation and organizational reporting across stored assets.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM DataFolder WHERE Id = 123 SELECT * FROM DataFolder WHERE Id IN (123, 456) SELECT * FROM DataFolder WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Specifies the system-generated identifier (Id) that uniquely identifies the data folder record. This value is read-only and is assigned automatically by the system. |
| Client_ID | Int | Specifies the Id of the client that owns or manages the data folder. This value determines the business context in which the folder exists. |
| ParentFolder_ID | Int | Specifies the Id of the parent data folder that contains this folder. This value establishes the hierarchical structure used to organize folders. |
| ParentFolder_CustomerKey | String | Specifies the user-supplied unique Id that is assigned to the parent folder within its object type. This value is used to reference the parent folder programmatically. |
| ParentFolder_ObjectID | String | Specifies the system-controlled, read-only text string that uniquely identifies the parent folder object. This Id remains consistent across system operations. |
| ParentFolder_Name | String | Specifies the name of the parent data folder. This value helps users understand the folder's placement within the folder hierarchy. |
| ParentFolder_Description | String | Provides descriptive information about the parent data folder. This description helps clarify the folder's purpose, business function, or organizational role. |
| ParentFolder_ContentType | String | Specifies the content type associated with the parent folder, which determines what kinds of assets or objects the folder can contain. |
| ParentFolder_IsActive | Bool | Returns a value of 'true' when the parent data folder is active and available for use. It returns a value of 'false' when the parent data folder is inactive or unavailable for operational tasks. |
| ParentFolder_IsEditable | Bool | Returns a value of 'true' when users can modify properties of the parent folder through the profile center. It returns a value of 'false' when the parent folder's properties are locked and cannot be edited. |
| ParentFolder_AllowChildren | Bool | Returns a value of 'true' when the parent data folder is allowed to contain child folders. It returns a value of 'false' when the parent data folder must remain a leaf folder without subordinate folders. |
| Name | String | Specifies the name of the data folder. The name is used for display, navigation, and organizational purposes across the user interface. |
| Description | String | Provides a human-readable description of the data folder. This description helps users understand the folder's role, purpose, and stored content. |
| ContentType | String | Specifies the content type that is associated with the data folder. The content type determines what types of objects or assets can be stored in this folder. |
| IsActive | Bool | Returns a value of 'true' when the data folder is active and can be accessed or managed. It returns a value of 'false' when the data folder is inactive or restricted by administrative settings. |
| IsEditable | Bool | Returns a value of 'true' when users can modify the data folder's properties through the profile center. It returns a value of 'false' when the folder's properties are fixed and cannot be changed. |
| AllowChildren | Bool | Returns a value of 'true' when the data folder supports the creation of child folders. It returns a value of 'false' when the folder is not permitted to have subordinate folders. |
| CreatedDate | Datetime | Indicates the date and time when the data folder was created. This value is read-only and supports auditing and historical tracking. |
| ModifiedDate | Datetime | Indicates the date and time when the data folder was last modified. This information supports change management and version control. |
| Client_ModifiedBy | Int | Specifies the Id of the user who last modified the data folder. This value supports audit logging and administrative oversight. |
| ObjectID | String | Specifies the system-controlled, read-only text string that uniquely identifies the data folder object. This identifier supports internal system processes and external API references. |
| CustomerKey | String | Specifies the user-supplied unique Id that identifies the data folder within its object type. This value is commonly used for automation, API interactions, and configuration references. |
| Client_EnterpriseID | Long | Specifies the enterprise-level Id that is associated with the client record. |
| Client_CreatedBy | Int | Specifies the Id of the user who created the data folder. This information supports auditing and regulatory compliance. |