Mailchimp Connector
Documentation
Version: 1
Documentation

EndPoint Add New List


Name

add_list

Description

Create a new list in your Mailchimp account. [API reference]

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(100) 100 False
WebId DT_I4 int False
Name DT_WSTR nvarchar(100) 100 False
Company DT_WSTR nvarchar(500) 500 False
Address1 DT_WSTR nvarchar(500) 500 False
Address2 DT_WSTR nvarchar(500) 500 False
City DT_WSTR nvarchar(100) 100 False
State DT_WSTR nvarchar(100) 100 False
Zip DT_WSTR nvarchar(100) 100 False
Country DT_WSTR nvarchar(100) 100 False
Phone DT_WSTR nvarchar(100) 100 False
PermissionReminder DT_WSTR nvarchar(4000) 4000 False
UseArchiveBar DT_BOOL bit False
CampaignDefaultFromName DT_WSTR nvarchar(100) 100 False
CampaignDefaultFromEmail DT_WSTR nvarchar(500) 500 False
CampaignDefaultSubject DT_WSTR nvarchar(500) 500 False
CampaignDefaultLanguage DT_WSTR nvarchar(100) 100 False
NotifyOnSubscribe DT_WSTR nvarchar(500) 500 False
NotifyOnUnsubscribe DT_WSTR nvarchar(500) 500 False
DateCreated DT_DBTIMESTAMP datetime False
ListRating DT_I4 int False
EmailTypeOption DT_BOOL bit False
SubscribeUrlShort DT_WSTR nvarchar(512) 512 False
SubscribeUrlLong DT_WSTR nvarchar(1024) 1024 False
BeamerAddress DT_WSTR nvarchar(500) 500 False
Visibility DT_WSTR nvarchar(100) 100 False
DoubleOptin DT_BOOL bit False
HasWelcome DT_BOOL bit False
MarketingPermissions DT_BOOL bit False
Modules DT_WSTR nvarchar(500) 500 False
MemberCount DT_I4 int False
UnsubscribeCount DT_I4 int False
CleanedCount DT_I4 int False
MemberCountSinceSend DT_I4 int False
UnsubscribeCountSinceSend DT_I4 int False
CleanedCountSinceSend DT_I4 int False
CampaignCount DT_I4 int False
CampaignLastSent DT_WSTR nvarchar(500) 500 False
MergeFieldCount DT_I4 int False
AvgSubRate DT_I4 int False
AvgUnsubRate DT_I4 int False
TargetSubRate DT_I4 int False
OpenRate DT_I4 int False
ClickRate DT_I4 int False
LastSubDate DT_DBTIMESTAMP datetime False
LastUnsubDate DT_DBTIMESTAMP datetime False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Name DT_WSTR nvarchar(200) 200 False The name of the list.
Company DT_WSTR nvarchar(200) 200 False The company name for the list.
Address1 DT_WSTR nvarchar(200) 200 False Line 1 of the street address for the list contact.
City DT_WSTR nvarchar(200) 200 False The city for the list contact.
Country DT_WSTR nvarchar(200) 200 False A two-character ISO3166 country code. Defaults to US if invalid.
PermissionReminder DT_WSTR nvarchar(500) 500 False The permission reminder for the list.
CampaignDefaultFromName DT_WSTR nvarchar(200) 200 False The default from name for campaigns sent to this list.
CampaignDefaultFromEmail DT_WSTR nvarchar(200) 200 False The default from email for campaigns sent to this list.
CampaignDefaultSubject DT_WSTR nvarchar(200) 200 False The default subject line for campaigns sent to this list.
CampaignDefaultLanguage DT_WSTR nvarchar(200) 200 False The default language for this lists's forms.
EmailTypeOption DT_WSTR nvarchar(4000) 4000 True Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup.
DoubleOptIn DT_WSTR nvarchar(4000) 4000 True Whether or not to require the subscriber to confirm subscription via email.
Address2 DT_WSTR nvarchar(200) 200 False Line 2 of the street address for the list contact.
State DT_WSTR nvarchar(20) 20 False The state for the list contact.
Zip DT_WSTR nvarchar(20) 20 False The postal or zip code for the list contact.
Phone DT_WSTR nvarchar(30) 30 False The phone number for the list contact.
UseArchiveBar DT_WSTR nvarchar(4000) 4000 True Whether campaigns for this list use the Archive Bar in archives by default.
NotifyOnSubscribe DT_WSTR nvarchar(200) 200 False The email address to send subscribe notifications to.
NotifyOnUnsubscribe DT_WSTR nvarchar(200) 200 False The email address to send unsubscribe notifications to.
MarketingPermissions DT_WSTR nvarchar(4000) 4000 True Whether or not the list has marketing permissions (eg. GDPR) enabled.
Required columns that you need to supply are bolded.