SOCIALMEDIAMESSAGES
- Last Updated: March 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- HubSpot 8.0
- Documentation
Endpoint
https://api.hubapi.com/broadcast/v1/broadcasts
Columns
The SOCIALMEDIAMESSAGES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| CONTENTBODY* | VarChar(256) |
| CAMPAIGNGUID | GUID |
| CAMPAIGNNAME | VarChar(64) |
| CHANNEL | VarChar(64) |
| CHANNELGUID | GUID |
| CLICKS | Integer |
| CLIENTTAG | VarChar(64) |
| CONTENTORIGINALBODY | VarChar(256) |
| CONTENTPHOTOURL | VarChar(512) |
| CONTENTUNCOMPRESSEDLINKS | VarChar(256) |
| CREATEDAT | Timestamp(3) |
| CREATEDBY | Integer |
| FINISHEDAT | Timestamp(3) |
| FOREIGNID | Integer |
| GROUPGUID | GUID |
| ISFAILED | Boolean |
| ISPENDING | Boolean |
| ISPUBLISHED | Boolean |
| ISRETRY | Boolean |
| MESSAGE | VarChar(256) |
| REMOTECONTENTID | VarChar(64) |
| REMOTECONTENTTYPE | VarChar(64) |
| STATUS | VarChar(64) |
| TRIGGERAT | VarChar(64) |
| UPDATEDBY | Integer |