Reference

Endpoint Get a Specific Member From All Lists

Name

get_list_member_all

Description

Get information about all members in all lists. [API reference]

Parameters

Parameter Required Options
Name: MemberId

Label: Member Id

The ID of the member for which to get details. 		YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(200) 200
ListId DT_WSTR nvarchar(200) 200
EmailAddress DT_WSTR nvarchar(200) 200
UniqueEmailId DT_WSTR nvarchar(200) 200
ContactId DT_WSTR nvarchar(200) 200
FullName DT_WSTR nvarchar(100) 100
WebId DT_I4 int
EmailType DT_WSTR nvarchar(20) 20
Status DT_WSTR nvarchar(20) 20
ConsentsToOneToOneMessaging DT_BOOL bit
FirstName DT_WSTR nvarchar(50) 50
LastName DT_WSTR nvarchar(50) 50
AddressLine1 DT_WSTR nvarchar(200) 200
AddressLine2 DT_WSTR nvarchar(200) 200
City DT_WSTR nvarchar(200) 200
State DT_WSTR nvarchar(100) 100
Zip DT_WSTR nvarchar(20) 20
Country DT_WSTR nvarchar(100) 100
Phone DT_WSTR nvarchar(50) 50
Birthday DT_WSTR nvarchar(50) 50
StatsAvgOpenRate DT_I4 int
StatsAvgClickRate DT_I4 int
IpSignup DT_WSTR nvarchar(200) 200
TimestampSignup DT_DBTIMESTAMP datetime
IpOpt DT_WSTR nvarchar(200) 200
TimestampOpt DT_DBTIMESTAMP datetime
MemberRating DT_I4 int
LastChanged DT_DBTIMESTAMP datetime
Language DT_WSTR nvarchar(100) 100
Vip DT_BOOL bit
EmailClient DT_WSTR nvarchar(200) 200
Latitude DT_I4 int
Longitude DT_I4 int
LocationGmtOff DT_I4 int
LocationDstOff DT_I4 int
CountryCode DT_WSTR nvarchar(100) 100
TimeZone DT_WSTR nvarchar(100) 100
Region DT_WSTR nvarchar(100) 100
Source DT_WSTR nvarchar(100) 100
TagsCount DT_I4 int
Tags DT_WSTR nvarchar(4000) 4000
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

API Source - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Get a Specific Member From All Lists
Required Parameters
Member Id Fill-in the parameter...
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
Get a Specific Member From All Lists
Required Parameters
Member Id Fill-in the parameter...
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get a specific member from all lists 

SELECT * FROM get_list_member_all
WHERE Id = 'abcd-1234-memberid'

SQL Server

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

Get a specific member from all lists 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_list_member_all
WHERE Id = ''abcd-1234-memberid''';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];