Delete List Member (Archive)

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Mailchimp Connector in API Source component to read data or in API Destination component to read/write data:

Delete rows from ListMembers table using API Destination

This Endpoint belongs to ListMembers table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Mailchimp

ListMembers

Delete

ODBC application

Use these SQL queries in your ODBC application data source:

Delete list member

SELECT * FROM delete_list_member
WHERE Id = 'abcd-1234-id'
WITH
(
    "ListId" = 'abcd-1234-listid'
)

Delete a list member (archive) from a Mailchimp List

Delete List Member by Id and archive it. To delete permanently use delete_list_member_permanent endpoint. Archived / bounced record cannot be resubscribed. To resubscribe you must call delete_list_member_permanent

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

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete list member

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_list_member
WHERE Id = ''abcd-1234-id''
WITH
(
    "ListId" = ''abcd-1234-listid''
)';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

Delete a list member (archive) from a Mailchimp List

Delete List Member by Id and archive it. To delete permanently use delete_list_member_permanent endpoint. Archived / bounced record cannot be resubscribed. To resubscribe you must call delete_list_member_permanent

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM ListMembers 
WHERE Id=''170a0722daae03855d6434eb3a5959fb'' 
WITH (ListId=''e246f7e24d'')';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];