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 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. |
| DownloadAccountExports | Downloads an account export file by export Id. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with MailChimp. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL used for authentication with MailChimp. |
| PublishLandingPage | Publishes a landing page that is in draft, unpublished, or has been previously published and edited. |
| 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. |
| UnpublishLandingPage | Unpublishes a landing page that is in draft or has been published. |
| UpdateECommerceCarts | Updates an existing e-commerce cart record. To modify individual line items, use the ECommerceCartLines table. |
| VerifyConnectedSiteScript | Verifies that the connected sites script has been installed, either via the script URL or fragment. |
| ViewTemplatesDefaultContent | Retrieves editable sections and default content for a specific email template. |