Folders
Create, update, delete, and query Folders for a Marketo organization.
Table Specific Information
Select
Note: All filterable columns must be specified using the '=' operator.
Retrieve all folders within two levels of the folder hierarchy.
SELECT * FROM Folders
Retrieve all folders under a specific root folder.
SELECT * FROM Folders WHERE RootFolderId=38 AND MaxDepth=5
Insert
To create a new Folder, specify at least the Name, ParentId and ParentType column.
INSERT INTO Folders(Name,ParentId,ParentType) Values('New_Folder_Marketo_CData_Driver', 38, 'Folder')
Update
Any field that is not read-only can be updated.
Update Folders Set Description='Updated Folder', IsArchive=true WHERE Id=1996
Delete
To delete a folder you must specify the ID field. Deletions can be made against single folders if they are empty, meaning that they contain no assets or subfolders. If a folder is of type Program, or has the isSystem field set to true, it cannot be deleted.
DELETE FROM Folders WHERE Id=1996
Columns
| Name | Type | ReadOnly | Filterable | Description |
| Id [KEY] | Integer | True | True |
The unique, Marketo-assigned identifier of the folder. |
| Name | String | False | True |
The name of the folder. |
| Description | String | False |
The description of the folder. | |
| Type | String | True |
The type of the folder. | |
| CreatedAt | Datetime | True |
The date and time the folder was created. | |
| UpdatedAt | Datetime | True |
The date and time the folder was last updated. | |
| ParentId | Integer | False |
The Id of the parent folder. | |
| ParentType | String | False |
The type of the parent folder. | |
| Path | String | True |
The path of a folder shows its hierarchy in the folder tree, similar to a Unix-style path. | |
| WorkSpace | String | True | True |
The name of the smart campaign workspace. |
| URL | String | True |
The explicit URL of the asset in the designated instance. | |
| IsSystem | Boolean | True |
Whether or not the folder is a system folder. | |
| IsArchive | Boolean | False |
Whether or not the folder is archived. | |
| AccessZoneId | Integer | True |
The access zone id |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| RootFolderId | Integer |
The parent folder ID under which the query will be performed. |
| RootFolderType | String |
The parent folder type under which the query will be performed. The allowed values are Folder, Program. The default value is Folder. |
| MaxDepth | Integer |
Maximum folder depth to traverse. The default value is 2. |