CampaignContents
Get the the HTML and plain-text content for a campaign.
Table Specific Information
Select
The connector 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 connector.
The CamapignId can be retrieved by selecting the Campaigns table.
- CamapaignId supports the '=' operator.
SELECT * FROM CampaignContents; SELECT * FROM CampaignContents where CampaignId='381b6f0c90';
Columns
| Name | Type | Description |
| CampaignId | String | The unique id for the campaign. |
| 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. |
| ArchiveHtml | String | The Archive HTML for the campaign. |