CampaignVariateContents
Get the the HTML and plain-text content for a campaign.
Table Specific Information
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
The CamapignId can be retrieved by selecting the Campaigns table.
- CamapaignId supports the '=' operator.
SELECT * FROM CampaignVariateContents; SELECT * FROM CampaignVariateContents where CampaignId='381b6f0c90';
Columns
| Name | Type | Description |
| CampaignId | String | The unique id for the campaign. |
| ContentLabel | String | Label used to identify the content option. |
| PlainText | String | The plain-text portion of the campaign. If left unspecified, we'll generate this automatically. |
| Html | String | The raw HTML for the campaign. |