Power BI Connector for Mailchimp

Build 24.0.9062

EcommerceStores

A list of an account's ecommerce stores.

Table Specific Information

Select

  • Id supports the '=' operator.
For example:
SELECT * FROM EcommerceStores WHERE  Id = '44'

Columns

Name Type Description
Id [KEY] String The unique identifier for the store.
ListId [KEY] String The unique identifier for the MailChimp list that's associated with the store. The list_id for a specific store can't change.
Name String The name of the store.
Platform String The ecommerce platform of the store.
Domain String The store domain.
EmailAddress String The email address for the store.
CurrencyCode String The three-letter ISO 4217 code for the currency that the store accepts.
MoneyFormat String The currency format for the store. For example: `$`, etc.
PrimaryLocale String The primary locale for the store. For example: `en`, `de`, etc.
Timezone String The timezone for the store.
Phone String The store phone number.
Address_Address1 String The store's mailing address.
Address_Address2 String An additional field for the store's mailing address.
Address_City String The city the store is located in.
Address_Province String The store's state name or normalized province.
Address_ProvinceCode String The two-letter code for the store's province or state.
Address_PostalCode String The store's postal or zip code.
Address_Country String The store's country.
Address_CountryCode String The two-letter code for to the store's country.
Address_Longitude Double The longitude of the store location.
Address_Latitude Double The latitude of the store location.
CreatedAt Datetime The date and time the store was created.
UpdatedAt Datetime The date and time the store was last updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062