JDBC Driver for HubSpot

Build 22.0.8462

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'.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462