Endpoint

Delete List

Name

delete_list

Delete a specific list. [API reference]

Parameter	Label	Required	Options	Description
Id	List Id	YES		The ID of the list which should be deleted.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Status	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
StatusCode	`DT_I4`	`int`		`False`

If the column you are looking for is missing, consider customizing Mailchimp Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

Required columns that you need to supply are bolded.

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

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

Mailchimp

Lists

Delete

Use these SQL queries in your ODBC application data source:

SELECT * FROM delete_list
WHERE Id = 'abcd-1234-id'

DELETE FROM Lists 
WHERE Id='e246f7e24d'

delete_list endpoint belongs to Lists table(s), and can therefore be used via those table(s).

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

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_list
WHERE Id = ''abcd-1234-id''';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Lists 
WHERE Id=''e246f7e24d''';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

delete_list endpoint belongs to Lists table(s), and can therefore be used via those table(s).