ConstantContact Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
ConstantContact Tables
| Name | Description |
| AccountEmailAddresses | Returns a collection of email addresses for the account associated with your access token. |
| AccountPhysicalAddress | Returns the address where the account's organization physically resides. |
| AccountSummary | Returns a summary of account details. |
| Activities | Returns a collection of activities. |
| ContactActivityDetails | Gets the tracking activity data for a given account and contact. |
| ContactActivitySummary | Get a list of the recent emails (aka, campaign activities) sent to a specific contact and a summary of the actions the contact took on that email for the most recent 200 campaigns. |
| ContactLists | Returns all contact lists in the user's account. |
| Contacts | Returns a collection of contacts. |
| EmailBouncesReport | Returns a report listing contact bounce data for the specified email campaign activity. |
| EmailCampaign | Returns details about a single email campaign and campaign related activities. |
| EmailCampaignActivity | Returns a specific email campaign activity. |
| EmailCampaignActivitySchedule | Returns the send history of an email campaign activity. |
| EmailCampaignActivitySendHistory | Returns the send history of an email campaign activity. |
| EmailCampaigns | Returns details about your email campaigns. |
| EmailClicksReport | Returns each time a contact clicked a link, the click date and time, and the device type they used. |
| EmailDidNotOpensReport | Returns a report listing each contact that was sent, but did not open the specified email campaign activity. |
| EmailForwardsReport | Returns a report listing each time a contact forwarded the email campaign activity using the forwarding link in the email footer. |
| EmailHtmlPreview | Returns the HTML preview of an email campaign activity. |
| EmailLinksReport | Returns the number of unique contacts that clicked each link in an email campaign activity and the type of action associated with clicking each link |
| EmailOpensReport | Returns a contact opened a specific email campaign activity. |
| EmailOptOutsReport | Returns a report listing each contact that clicked the unsubscribe link in the email campaign activity to opt-out from receiving emails sent from your Constant Contact account |
| EmailSendsReport | Returns each contact that was sent a specific email campaign activity. |
| EmailUniqueOpensReport | Returns a unique opens report that provides details about the last time that each contact opened the specified email campaign activity. |
| OpenAndClickRates | Gets the average open and click rate for a given account and contact. |
| UserPrivileges | Returns the user privileges associated with your access token. |