EndPoint Add New List Members in Bulk

Contents

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

Name

add_list_members_bulk

Description

Adds multiple members using Bulk API. [API reference]

Parameters

Parameter

Label

Required

Options

Description

ListId

List Id

YES

The ID of the list for which you like to perform this operation.

SkipMergeValidation

Skip Merge Validation

Option	Value
true	true
false	false

If skip_merge_validation is true, member data will be accepted without merge field values, even if the merge field is usually required. This defaults to false.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(100)`	100	False
Email	`DT_WSTR`	`nvarchar(255)`	255	False
StatusCode	`DT_I4`	`int`		False
OperationId	`DT_WSTR`	`nvarchar(255)`	255	False
ErrorTitle	`DT_WSTR`	`nvarchar(4000)`	4000	False
ErrorDetail	`DT_WSTR`	`nvarchar(4000)`	4000	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
EmailAddress	`DT_WSTR`	`nvarchar(200)`	200	False
Status	`DT_WSTR`	`nvarchar(80)`	80	False	Subscriber's current status. Possible values: subscribed, unsubscribed, cleaned, pending, or transactional.
EmailType	`DT_WSTR`	`nvarchar(20)`	20	False	Type of email this member asked to get ('html' or 'text').
FirstName	`DT_WSTR`	`nvarchar(255)`	255	False
LastName	`DT_WSTR`	`nvarchar(255)`	255	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
MergeFields	`DT_WSTR`	`nvarchar(4000)`	4000	True	A dictionary of merge fields where the keys are the merge tags.
Interests	`DT_WSTR`	`nvarchar(4000)`	4000	True	The key of this object's properties is the ID of the interest in question.
Language	`DT_WSTR`	`nvarchar(10)`	10	False	If set/detected, the subscriber's language.
Vip	`DT_BOOL`	`bit`		False	VIP status for subscriber.
Latitude	`DT_WSTR`	`nvarchar(4000)`	4000	False	The location latitude.
Longitude	`DT_WSTR`	`nvarchar(4000)`	4000	False	The location longitude.
MarketingPermissions	`DT_WSTR`	`nvarchar(4000)`	4000	True	The marketing permissions for the subscriber.
IpSignup	`DT_WSTR`	`nvarchar(200)`	200	False	IP address the subscriber signed up from.
TimestampSignup	`DT_DBTIMESTAMP`	`datetime`		False	The date and time the subscriber signed up for the list in ISO 8601 format.
IpOpt	`DT_WSTR`	`nvarchar(200)`	200	False	The IP address the subscriber used to confirm their opt-in status.
TimestampOpt	`DT_DBTIMESTAMP`	`datetime`		False	The date and time the subscriber confirmed their opt-in status in ISO 8601 format.
Tags	`DT_WSTR`	`nvarchar(4000)`	4000	True	The tags that are associated with a member.

Required columns that you need to supply are bolded.