ODBC guide

Delete list member (archive)


Archives a list member by ID using DELETE FROM ListMembers WHERE Id='...' WITH (ListId='...'). Archived or bounced records cannot be resubscribed; to resubscribe, use the permanent delete operation first to remove the member permanently.

DELETE FROM ListMembers 
WHERE Id='170a0722daae03855d6434eb3a5959fb' 
WITH (ListId='e246f7e24d')