Why is the MARKETING_EMAIL_CONTACT or MARKETING_EMAIL_CONTACT_LIST Table Missing From the Connector Schema?

Question

Why is the MARKETING_EMAIL_CONTACT or MARKETING_EMAIL_CONTACT_LIST table missing from the connector schema, even though the MARKETING_EMAIL table contains data?

Environment

Connector: HubSpot

Answer

We populate the MARKETING_EMAIL table with the data we retrieve from the get all marketing emails endpoint from HubSpot's Marketing Email API. In the response, if the vidsIncluded field has a value, we create a MARKETING_EMAIL_CONTACT table. Similarly, if the mailingListsIncluded field in the reponse has a value, we create a MARKETING_EMAIL_CONTACT_LIST table.

However, we don't support creating empty tables for the HubSpot connector. As a result, if either the vidsIncluded or mailingListsIncluded field is empty, we don't create the associated table.