Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Mailchimp.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Mailchimp, along with an indication of whether the procedure succeeded or failed.

CData Power BI Connector for Mailchimp Stored Procedures


Name	Description
AddOrRemoveMemberTags	Add or remove tags from a list member. If a tag that does not exist is passed in and set as 'active', a new tag will be created.
AddSubscriberToWorkflowEmail	Manually add a subscriber to a workflow, bypassing the default trigger settings.
CampaignCancel	Cancels a MailChimp Regular or Plain-Text campaign .
CampaignPause	Pauses a MailChimp RSS campaign.
CampaignResume	Resumes a MailChimp RSS campaign.
CampaignSchedule	Schedules a MailChimp campaign. Either Timewarp or the batch properties can be used, not both.
CampaignSend	Sends a MailChimp campaign.
CampaignTest	Sends a test email for a MailChimp campaign.
CampaignUnschedule	Unschedules a MailChimp campaign.
GetOAuthAccessToken	Obtains the OAuth access token to be used for authentication with MailChimp.
GetOAuthAuthorizationURL	Obtains the OAuth authorization URL used for authentication with MailChimp.
RemoveSubscriberFromWorkflow	Remove a subscriber from a specific classic automation workflow. You can remove a subscriber at any point in an automation workflow, regardless of how many emails they've been sent from that workflow. Once they're removed, they can never be added back to the same workflow.