StaticLists
Create, update, delete and query Static Lists for a Marketo organization.
Table Specific Information
Select
Note: All filterable columns must be specified using the '=' operator.
Retrieve a list of Static List from the target instance, filterable by name.
SELECT * FROM StaticLists WHERE Name = 'test0319'
Retrieve the Static List record for the given target Id.
SELECT * FROM StaticLists WHERE Id = 1192
Retrieve the Static List record for the given folder.
SELECT * FROM StaticLists WHERE Folder = '{id:12,type:Folder}'
Insert
To create a new Static List, specify at least the FolderId, FolderType, Name and FolderName column.
INSERT INTO StaticLists (FolderId, FolderType, Name, FolderName) VALUES (12, 'folder', 'testvs', 'ManualList')
Update
Any field that is not read-only can be updated.
UPDATE StaticLists SET Name = 'testupdate' WHERE Id = 1058
Delete
To delete a Email you can specify the ID or Name field.
DELETE FROM StaticLists WHERE Id = 1058
DELETE FROM StaticLists WHERE Name in ('Test1', 'Test2')
Columns
| Name | Type | ReadOnly | Filterable | Description |
| Id [KEY] | Integer | True | True |
Id of the static list. |
| Name | String | False | True |
Name of the static list. |
| CreatedAt | Datetime | True |
Datetime the static list was created. | |
| UpdatedAt | Datetime | True |
Datetime the static list was most recently updated. | |
| FolderId | Integer | False |
Id of the folder. | |
| FolderType | String | False |
Type of folder. | |
| FolderName | String | False |
Type of folder. | |
| ComputedUrl | String | False |
Computed urls of static list. | |
| Workspace | String | False |
Workspace of static list. |
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 |
| Folder | String |
The folder parameter can be used to specify the parent folder under which the query will be performed |