Endpoint Delete List Member (Permanent delete)
Name
delete_list_member_permanent
Description
Delete all personally identifiable information related to a list member, and remove them from a list. This will make it impossible to re-import the list member. [API reference]
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: List Id The ID of the list for which you like to perform this operation. |
YES | |
|
Name:
Label: Member Id The ID of the list member for which data should be deleted. |
YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(4000)
|
4000 | |
| Status |
DT_WSTR
|
nvarchar(4000)
|
4000 | |
| StatusCode |
DT_I4
|
int
|
If the column you are looking for is missing, consider customizing Mailchimp Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Mailchimp Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Delete List Member (Permanent delete)
| Required Parameters | |
|---|---|
| List Id | Fill-in the parameter... |
| Member Id | Fill-in the parameter... |
| Optional Parameters | |
| RawOutputDataRowTemplate | {} |
| EnableRawOutputModeSingleRow | True |
| ContineOn404Error | True |
API Destination
API Destination - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Delete List Member (Permanent delete)
| Required Parameters | |
|---|---|
| List Id | Fill-in the parameter... |
| Member Id | Fill-in the parameter... |
| Optional Parameters | |
| RawOutputDataRowTemplate | {} |
| EnableRawOutputModeSingleRow | True |
| ContineOn404Error | True |
ODBC application
Use these SQL queries in your ODBC application data source:
Delete list members permanently from a Mailchimp List which are created after specific date (i.e. after Opt In time)
Delete list member operation archives the record.
select * from delete_list_member_permanent
WITH (ListId='a4d24015f8' , Id='170a0722daae03855d6434eb3a5959fb' )SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Delete list members permanently from a Mailchimp List which are created after specific date (i.e. after Opt In time)
Delete list member operation archives the record.
DECLARE @MyQuery NVARCHAR(MAX) = 'select * from delete_list_member_permanent
WITH (ListId=''a4d24015f8'' , Id=''170a0722daae03855d6434eb3a5959fb'' )';
EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];