CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

SocialMediaMessages

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

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

InteractionsCount Integer True

The number of interactions associated with the social media message as recorded by HubSpot.

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.

Likes Integer True

The number of likes the social media message has.

LinkGUID String True

A GUID for the link associated with the message.

LinkTaskQueueId String True

The link task queue id associated with the included link.

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.

Replies Integer True

The number of replies to the social media message.

Retweets Integer True

The number of retweets of the social media message.

Status String True

The current status of the social media message.

The allowed values are SUCCESS, WAITING, CANCELED, ERROR_FATAL.

TaskQueueId String True

The task queue id associated with submitting the social media message.

UpdatedBy Integer 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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0