Bulk upsert members from CSV
Subscribes or unsubscribes members from a CSV file using UPSERT INTO ListMembers SOURCE('ODBC', ...) with the ZappySys CSV Driver. Map CSV columns to ListMembers input columns (e.g. col1 as EmailAddress, col2 as FirstName, col3 as Status). Pass ListId in the WITH clause.
UPSERT INTO ListMembers
SOURCE('ODBC', 'Driver={ZappySys CSV Driver};DataPath=c:\subscribers.csv'
,'select col1 as EmailAddress,col2 as FirstName, col3 as Status from $') --//column name alias must match with InputColumns of ListMembers
WITH(ListId='a4d24015f8')