ConnectedSites
Lists websites connected to the Mailchimp account for tracking and automation purposes.
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.
- 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. |