Mailchimp Connector
Documentation
Version: 1
Documentation

Table Lists


Parameters

Parameter Label Required Options Description Help
There are no parameters

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_lists
INSERT add_list
UPDATE update_list
UPSERT
DELETE delete_list
LOOKUP get_list

Examples

SSIS

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

Read from Lists table using API Source

Mailchimp
Lists
SSIS API Source - Read from table or endpoint

Read/write to Lists table using API Destination

Mailchimp
Lists
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get list of lists/audiences in your Mailchimp account.

SELECT * FROM Lists

Get specific columns in list of lists/audiences in your Mailchimp account.

SELECT Id, WebId, Name, Company, Address1, Address2, City, State, Zip, Country, Phone, PermissionReminder, UseArchiveBar, CampaignDefaultFromName, CampaignDefaultFromEmail, CampaignDefaultSubject, CampaignDefaultLanguage, NotifyOnSubscribe, NotifyOnUnsubscribe, DateCreated, ListRating, EmailTypeOption, SubscribeUrlShort, SubscribeUrlLong, BeamerAddress, Visibility, DoubleOptin, HasWelcome, MarketingPermissions, Modules, MemberCount, UnsubscribeCount, CleanedCount, MemberCountSinceSend, UnsubscribeCountSinceSend, CleanedCountSinceSend, CampaignCount, CampaignLastSent, MergeFieldCount, AvgSubRate, AvgUnsubRate, TargetSubRate, OpenRate, ClickRate, LastSubDate, LastUnsubDate 
FROM Lists

Get details of a list/audience in your Mailchimp account.

SELECT * FROM Lists 
WHERE Id='e246f7e24d'

Delete a list from Mailchimp account.

DELETE FROM Lists 
WHERE Id='e246f7e24d'

Create a new list/audience in your Mailchimp account

INSERT INTO Lists
(Name, Company, Address1, Address2, City, State, Zip, Country, Phone, PermissionReminder, UseArchiveBar, CampaignDefaultFromName, CampaignDefaultFromEmail, CampaignDefaultSubject, CampaignDefaultLanguage, NotifyOnSubscribe, NotifyOnUnsubscribe, EmailTypeOption, DoubleOptIn, MarketingPermissions)
VALUES
('The Awesome List', 'My Company Name', '123 Morgan Falls Lane', 'Suite 250','Albany', 'GA', '30114', 'US', '(770) 555-1234', 'Thank you for signing up for these notification emails!', 'false', 'Sales Team', 'salesteam@mycompany.com', 'The best deals are here!', 'en', 'salesteam@mycompany.com', 'salesteam@mycompany.com', 'true', 'false', 'true')

Update details of a list/audience in your Mailchimp account (Update Mail Footer Address for SPAM compliance)

UPDATE Lists SET Address1='123 Main Street', Address2 = 'Suite 52',  City = 'Chicago'
WHERE Id='e246f7e24d'

SQL Server

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

Get list of lists/audiences in your Mailchimp account.

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Lists';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];

Get specific columns in list of lists/audiences in your Mailchimp account.

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, WebId, Name, Company, Address1, Address2, City, State, Zip, Country, Phone, PermissionReminder, UseArchiveBar, CampaignDefaultFromName, CampaignDefaultFromEmail, CampaignDefaultSubject, CampaignDefaultLanguage, NotifyOnSubscribe, NotifyOnUnsubscribe, DateCreated, ListRating, EmailTypeOption, SubscribeUrlShort, SubscribeUrlLong, BeamerAddress, Visibility, DoubleOptin, HasWelcome, MarketingPermissions, Modules, MemberCount, UnsubscribeCount, CleanedCount, MemberCountSinceSend, UnsubscribeCountSinceSend, CleanedCountSinceSend, CampaignCount, CampaignLastSent, MergeFieldCount, AvgSubRate, AvgUnsubRate, TargetSubRate, OpenRate, ClickRate, LastSubDate, LastUnsubDate 
FROM Lists';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];

Get details of a list/audience in your Mailchimp account.

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

EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];

Delete a list from Mailchimp account.

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

EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];

Create a new list/audience in your Mailchimp account

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Lists
(Name, Company, Address1, Address2, City, State, Zip, Country, Phone, PermissionReminder, UseArchiveBar, CampaignDefaultFromName, CampaignDefaultFromEmail, CampaignDefaultSubject, CampaignDefaultLanguage, NotifyOnSubscribe, NotifyOnUnsubscribe, EmailTypeOption, DoubleOptIn, MarketingPermissions)
VALUES
(''The Awesome List'', ''My Company Name'', ''123 Morgan Falls Lane'', ''Suite 250'',''Albany'', ''GA'', ''30114'', ''US'', ''(770) 555-1234'', ''Thank you for signing up for these notification emails!'', ''false'', ''Sales Team'', ''salesteam@mycompany.com'', ''The best deals are here!'', ''en'', ''salesteam@mycompany.com'', ''salesteam@mycompany.com'', ''true'', ''false'', ''true'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];

Update details of a list/audience in your Mailchimp account (Update Mail Footer Address for SPAM compliance)

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Lists SET Address1=''123 Main Street'', Address2 = ''Suite 52'',  City = ''Chicago''
WHERE Id=''e246f7e24d''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];