MailChimp - Visible Tables
Posted: Sun 18 Apr 2021 19:08
We are using your dotNet MailChimp connector and are very pleased with the quality of the project. In the same projects we also use the Salesforce connector.
However, could you help us understand one discrepancy.
When we read the available tables for MailChimp using either direct queries to SYS_TABLES or via your GetSchema function, we get back 24 tables. However, when we add the MailChimp data connections to Visual Studio, it shows 40 tables. It also appears to be able to query these tables.
As an experiment, we hard coded all 40 tables and attempted to perform a 1 record query. The queries to the additional tables failed. Just for clarity, at this point all of the MailChimp tables do not have any data yet.
Naturally the more tables that we can interact with the better.
However, could you help us understand one discrepancy.
When we read the available tables for MailChimp using either direct queries to SYS_TABLES or via your GetSchema function, we get back 24 tables. However, when we add the MailChimp data connections to Visual Studio, it shows 40 tables. It also appears to be able to query these tables.
As an experiment, we hard coded all 40 tables and attempted to perform a 1 record query. The queries to the additional tables failed. Just for clarity, at this point all of the MailChimp tables do not have any data yet.
Naturally the more tables that we can interact with the better.