ODBC guide

Bulk add members from any ODBC data source


Adds members in bulk using the ListMembersBulk table (batch API). Use INSERT INTO ListMembersBulk SOURCE('ODBC', ...); the inner SELECT column aliases must match input columns. Slightly faster than ListMembers UPSERT when you do not need per-row response details. Pass ListId in the WITH clause.

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')