Table ListMembersBulk
Description
This table uses BULK API to create / update contacts in bulk. In this table add operation is slightly faster compared to ListMembers table. Use this endpoint if you have real need to speed up and you dont need some information returned by ListMembers operation.
Parameters
Parameter | Label | Required | Options | Description | Help | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no parameters |
Supported Operations
Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.Method | Supported | Reference EndPoint |
---|---|---|
SELECT | get_list_members_all | |
INSERT | add_list_members_bulk | |
UPDATE | update_list_member | |
UPSERT | upsert_list_members | |
DELETE | delete_list_member | |
LOOKUP | get_list_member |
Examples
SSIS
Use Mailchimp Connector in API Source component to read data or in API Destination component to read/write data:
Read from ListMembersBulk table using API Source
Mailchimp
ListMembersBulk

Read/write to ListMembersBulk table using API Destination
Mailchimp
ListMembersBulk
Select

ODBC application
Use these SQL queries in your ODBC application data source:
Bulk Add Subscibers (members) to the List from Source like MSSQL, ODBC
INSERT INTO ListMembersBulk
SOURCE('ODBC', 'DSN=MyOdbcDsn
,'select col1 as EmailAddress,col2 as FirstName, col3 as Status') --//column name alias must match with InputColumns of ListMembers
WITH(ListId='a4d24015f8')
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Bulk Add Subscibers (members) to the List from Source like MSSQL, ODBC
DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO ListMembersBulk
SOURCE(''ODBC'', ''DSN=MyOdbcDsn
,''select col1 as EmailAddress,col2 as FirstName, col3 as Status'') --//column name alias must match with InputColumns of ListMembers
WITH(ListId=''a4d24015f8'')';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_MAILCHIMP_IN_DATA_GATEWAY];