CampaignContents
Retrieves the HTML and plain-text content associated with a specific 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 CampaignContents; SELECT * FROM CampaignContents where CampaignId='381b6f0c90';
Columns
| Name | Type | Description |
| CampaignId | String | The unique identifier of the campaign whose content is being retrieved or updated. |
| PlainText | String | The plain-text version of the campaign email. If not provided, Mailchimp automatically generates it from the HTML content. |
| Html | String | The full HTML content of the campaign, including layout, text, and embedded media. |
| ArchiveHtml | String | The HTML version of the campaign as it appears in the campaign archive view. |