ListStaticMemberShip

Create, delete and query query static list members for a Marketo organization.

Table Specific Information

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of Static MemberShip from the target instance, filterable by Id and ListId.

SELECT * FROM ListStaticMemberShip WHERE ListId = 1014

SELECT * FROM ListStaticMemberShip WHERE ListId = 1014 AND id = 1016

To create a new Static MemberShip, specify at least the ListId and Id column.

INSERT INTO ListStaticMemberShip (ListId, Id) VALUES (1014, 1014)

To delete a ListStaticMemberShip you must specify the ID and ListId field.

DELETE FROM ListStaticMemberShip WHERE Listid = 1014 AND Id = 1014


Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of static MemberShip.
FirstName	String	True		FirtName of the member
LastName	String	True		LastName of the member
Email	String	True		Email
CreatedAt	Datetime	True		The date and time the membership was created.
UpdatedAt	Datetime	True		The date and time the membership was last updated.
ListId	Integer	True	True	ListId.