SmartLists
Query and delete SmartLists for a Marketo organization.
Table Specific Information
Select
Note: All filterable columns must be specified using the '=' operator.
Retrieve all smart lists
SELECT * FROM SmartLists
Retrieve a specific smart list
SELECT * FROM SmartLists WHERE Id = 1142
Delete
To delete a smart list you can specify the ID or Name field.
DELETE FROM SmartLists WHERE Id = 1142
DELETE FROM SmartLists WHERE Name in ('Test1', 'Test2')
Columns
| Name | Type | ReadOnly | Filterable | Description |
| Id [KEY] | Integer | True | True |
The Id of the smart list. |
| Name | String | True | True |
The name of the smart list. |
| CreatedAt | Datetime | True |
The date and time the smart list was created. | |
| Description | String | True |
The description of the Smart list | |
| UpdatedAt | Datetime | True |
The date and time the smart list was last updated. | |
| WorkSpace | String | True |
The name of the workspace where the smart list is located. | |
| Url | String | True |
The url of the smart list. | |
| FolderId | Integer | False |
The Id of the folder. | |
| FolderType | String | False |
The type of folder. The allowed values are Folder, Program. |
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 |
| EarliestUpdatedAt | Datetime |
Exclude smart list prior to this date. |
| LatestUpdatedAt | Datetime |
Exclude smart list after this date. |
| Folder | String |
JSON representation of parent folder, with members 'id', and 'type' which may be 'Folder' or 'Program'. |
| SmartCampaignId | Integer |
The Id of the smart campaign |
| ProgramId | Integer |
The Id of the Program |