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
Parameters
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 |
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:

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).