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 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 must specify the ID field.
DELETE FROM StaticLists WHERE Id = 1058
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 |