ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Mailchimp の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMailchimp から関連するレスポンスデータを返します。
CData Excel Add-In for Mailchimp ストアドプロシージャ
| 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 a file. |
| 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. |