Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver 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 ODBC Driver 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.
CampaignReplicate	Replicate a campaign in saved or send status.
CampaignResend	Remove the guesswork for resending a campaign to certain segments.
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.
CancelBatchRequest	Stops a batch request from running. Since only one batch request is run at a time, this can be used to cancel a long running request. The results of any completed operations will not be available after this call.
CancelSMSCampaignSend	Cancel a scheduled or sending SMS campaign.
CreateAccountExport	Creates a new account export in your Mailchimp account.
CreateSurveyCampaign	Utilize the List ID and Survey ID to generate a Campaign that links to your survey.
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.
PublishSurvey	Publish a survey 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.
ScheduleSMSCampaign	Schedule an SMS campaign to send at a specific time.
SendSMSCampaign	Send an SMS campaign.
TriggerCustomerJourneys	A step trigger in an Automation flow. To use it, create a starting point or step from the Automation flow builder in the app using the Customer Journey API condition.
UnpublishLandingPage	Unpublishes a landing page that is in draft or has been published.
UnpublishSurvey	Unpublish a survey that has been published.
UpdateCampaignContent	Sets the HTML and plain-text content for a Mailchimp campaign.
UpdateECommerceCarts	Updates the ECommerceCart. To update lines in ECommerceCarts, please use UPDATE in ECommerceCartLines table.
VerifyConnectedSiteScript	Verifies that the connected sites script has been installed, either via the script URL or fragment.
VerifyDomain	Verify a domain for sending.
ViewTemplatesDefaultContent	Retrieves editable sections and default content for a specific email template.