CampaignContents
Retrieves the HTML and plain-text content associated with a specific 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 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. |