SocialMediaMessages
Create and manage HubSpot social media messages.
Table Specific Information
Social media messages can be submitted to your social media channels to make announcements about your products or company.
SELECT
When selecting social media messages, data can be filtered by the MessageGUID or by a combination of Status, ChannelGUID, and TriggerAt. For example:
SELECT * FROM SocialMediaMessages WHERE MessageGUID = '123456789' SELECT * FROM SocialMediaMessages WHERE Status = 'WAITING' AND ChannelGUID = '123456789' AND TriggerAt > '1/30/2015'
Note that TriggerAt can only be used with the > or >= comparison.
Columns
| Name | Type | ReadOnly | References | Description |
| MessageGUID [KEY] | String | True |
The Id of the social media message. | |
| ContentBody | String | False |
The body of the content for the message. | |
| ContentOriginalBody | String | False |
The original body of the content for the message if it has been altered. | |
| ContentPhotoUrl | String | False |
The photo associatedwith the message. | |
| ContentUncompressedLinks | String | False |
Any uncompressed links associated with the message. | |
| TriggerAt | Datetime | False |
When to trigger the social media message. | |
| Channel | String | True |
The social media channel the message will be posted to. | |
| ChannelGUID | String | False |
The social media channel GUID. | |
| CampaignGUID | String | True |
The campaign GUID associated with the social media message. | |
| CampaignName | String | True |
The campaign name associated with the social media message. | |
| Clicks | Long | True |
The number of clicks HubSpot has recorded for the links in the social media message. | |
| ClientTag | String | True |
Client tags associated with the social media message. | |
| CreatedAt | Datetime | True |
When the social media message was created. | |
| CreatedBy | Long | True |
An integer indicating which user created the social mdia message. | |
| FinishedAt | Datetime | True |
When the social media message was finished posting. | |
| ForeignId | String | True |
An optional ForeignId associated with the social media message. | |
| GroupGUID | String | True |
The group GUID associated with the social media message. | |
| IsFailed | Boolean | True |
A boolean indicating if the message has failed to post. | |
| IsPending | Boolean | True |
A boolean indicating if the message is pending a post. | |
| IsPublished | Boolean | True |
A boolean indicating if the message has been posted. | |
| IsRetry | Boolean | True |
A boolean indicating if the message is being retried. | |
| Message | String | True |
The message that came back from the social media site if any. This may contain an error message if the social media message failed if the status is ERROR_FATAL. | |
| MessageUrl | String | True |
A url associated with the message that came back from the social media site. This may simply be a link to the social media posting if the status is SUCCESS. | |
| RemoteContentId | String | True |
A remote content id if any. | |
| RemoteContentType | String | True |
The remote content type if any. | |
| Status | String | True |
The current status of the social media message. The allowed values are SUCCESS, WAITING, CANCELED, ERROR_FATAL. | |
| UpdatedBy | Long | True |
An integer indicating who last updated the social media message. | |
| ExtraUrlParameters | String | True |
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'. |