SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Mailchimp.

• Bulk add members from any ODBC data source
• Bulk upsert members from any ODBC data source
• Bulk upsert members from CSV
• Bulk upsert members from SQL Server
• Create list
• Create list member
• Delete list
• Delete list member (archive)
• Delete list member permanently
• Delete list members (archive) by date
• Read a campaign by ID
• Read a list by ID
• Read a list member by email
• Read a list member by ID
• Read a member by ID across all lists
• Read account details
• Read account details (selected columns)
• Read campaigns
• Read campaigns (selected columns)
• Read lists/audiences
• Read lists/audiences (selected columns)
• Read members across all lists
• Read members in a list
• Read members in a list (selected columns)
• Update list (e.g. footer address for SPAM compliance)
• Update list member