Mailchimp Connector
Documentation
Version: 1
Documentation
Endpoint

Get List Member Details


Name

get_list_member

Description

Get information about a specific list member, including a currently subscribed, unsubscribed, or bounced member. [API reference]

Related Tables

ListMembers , ListMembersBulk

Parameters

Parameter Label Required Options Description
ListId List Id YES The ID of the list for which you like to perform this operation.
MemberId Member Id YES The ID of the list member for which data should be read.

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(200) 200 False
ListId DT_WSTR nvarchar(200) 200 False
EmailAddress DT_WSTR nvarchar(200) 200 False
UniqueEmailId DT_WSTR nvarchar(200) 200 False
ContactId DT_WSTR nvarchar(200) 200 False
FullName DT_WSTR nvarchar(100) 100 False
WebId DT_I4 int False
EmailType DT_WSTR nvarchar(20) 20 False
Status DT_WSTR nvarchar(20) 20 False
ConsentsToOneToOneMessaging DT_BOOL bit False
FirstName DT_WSTR nvarchar(50) 50 False
LastName DT_WSTR nvarchar(50) 50 False
AddressLine1 DT_WSTR nvarchar(200) 200 False
AddressLine2 DT_WSTR nvarchar(200) 200 False
City DT_WSTR nvarchar(200) 200 False
State DT_WSTR nvarchar(100) 100 False
Zip DT_WSTR nvarchar(20) 20 False
Country DT_WSTR nvarchar(100) 100 False
Phone DT_WSTR nvarchar(50) 50 False
Birthday DT_WSTR nvarchar(50) 50 False
StatsAvgOpenRate DT_I4 int False
StatsAvgClickRate DT_I4 int False
IpSignup DT_WSTR nvarchar(200) 200 False
TimestampSignup DT_DBTIMESTAMP datetime False
IpOpt DT_WSTR nvarchar(200) 200 False
TimestampOpt DT_DBTIMESTAMP datetime False
MemberRating DT_I4 int False
LastChanged DT_DBTIMESTAMP datetime False
Language DT_WSTR nvarchar(100) 100 False
Vip DT_BOOL bit False
EmailClient DT_WSTR nvarchar(200) 200 False
Latitude DT_I4 int False
Longitude DT_I4 int False
LocationGmtOff DT_I4 int False
LocationDstOff DT_I4 int False
CountryCode DT_WSTR nvarchar(100) 100 False
TimeZone DT_WSTR nvarchar(100) 100 False
Region DT_WSTR nvarchar(100) 100 False
Source DT_WSTR nvarchar(100) 100 False
TagsCount DT_I4 int False
Tags DT_WSTR nvarchar(4000) 4000 False
If the column you are looking for is missing, consider customizing Mailchimp Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw 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 component to read data or in API Destination component to read/write data:

Lookup a row in ListMembers table using API Destination

This Endpoint belongs to ListMembers table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Mailchimp
ListMembers
Lookup
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get list member details

SELECT * FROM get_list_member
WHERE Id = 'abcd-1234-memberid'
WITH
(
    "ListId" = 'abcd-1234-listid'
)

Get a list member by Id from a Mailchimp List

SELECT * FROM ListMembers 
WHERE Id='170a0722daae03855d6434eb3a5959fb' 
WITH (ListId='e246f7e24d')

Get details on a specific member within all lists/audiences in your Mailchimp account

SELECT * FROM ListMembers 
WHERE Id='170a0722daae03855d6434eb3a5959fb'

get_list_member endpoint belongs to ListMembers , ListMembersBulk 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 list member details

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_list_member
WHERE Id = ''abcd-1234-memberid''
WITH
(
    "ListId" = ''abcd-1234-listid''
)';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

Get a list member by Id from a Mailchimp List

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM ListMembers 
WHERE Id=''170a0722daae03855d6434eb3a5959fb'' 
WITH (ListId=''e246f7e24d'')';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

Get details on a specific member within all lists/audiences in your Mailchimp account

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM ListMembers 
WHERE Id=''170a0722daae03855d6434eb3a5959fb''';

EXEC (@MyQuery) AT [LS_TO_MAILCHIMP_IN_GATEWAY];

get_list_member endpoint belongs to ListMembers , ListMembersBulk table(s), and can therefore be used via those table(s).