StaticLists

Create, update, delete and query Static Lists for a Marketo organization.

Table Specific Information

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}'

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')

Any field that is not read-only can be updated.

UPDATE StaticLists SET Name = 'testupdate' WHERE Id = 1058

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')


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.

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Folder	String	The folder parameter can be used to specify the parent folder under which the query will be performed