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.
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
API Source - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
ListMembersBulk
| Optional Parameters | |
|---|---|
| Email Type | |
| Status | |
| Since Timestamp Opt (Format: 2015-10-21T15:41:36) | |
| Before Timestamp Opt (Format: 2015-10-21T15:41:36) | |
| Since Last Changed (Format: 2015-10-21T15:41:36) | |
| Before Last Changed (Format: 2015-10-21T15:41:36) | |
| Unique Email Id | |
| VIP Only | |
| Interest Category Id | |
| Interest Ids | |
| Interest Match | |
| Since Last Campaign | |
| Unsubscribed Since (Format: 2015-10-21T15:41:36) | |
Read/write to ListMembersBulk table using API Destination
API Destination - Mailchimp
Read / write MailChimp Campaigns, Lists, Members, Reports and more in without coding.
Mailchimp
ListMembersBulk
Select
| Optional Parameters | |
|---|---|
| Email Type | |
| Status | |
| Since Timestamp Opt (Format: 2015-10-21T15:41:36) | |
| Before Timestamp Opt (Format: 2015-10-21T15:41:36) | |
| Since Last Changed (Format: 2015-10-21T15:41:36) | |
| Before Last Changed (Format: 2015-10-21T15:41:36) | |
| Unique Email Id | |
| VIP Only | |
| Interest Category Id | |
| Interest Ids | |
| Interest Match | |
| Since Last Campaign | |
| Unsubscribed Since (Format: 2015-10-21T15:41:36) | |
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 [LS_TO_MAILCHIMP_IN_GATEWAY];