JDBC Driver for HubSpot

Build 22.0.8462

SocialMediaChannels

List available social media channels in HubSpot

Table Specific Information

Social media channels in HubSpot represent any social media accounts you have connected for the purposes of posting marketing messages to. Messages can be posted to your social media channels via SocialMediaMessages.

Select

When selecting social media channels, data can only be filtered by the ChannelGUID. For example:

SELECT * FROM SocialMediaChannels WHERE ChannelGUID='123456789'

Columns

Name Type References Description
ChannelGUID [KEY] String The social media channel GUID.
AccountGUID String The account GUID associated with the social media channel.
AccountSlug String The account slug.
AccountType String The type of account.
IsActive Boolean A boolean indicating if the channel is active.
AutoPublish Boolean A boolean indicating if messages should be automatically published to the channel.
AvatarUrl String A url to the avatar for your account on the social medial channel.
ChannelId String The id for the channel on the social media site.
ChannelKey String A HubSpot key associated with the channel.
ChannelSlug String The slug associated with the channel.
CreatedAt Datetime When the channel was created.
FollowMe Boolean A boolean indicating if the channel should be followed.
IsHidden Boolean A boolean indicating if the channel is hidden.
Monitoring Boolean A boolean indicating if the channel should be monitored.
Reach Boolean A boolean indicating if tracking the growth of followers on this account over time should be enabled.
ReachType String The type of reach for this social media channel.
IsShared Boolean A boolean indicating if this social media channel is shared.
Type String The type of social media channel.
UpdatedAt Datetime When this social media channel was last updated.
UserName String The user name for the social media channel.
ExtraUrlParameters String 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