Tables
The connector models the data in Mailchimp as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Mailchimp Tables
| Name | Description |
| CampaignFeedback | A summary of the comment feedback for a specific campaign. |
| CampaignFolders | Folders for organizing campaigns |
| Campaigns | A summary of the campaigns within an account. |
| EcommerceCartLines | A list of an ecommerce cart's lines. |
| EcommerceCarts | A list of an account's ecommerce carts. |
| EcommerceCustomers | A list of an account's ecommerce customers. |
| EcommerceOrderLines | A list of an ecommerce order's lines. |
| EcommerceOrders | A list of an account's ecommerce orders. |
| EcommerceProducts | A list of an account's ecommerce products. |
| EcommerceProductVariants | A list of an ecommerce product's variants. |
| FileManagerFiles | A listing of all avaialable images and files within an account's gallery. |
| FileManagerFolders | A listing of all avaialable folders within an account's gallery. |
| ListInterestCategories | A listing of this list's interest categories. |
| ListInterests | A list of this category's interests |
| ListMemberEvents | Events information for a specific list. |
| ListMemberNotes | The last 10 notes for a specific list member, based on date created. |
| ListMembers | Individuals who are currently or have been previously suscribed to this list, including members who have bounced or unsubscribed. |
| ListMergeFields | The merge field (formerly merge vars) for a given list. These correspond to merge fields in MailChimp's lists and subscriber profiles. |
| Lists | A collection of subscriber lists associated with this account. Lists contain subscribers who have opted-in to receive correspondence from you or your organization. |
| ListSegmentMembers | Individuals who are currently or have been previously suscribed to this list, including members who have bounced or unsubscribed. |
| ListSegments | A list of available segments. |
| ListsWebhooks | Webhooks configured for the given list. |
| TemplateFolders | Folders for organizing templates |
| Templates | A list an account's available templates. |