ConnectedSites

Get all connected sites in an account.

Table Specific Information

Select

The driver 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 driver.

Id supports the '=' operator.

For example:

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.

JDBC Driver for Mailchimp

ConnectedSites

Table Specific Information

Select

Columns