EmailSubscriptions
The subscription types a given email is subscribed to. An email must be specified to return results. Subscriptions may be removed by deleting them.
Table Specific Information
Email subscriptions in HubSpot represent different types of subscriptions a given contact email may be subscribed to. When deleting an email subscription the contact will be opted out and will not receive emails from the specified subscription type(mailing group). EmailSubscriptions lists the subscriptions a given email address is subscribed to.
Select
When selecting email subscriptions, an email must be provided. For example:
SELECT * FROM EmailSubscriptions WHERE Email = 'user@email.com'
Columns
| Name | Type | ReadOnly | References | Description |
| Email [KEY] | String | True |
The email address which has been subscribed. | |
| SubscriptionId [KEY] | Long | True |
The id of the subscription type. | |
| IsSubscribed | Boolean | False |
Boolean indicating if the customer is subscribed. | |
| ExtraUrlParameters | String | False |
An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. | |
| LegalBasis | String | False |
An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. The allowed values are LEGITIMATE_INTEREST_PQL, LEGITIMATE_INTEREST_CLIENT, PERFORMANCE_OF_CONTRACT, CONSENT_WITH_NOTICE, NON_GDPR, PROCESS_AND_STORE, LEGITIMATE_INTEREST_OTHER. | |
| LegalBasisExplanation | String | False |
An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. | |
| OptState | String | False |
Determines whether a contact is opted in or out of a given email subscription. If you OPT OUT of all emails or a specific email subscription type for a recipient, there is NO UNDO for this operation. The possible values are OPT_IN, OPT_OUT, and NOT_OPTED. The allowed values are OPT_IN, OPT_OUT, NOT_OPTED. |