Reference

Table Lists

Description

No description available

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

API Source - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Lists
Optional Parameters
Created before (Format: 2015-10-21T15:41:36)
Created after (Format: 2015-10-21T15:41:36)
Created before last campaign send date (Format: 2015-10-21T15:41:36)
Created after last campaign send date (Format: 2015-10-21T15:41:36)
Includes email address
Contains active ecommerce store
SSIS API Source - Read from table or endpoint

Read/write to Lists table using API Destination

API Destination - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Lists
Select
Optional Parameters
Created before (Format: 2015-10-21T15:41:36)
Created after (Format: 2015-10-21T15:41:36)
Created before last campaign send date (Format: 2015-10-21T15:41:36)
Created after last campaign send date (Format: 2015-10-21T15:41:36)
Includes email address
Contains active ecommerce store
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 [LS_TO_MAILCHIMP_IN_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 [LS_TO_MAILCHIMP_IN_GATEWAY];

Get details of a list/audience in your Mailchimp account 

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

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

Delete a list from Mailchimp account 

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

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_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 [LS_TO_MAILCHIMP_IN_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 [LS_TO_MAILCHIMP_IN_GATEWAY];