Query relations of static lists and leads in Marketo.

Select

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

	SELECT * FROM StaticListMembership WHERE ListId='1014'
	SELECT * FROM StaticListMembership WHERE LeadId='4'

	SELECT * FROM StaticListMembership WHERE ListId IN (1014, 1044, 1057)
	SELECT * FROM StaticListMembership WHERE LeadId IN (4, 9999, 1199433)
	SELECT * FROM StaticListMembership WHERE ListId=1014 AND LeadId=1199433
	SELECT * FROM StaticListMembership WHERE ListId=1014 AND LeadId IN (4, 9999, 1199433, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)

Insert

This table supports BATCH INSERT when UseBulkAPI is set to false.

	INSERT INTO StaticListMemberShip (ListId, LeadId) VALUES (1014, 4)
	INSERT INTO StaticListMemberShip (ListId, LeadId) VALUES (1014, 4), (1014, 8), (1014, 12), (1014, 21)
	INSERT INTO StaticListMemberShip (ListId, LeadId) VALUES (1014, 4), (1014, 8), (1014, 12), (1014, 21), (1349, 4), (1349, 8), (1062, 8), (1349, 21), (1349, 22)

Delete

This table supports BATCH DELETE when UseBulkAPI is set to false.

	DELETE FROM StaticListMembership WHERE ListId=1057 AND LeadId=1083278
	DELETE FROM StaticListMembership WHERE ListId=1057 AND LeadId IN (1083292, 1083293, 1199432)
	DELETE FROM StaticListMembership WHERE ListId=1057
	DELETE FROM StaticListMembership WHERE LeadId=9999
	DELETE FROM StaticListMembership WHERE ListId IN (1057, 1568) AND LeadId IN (1083292, 1083293, 1199432, 1199433, 2521698)
	DELETE FROM StaticListMembership WHERE LeadId IN (1083292, 1083293, 1199432, 1199433, 2521698, 4, 5, 6, 7, 8, 9, 10)

Columns