ConnectedSites
Lists websites connected to the Mailchimp account for tracking and automation purposes.
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| Id | = |
SELECT * FROM ConnectedSites
SELECT * FROM ConnectedSites WHERE Id = '03008bc4e0f0'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier assigned to the connected site within the Mailchimp account. | |
| StoreId | String | The unique identifier of the e-commerce store linked to the connected site, if applicable. This value remains constant and cannot be changed. | |
| Platform | String | The platform or content management system used by the connected site, such as Shopify, WordPress, or custom integrations. | |
| Domain | String | The primary domain name of the connected site. | |
| CreatedAt | Datetime | The date and time when the connected site was initially registered with Mailchimp, in ISO 8601 format. | |
| UpdatedAt | Datetime | The date and time when the connected site details were last modified, in ISO 8601 format. | |
| SiteScriptUrl | String | The URL for integration scripts used by platforms that provide built-in Mailchimp connected site support. | |
| SiteScriptFragment | String | A JavaScript snippet that can be manually embedded into a website to establish a connection with Mailchimp. | |
| Links | String | A collection of related API links and references for the connected site resource. |