Read a list member by email

Gets a single member by email address. Pass ListId and Id (email) in the WITH clause.

SELECT * FROM ListMembers 
WITH (ListId='e246f7e24d', Id='test@abc.com')