Reference

Endpoint Get List Details

Name

get_list

Description

Get information about a specific campaign. [API reference]

Related Tables

Lists

Parameters

Parameter Required Options
Name: Id

Label: List Id

The ID of the list for which data should be read. 		YES

Output Columns

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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Mailchimp Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Lists table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Lists
Required Parameters
List Id Fill-in the parameter...
Optional Parameters
ContineOnErrorForStatusCode True
ErrorStatusCodeToMatchRegex 404|405
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Lists table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get list details:

API Destination - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Lists
Lookup
Required Parameters
List Id Fill-in the parameter...
Optional Parameters
ContineOnErrorForStatusCode True
ErrorStatusCodeToMatchRegex 404|405
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get details of a list/audience in your Mailchimp account 

SELECT * FROM Lists 
WHERE Id='e246f7e24d'

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

SQL Server

Use these SQL queries in SQL Server after you create a data source 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 [LS_TO_MAILCHIMP_IN_GATEWAY];

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