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 can specify the ID or Name 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
DELETE FROM Folders WHERE Name in ('Marketo1','Marketo2')
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. |