Bulk upsert members from any ODBC data source
Subscribes or unsubscribes members from any ODBC data source (e.g. DSN) using UPSERT INTO ListMembers SOURCE('ODBC', ...). The inner SELECT column aliases must match ListMembers input columns. Pass ListId in the WITH clause.
UPSERT INTO ListMembers
SOURCE('ODBC', 'DSN=MyOdbcDsn'
,'select col1 as EmailAddress,col2 as FirstName, col3 as Status from sometable') --//column name alias must match with InputColumns of ListMembers
WITH(ListId='a4d24015f8')