EndPoint Add New List Members in Bulk

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.

Examples

SSIS

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

Insert into ListMembersBulk table using API Destination

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

Mailchimp

ListMembersBulk

Insert