ConnectedSites
Get all connected sites in an account.
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 for the site. |
| StoreId | String | The unique identifier for the ecommerce store that's associated with the connected site (if any). The store_id for a specific connected site can't change. |
| Platform | String | The platform of the connected site. |
| Domain | String | The connected site domain. |
| CreatedAt | Datetime | The date and time the connected site was created in ISO 8601 format. |
| UpdatedAt | Datetime | The date and time the connected site was last updated in ISO 8601 format. |
| SiteScriptUrl | String | The URL used for any integrations that offer built-in support for connected sites. |
| SiteScriptFragment | String | A pre-built script that you can copy-and-paste into your site to integrate it with Mailchimp. |
| Links | String | A list of link types and descriptions for the API schema documents. |