Table Lists
Description
No description available
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

Read/write to Lists table using API Destination
Mailchimp
Lists
Select

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];