ConnectedSites
Lists websites connected to the Mailchimp account for tracking and automation purposes.
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.
- Id supports the '=' operator.
SELECT * FROM ConnectedSites; SELECT * FROM ConnectedSites where Id='03008bc4e0f0';
Columns
| Name | Type | 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. |