EndPoint Get a Specific Member From All Lists

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_list_member_all

Description

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

Parameters

Parameter	Label	Required	Options	Description
MemberId	Member Id	YES		The ID of the member for which to get details.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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.