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	Adds or removes tags from one or more list members. If a tag does not exist and is marked as 'active', Mailchimp automatically creates it.
AddSubscriberToWorkflowEmail	Manually adds a subscriber to an automation workflow, bypassing trigger-based entry conditions.
CampaignCancel	Cancels a scheduled regular or plain-text campaign that has not yet been sent.
CampaignPause	Pauses an active Mailchimp RSS campaign, temporarily stopping further sends.
CampaignResume	Resumes a previously paused Mailchimp RSS campaign.
CampaignSchedule	Schedules a campaign for delivery using either Timewarp or batch scheduling options (not both).
CampaignSend	Immediately sends a Mailchimp campaign to its intended audience.
CampaignTest	Sends a test email version of a campaign to verify design and content before sending.
CampaignUnschedule	Unschedules a previously scheduled campaign, preventing it from being sent.
DeleteECommerceCarts	Deletes an e-commerce cart record from the connected store.
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	Removes a subscriber from a classic automation workflow at any stage, regardless of sent emails. Once removed, the subscriber cannot be re-added to the same workflow.
TransactionalCancelScheduledEmail	Cancels a transactional email that is scheduled for future delivery.
TransactionalRescheduledEmail	Reschedules a transactional email to be sent at a different time.
TransactionalSendMessage	Send a new transactional message through the Transactional API.
TransactionalSendTemplate	Send a new transactional message through the Transactional API using a template.
UpdateECommerceCarts	Updates an existing e-commerce cart record. To modify individual line items, use the ECommerceCartLines table.
ViewTemplatesDefaultContent	Retrieves editable sections and default content for a specific email template.