Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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. |