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

Examples

SSIS

Use Mailchimp Connector in API Source component to read data or in API Destination component to read/write data:

Get a Specific Member From All Lists using API Source

Mailchimp

Get a Specific Member From All Lists

SSIS API Source - Read from table or endpoint

Get a Specific Member From All Lists using API Destination

Mailchimp

Get a Specific Member From All Lists