MARKETINGEMAILS
- Last Updated: March 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- HubSpot 8.0
- Documentation
Endpoint
https://api.hubapi.com/marketing-emails/v1/emails
Columns
The MARKETINGEMAILS table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| AB | Boolean |
| ABHOURSTOWAIT | Integer |
| ABSAMPLESIZEDEFAULT | VarChar(64) |
| ABSAMPLINGDEFAULT | VarChar(64) |
| ABSOLUTEURL | VarChar(120) |
| ABSUCCESSMETRIC | VarChar(64) |
| ABTESTPERCENTAGE | Integer |
| ABVARIATION | Boolean |
| ANALYTICSPAGEID | BigInt |
| ANALYTICSPAGETYPE | VarChar(64) |
| ARCHIVED | Boolean |
| AUTHOR | VarChar(64) |
| AUTHORAT | BigInt |
| AUTHORNAME | VarChar(64) |
| CAMPAIGN | GUID |
| CAMPAIGNNAME | VarChar(64) |
| CAMPAIGNUTM | VarChar(64) |
| CANSPAMSETTINGSID | BigInt |
| CATEGORYID | Integer |
| CONTENTTYPECATEGORY | Integer |
| CREATED | Timestamp(3) |
| CREATEDBYID | Integer |
| CREATEPAGE | Boolean |
| CURRENTLYPUBLISHED | Boolean |
| CURRENTSTATE | VarChar(64) |
| CUSTOMREPLYTO | VarChar(64) |
| CUSTOMREPLYTOENABLED | Boolean |
| DOMAIN | VarChar(64) |
| EMAILBODY | VarChar(130) |
| EMAILBODYPLAINTEXT | VarChar(64) |
| EMAILCAMPAIGNGROUPID | Integer |
| EMAILNOTE | VarChar(64) |
| EMAILTYPE | VarChar(64) |
| FEEDBACKSURVEYID | Integer |
| FREEZEDATE | BigInt |
| FROMNAME | VarChar(64) |
| HASCONTENTACCESSRULES | Boolean |
| HTMLTITLE | VarChar(64) |
| ISGRAYMAILSUPPRESSIONENABLED | Boolean |
| ISPUBLISHED | Boolean |
| LANGUAGE | VarChar(64) |
| LIVEDOMAIN | VarChar(64) |
| MAILINGLISTSEXCLUDED | JSON(16777215) |
| MAILINGLISTSINCLUDED | JSON(16777215) |
| MAXRSSENTRIES | Integer |
| METADESCRIPTION | VarChar(64) |
| NAME | VarChar(64) |
| PAGEREDIRECTED | Boolean |
| PORTALID | Integer |
| PREVIEWKEY | VarChar(64) |
| PROCESSINGSTATUS | VarChar(64) |
| PUBLISHDATE | Date |
| PUBLISHEDAT | Timestamp(3) |
| PUBLISHEDBYEMAIL | VarChar(64) |
| PUBLISHEDBYID | Integer |
| PUBLISHEDBYNAME | VarChar(64) |
| PUBLISHEDURL | VarChar(120) |
| PUBLISHIMMEDIATELY | Boolean |
| REPLYTO | VarChar(64) |
| RESOLVEDDOMAIN | VarChar(64) |
| RSSEMAILBYTEXT | VarChar(64) |
| RSSEMAILCLICKTHROUGHTEXT | VarChar(64) |
| RSSEMAILCOMMENTTEXT | VarChar(64) |
| RSSEMAILENTRYTEMPLATEENABLED | Boolean |
| RSSEMAILURL | VarChar(64) |
| SLUG | VarChar(78) |
| SUBCATEGORY | VarChar(64) |
| SUBJECT | VarChar(64) |
| SUBSCRIPTION | Integer |
| SUBSCRIPTIONNAME | VarChar(64) |
| TEAMPERMS | JSON(16777215) |
| TEMPLATEPATH | VarChar(87) |
| TRANSACTIONAL | Boolean |
| UNPUBLISHEDAT | Timestamp(3) |
| UPDATED | Timestamp(3) |
| UPDATEDBYID | Integer |
| URL | VarChar(120) |
| USERPERMS | JSON(16777215) |
| USERSSHEADLINEASSUBJECT | Boolean |
| VIDSEXCLUDED | JSON(16777215) |
| VIDSINCLUDED | JSON(16777215) |
| VISIBLETOALL | Boolean |
| WIDGETS | JSON(16777215) |