Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE 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 Excel Add-In for Mailchimp Stored Procedures


Name	Description
AddOrRemoveMemberTags	Adds or removes tags from a list member. If a tag that does not exist is provided and marked as 'active', a new tag is 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.
DeleteECommerceCarts	Deletes the ECommerceCart.
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 sent from that workflow. Once you remove a subscriber, you cannot add them back to the same workflow.
TransactionalCancelScheduledEmail	Cancel a scheduled email.
TransactionalRescheduledEmail	Reschedule a scheduled email.
TransactionalSendMessage	Send a new transactional message through the Transactional API.
TransactionalSendTemplate	Send a new transactional message through the Transactional API using a template.
UpdateECommerceCarts	Update the ECommerceCart. To update lines in ECommerceCarts, use UPDATE in the ECommerceCartLines table.
ViewTemplatesDefaultContent	Get the sections that you can edit in a template, including each section's default content.