Navigation: Catalog: MarketingEmails > Schemas > Schema: Emails > Tables

MarketingVEmailsByEmailIdRevisions_ObjectUsersWithAccessRevisionId

Get a revision of a marketing emailGet a specific revision of a marketing email.

Catalog: MarketingEmails

Schema: Emails

This is a read-only table function. The HubSpot API may not support changing the data or the Invantive UniversalSQL driver for HubSpot does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the HubSpot API.

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function MarketingVEmailsByEmailIdRevisions_ObjectUsersWithAccessRevisionId. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
emailId		☑
revisionId		☑

Columns of Table Function

The columns of the table function MarketingVEmailsByEmailIdRevisions_ObjectUsersWithAccessRevisionId are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
activeDomain	varchar2		☐	The active domain of the email.
archived	char	Archived	☐	Determines if the email is archived or not.
businessUnitId	varchar2		☐
campaign	varchar2	Campaign	☐	The ID of the campaign this email is associated to.
campaignName	varchar2	Campaign Name	☐	The name of the campaign.
campaignUtm	varchar2		☐
clonedFrom	varchar2		☐	The ID of the email this email was cloned from.
content_flexAreas	varchar2		☐
content_plainTextVersion	varchar2		☐
content_smartFields	varchar2		☐
content_styleSettings_backgroundColor	varchar2		☐
content_styleSettings_backgroundImage	varchar2		☐
content_styleSettings_backgroundImageType	varchar2		☐
content_styleSettings_bodyBorderColor	varchar2		☐
content_styleSettings_bodyBorderColorChoice	varchar2		☐
content_styleSettings_bodyBorderWidth	decimal		☐
content_styleSettings_bodyColor	varchar2		☐
content_styleSettings_buttonStyleSettings_backgroundColor	varchar2		☐
content_styleSettings_buttonStyleSettings_cornerRadius	int32		☐
content_styleSettings_buttonStyleSettings_fontStyle_bold	char		☐
content_styleSettings_buttonStyleSettings_fontStyle_color	varchar2		☐
content_styleSettings_buttonStyleSettings_fontStyle_font	varchar2		☐
content_styleSettings_buttonStyleSettings_fontStyle_italic	char		☐
content_styleSettings_buttonStyleSettings_fontStyle_size	int32		☐
content_styleSettings_buttonStyleSettings_fontStyle_underline	char		☐
content_styleSettings_colorPickerFavorite1	varchar2		☐
content_styleSettings_colorPickerFavorite2	varchar2		☐
content_styleSettings_colorPickerFavorite3	varchar2		☐
content_styleSettings_colorPickerFavorite4	varchar2		☐
content_styleSettings_colorPickerFavorite5	varchar2		☐
content_styleSettings_colorPickerFavorite6	varchar2		☐
content_styleSettings_dividerStyleSettings_color	varchar2		☐
content_styleSettings_dividerStyleSettings_height	int32		☐
content_styleSettings_dividerStyleSettings_lineType	varchar2		☐
content_styleSettings_emailBodyPadding	varchar2		☐
content_styleSettings_emailBodyWidth	varchar2		☐
content_styleSettings_headingOneFont_bold	char		☐
content_styleSettings_headingOneFont_color	varchar2		☐
content_styleSettings_headingOneFont_font	varchar2		☐
content_styleSettings_headingOneFont_italic	char		☐
content_styleSettings_headingOneFont_size	int32		☐
content_styleSettings_headingOneFont_underline	char		☐
content_styleSettings_headingTwoFont_bold	char		☐
content_styleSettings_headingTwoFont_color	varchar2		☐
content_styleSettings_headingTwoFont_font	varchar2		☐
content_styleSettings_headingTwoFont_italic	char		☐
content_styleSettings_headingTwoFont_size	int32		☐
content_styleSettings_headingTwoFont_underline	char		☐
content_styleSettings_linksFont_bold	char		☐
content_styleSettings_linksFont_color	varchar2		☐
content_styleSettings_linksFont_font	varchar2		☐
content_styleSettings_linksFont_italic	char		☐
content_styleSettings_linksFont_size	int32		☐
content_styleSettings_linksFont_underline	char		☐
content_styleSettings_primaryAccentColor	varchar2		☐
content_styleSettings_primaryFont	varchar2		☐
content_styleSettings_primaryFontColor	varchar2		☐
content_styleSettings_primaryFontLineHeight	varchar2		☐
content_styleSettings_primaryFontSize	decimal		☐
content_styleSettings_secondaryAccentColor	varchar2		☐
content_styleSettings_secondaryFont	varchar2		☐
content_styleSettings_secondaryFontColor	varchar2		☐
content_styleSettings_secondaryFontLineHeight	varchar2		☐
content_styleSettings_secondaryFontSize	decimal		☐
content_templatePath	varchar2		☐
content_themeSettingsValues	varchar2		☐
content_widgetContainers	varchar2		☐
content_widgets	varchar2		☐
createdAt	datetime	Created at	☐	The date and time of the email's creation, in ISO8601 representation.
createdById	varchar2	Created by ID	☐	The id of the user who created the email.
deletedAt	datetime	Deleted at	☐	The date and time the email was deleted at, in ISO8601 representation.
emailCampaignGroupId	varchar2		☐
emailTemplateMode	varchar2		☐
feedbackSurveyId	varchar2		☐	The ID of the feedback survey linked to the email.
folderId	int64	Folder ID	☐
folderIdV2	int64		☐
from_customReplyTo	varchar2		☐	The reply to recipients will see.
from_fromName	varchar2		☐	The name recipients will see.
from_replyTo	varchar2		☐	The from address and reply to email address (if no customReplyTo defined) recipients will see.
id_2	varchar2	ID (Alternate 2)	☐
id	varchar2	ID	☐	The email ID.
isAb	char		☐
isPublished	char		☐	Returns the published status of the email. This is read only.
isTransactional	char		☐	Returns whether the email is a transactional email or not. This is read only.
jitterSendTime	char		☐
language	varchar2	Language	☐
name	varchar2	Name	☐	The name of the email, as displayed on the email dashboard.
previewKey	varchar2		☐
primaryEmailCampaignId	varchar2		☐
publishDate	datetime	Publish Date	☐	The date and time the email is scheduled for, in ISO8601 representation. This is only used in local time or scheduled emails.
publishedAt	datetime	Published at	☐	The date and time the email was published at, in ISO8601 representation.
publishedByEmail	varchar2		☐	Email of the user who published/sent the email.
publishedById	varchar2		☐	The ID of the user who published the email.
publishedByName	varchar2		☐	Name of the user who published the email.
rssData_blogEmailType	varchar2		☐
rssData_blogImageMaxWidth	int32		☐
rssData_blogLayout	varchar2		☐
rssData_hubspotBlogId	varchar2		☐
rssData_maxEntries	int32		☐
rssData_rssEntryTemplate	varchar2		☐
rssData_timing	varchar2		☐
rssData_url	varchar2		☐
rssData_useHeadlineAsSubject	char		☐
sendOnPublish	char		☐	Determines whether the email will be sent immediately on publish.
state	varchar2	State	☐	The email state.
stats_counters	varchar2		☐	Counters like number of `sent`, `open` or `delivered`.
stats_deviceBreakdown	varchar2		☐	Statistics by device.
stats_qualifierStats	varchar2		☐	Number of emails that were dropped and bounced.
stats_ratios	varchar2		☐	Ratios like `openratio` or `clickratio`
subcategory	varchar2	Subcategory	☐	The email subcategory.
subject	varchar2		☐	The subject of the email.
subscriptionDetails_officeLocationId	varchar2		☐	ID of the selected office location.
subscriptionDetails_preferencesGroupId	varchar2		☐
subscriptionDetails_subscriptionId	varchar2		☐	ID of the subscription.
subscriptionDetails_subscriptionName	varchar2		☐
testing_abSampleSizeDefault	varchar2		☐	Version of the email that should be sent if there are too few recipients to conduct an AB test.
testing_abSamplingDefault	varchar2		☐	Version of the email that should be sent if the results are inconclusive after the test period, master or variant.
testing_abStatus	varchar2		☐	Status of the AB test.
testing_abSuccessMetric	varchar2		☐	Metric to determine the version that will be sent to the remaining contacts.
testing_abTestPercentage	int32		☐	The size of your test group.
testing_hoursToWait	int32		☐	Time limit on gathering test results. After this time is up, the winning version will be sent to the remaining contacts.
testing_isAbVariation	char		☐
testing_testId	varchar2		☐	The ID of the AB test.
TEXT	varchar2	Text	☐
to_limitSendFrequency	char		☐
to_suppressGraymail	char		☐	Whether to send to unengaged contacts (false) or not (true).
type	varchar2	Type	☐	The email type, this is derived from other properties on the email such as subcategory.
unpublishedAt	datetime		☐
updatedAt_2	datetime		☐
updatedAt	datetime	Updated at	☐	The date and time of the last update to the email, in ISO8601 representation.
updatedById	varchar2	Updated by ID	☐	The id of the user who last updated the email.
user_email	varchar2	User Email	☐	Email address of the user.
user_fullName	varchar2	User Full Name	☐	First and last name of the user.
user_id	varchar2	User ID	☐	ID of the user.
webversion_domain	varchar2		☐
webversion_enabled	char		☐
webversion_expiresAt	datetime		☐
webversion_isPageRedirected	char		☐
webversion_metaDescription	varchar2		☐
webversion_pageExpiryEnabled	char		☐
webversion_redirectToPageId	varchar2		☐
webversion_redirectToUrl	varchar2		☐
webversion_slug	varchar2		☐
webversion_title	varchar2		☐
webversion_url	varchar2		☐

Please enable JavaScript to view this site.

HubSpot API Data Model

MarketingVEmailsByEmailIdRevisions_ObjectUsersWithAccessRevisionId

Parameters of Table Function

Columns of Table Function

Important Safety and Usage Information